How to write same ado.net code for SQL Server and SQL Server Compact?

Question

I am developing an application. Client wants application to run on two databases, SQL Server Compact Edition and SQL Server.

Now the problem is in Visual Studio in dataset you have to program twice for different database.

That will double my work. Is there any way I could use same dataset and datatable code to interact with both the objects?

Sorry, mistype. Any ORM, for example use Entity Framework, or try using LINQ ORM, it's like a data layer between you and DB. — Johnny_D
– Johnny_D, Commented Apr 12, 2012 at 14:59

Marcus · Accepted Answer · 2012-04-22 18:07:07Z

2

By using DbProviderFactories (see http://msdn.microsoft.com/en-us/library/wda6c36e.aspx) it's possible to specify provider in the connection string and write code that works with multiple providers (different databases).

Then make sure that your code uses base classes such as DbConnection and DbDataReader instead of provider specific classes like SqlConnection and SqlDataReader.

edited Apr 22, 2012 at 18:07

answered Apr 12, 2012 at 14:49

Marcus

2,5001 gold badge22 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to write same ado.net code for SQL Server and SQL Server Compact?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related