There are a few more things you might want to consider when creating a RDBMS-agnostic app. I wrote about that last month: http://stackoverflow.com/questions/2626247/recommendations-for-supporting-both-oracle-and-sql-server-in-the-same-asp-net-app/2626552#2626552
(there are of course more things to consider, but that's what I came up with then :-)) Diego On Thu, May 6, 2010 at 09:35, fknebels <[email protected]> wrote: > I agree with Oskar. I am currently supporting a product that was > based in SQL Server, but got ported to Oracle for a client. I am > using fluent NHibernate for the configuration. switching between the > database is easy. I just check for a key in the web.config for > OracleConnectionString or SqlServerConnection string, then build the > SessionFactory accordingly. > > I am using the CriteriaAPI for querying the database. This provides a > nice, db agnostic way of generating queries. > > On May 6, 5:59 am, Rajesh Chaudhary <[email protected]> wrote: > > Hi, > > we want that our web based product supports multiple databases so can > > we use nhibernate in .net for this purposes ? If yes then what > > architecture we need to implement so we can switch any database as per > > our customer need and how much effort it will require? > > > > Should we also need to use LINQ with NHibernate? > > > > -- > > You received this message because you are subscribed to the Google Groups > "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > > For more options, visit this group athttp:// > groups.google.com/group/nhusers?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en.
