What are the best practices to creating a Generic DataAccess Layer in C# 3.5. Dose LINQ to SQL have any support for Other DataSources like MySQL , Oracle etc.
+2
A:
LINQ to SQL is SQL Server only, and is likely to remain that way. If you want support for other databases then use LINQ To Entities. You can read a comparison between LINQ to SQL and LINQ to Entities here.
Dan Diplo
2009-08-04 21:04:38
Any Examples ?.
Greens
2009-08-04 21:06:20
Maybe this will help? http://stackoverflow.com/questions/75959/how-to-implement-database-independence-with-entity-framework
Dan Diplo
2009-08-05 09:19:57
A:
Depending on your needs, you may want to investigate NHibernate. The learning curve is a bit steep, but there are many web resources to help you along the way.
It has native support for Sql Server, MySql, Oracle, Postgres, Sqlite, DB2 and others.
JBland
2009-08-05 00:52:32