0

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.

Greens
  • 3,061
  • 11
  • 43
  • 61

2 Answers2

2

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
  • 25,076
  • 4
  • 67
  • 89
  • Maybe this will help? http://stackoverflow.com/questions/75959/how-to-implement-database-independence-with-entity-framework – Dan Diplo Aug 05 '09 at 09:19
0

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
  • 1,263
  • 10
  • 13