Hi, I use Castle MonoRail, and Castle Active Record (which uses NHibernate). I initially used SQL Server as my database but I switched to using Postgresql. When I switched I didn't need to make any C# code changes, I only had to update my Active Record configuration section in my web.config file. Database flexibility is differently a great advantage to using an ORM. Nhibernate does allow calls to stored procedures. Visual Studio allows you to mix vb.net projects with c# project in your solution, so you use both in your solution. You have to pick either vb.net or c# at the project level though. So, if you choose you can have vb.net web project, and use the Castle Active Record C# project(s) in your solution.
On Sun, Apr 5, 2009 at 3:31 PM, novnov <[email protected]> wrote: > > This is really a scattershot question because I have little exposure > to ORMs and only vaguely formulated requirements. > > Some background...I like postgresql a lot and also use sql server and > oracle. I/we are usually responsible for all of the parts of an app, > from the rdbms to the user interface. We do a lot on Windows with .net > (visual basic) but are getting exposure to flex on the interface side > of things. So far we've been able to keep clear of ORMs and code > generators. > > A project is coming up which will need be be deployed against both > postgresql and oracle (different deploys). This may be forcing us to > use an ORM so that the interface is more independent of the rdbms. > > Is NHibernate and maybe Castle Project Active Record a good solution > for our needs? The ORM would not have to be open source, ie we could > buy something. We want it to be as simple to pick up and use as > possible. We don't want to lose the ability to execute procs in > postgres and I'm worried that nhibernate has that limitation, as the > front page states that stored procedures are supported for sql server. > > Finally, is Active Record ok with visual basic? Most if not all of the > examples are in C#. > > > > -- David J. Driscoll www.EnduroTracker.com EnduroTracker.BlogSpot.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
