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]. > 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]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
