How to create an instance of SQLiteDataProviderClassic in a class derived from DataConnection

[alexey-leonovich]

I have a class derived from DataConnection and in it's .ctor I call : base(IDataProvider dataProvider, DbConnection connection). But I cannot pass neither new SQLiteDataProvider(ProviderName.SQLiteClassic) nor new SQLiteDataProviderClassic() (first one is abstract, last one is internal). I had to create a provider derived from SQLiteDataProvider (in its .ctor I call : base(ProviderName.SQLiteClassic)) - but is that correct? For example SqlCeDataProvider is public and in same situation I can create it directly.

[MaceWindu]

To get provider instance, use <DB>Tools.GetDataProvider method. In your case:

SQLiteTools.GetDataProvider(ProviderName.SQLiteClassic)

[alexey-leonovich]

Should I use this method for all providers (e. g. use SqlCeTools.GetDataProvider() instead of new SqlCe.SqlCeDataProvider())?
Thank you.

[MaceWindu]

Yes. You shouldn't create new provider instances if you don't modify provider itself.