Using the DbProviderFactoryRepository

gistfile1.cs

// Initialize the repository.
var repository = new DbProviderFactoryRepository();
 
// Create a description manually and add it to the repository.
var manualDescription = new DbProviderFactoryDescription();
manualDescription.Description = ".NET Framework Data Provider for Microsoft SQL Server Compact";
manualDescription.Invariant = "System.Data.SqlServerCe.3.5";
manualDescription.Name = "Microsoft SQL Server Compact Data Provider";
manualDescription.Type = "System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe";
 
repository.Add(manualDescription);
 
// Use the default SqlCe35 provider.
repository.Add(new SqlCe35ProviderFactoryDescription());