Provider Independent Programming

 

Have you heard of Provider Agnostic Programming aka Base Class Provider Model aka Provider Independent Programming?

If not, read it out here: https://msdn2.microsoft.com/en-us/library/t9f29wbk.aspx

Well why am I writing about that article on this blog?

SQL Server Compact Edition supports this (rather adheres to these guidelines). The invariant names for different releases/versions of SQL Server Compact Edition are:

Version

Invariant Name

Supported .NET Frameworks

3.1

System.Data.SqlServerCe

.NET FX 2.0

3.5

System.Data.SqlServerCe.3.5

.NET FX 2.0, .NET FX 3.5

4.0

System.Data.SqlServerCe.4.0

Not yet released and tentative

Thanks,

Laxmi Narsimha Rao ORUGANTI