CODEWITHSUNDEEP
genericsdata-access-layer
Greens
Greens

Reputation: 3057

Generic DataAccess Layer in C# 3.5

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.

Upvotes: 0

Views: 2195

Answers (2)

JBland
JBland

Reputation: 1263

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.

Upvotes: 0

Dan Diplo
Dan Diplo

Reputation: 25339

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.

Upvotes: 2

Related Questions