Monday, March 19, 2012

Examples of OleDb with SQL Server Compact Edition

Hello,

My C# .NET application is currently using the System.Data.OleDb namespace to access SQL Server 2000 and SQL Server Express databases. I would like to begin using SQL Server Compact Edition to access a local database that has the same structure as the others. I'd like to use the same code regardless of the data source, so I would prefer to use System.Data.OleDb instead System.Data.SqlServerCe.

Where can I find examples of the use of System.Data.OleDb with SQL Server Compact Edition? Some of the specific questions I have are:

1.) How do I build the connection string for the OleDbConnection object?

2.) What are the limitations, if any, of using OleDb instead of SqlServerCe?

I will appreciate any help you can provide.

Thank you,

WTW

re 1: Use this provider name: PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

No comments:

Post a Comment