Support Microsoft SQLite Provider

[QianMoXi]

Register:
optionsBuilder.UseLinqToDB(x => x.AddCustomOptions(o => o.UseSQLiteMicrosoft()))

When creating a connection, will throw an exception:
dbContext.CreateLinqToDBConnection()

LinqToDB.EntityFrameworkCore.LinqToDBForEFToolsException : Can not instantiate data provider 'SQLite.MS'.
at LinqToDB.EntityFrameworkCore.LinqToDBForEFToolsImplDefault.CreateLinqToDBDataProvider(EFProviderInfo providerInfo, LinqToDBProviderInfo provInfo, EFConnectionInfo connectionInfo)
at LinqToDB.EntityFrameworkCore.LinqToDBForEFToolsImplDefault.<>c__DisplayClass4_0.<GetDataProvider>b__0(ProviderKey k)
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
at LinqToDB.EntityFrameworkCore.LinqToDBForEFToolsImplDefault.GetDataProvider(DataOptions options, EFProviderInfo providerInfo, EFConnectionInfo connectionInfo)
at LinqToDB.EntityFrameworkCore.LinqToDBForEFTools.GetDataProvider(DataOptions options, EFProviderInfo info, EFConnectionInfo connectionInfo)
at LinqToDB.EntityFrameworkCore.LinqToDBForEFTools.CreateLinqToDBConnection(DbContext context, IDbContextTransaction transaction)

Is this provider not supported or did you forget to add it?

linq2db.EntityFrameworkCore/Source/LinqToDB.EntityFrameworkCore/LinqToDBForEFToolsImplDefault.cs

Lines 181 to 182 in 44de54e

	case ProviderName.SQLite:
	return SQLiteTools.GetDataProvider(provInfo.ProviderName);

[MaceWindu]

There is no need to specify exact provider for sqlite, but agree that we should accept specific name too

[QianMoXi]

@MaceWindu I set it because my app is published as a single file, and the following code cannot correctly detect the assembly I am using

https://github.com/linq2db/linq2db/blob/3cff24499ad2a43547920c4eaa55c245097e32ca/Source/LinqToDB/DataProvider/SQLite/SQLiteTools.cs#L63C1-L78C4

I can solve the problem with SQL server in this way, but it does not work for sqlite

optionsBuilder.UseLinqToDB(x => x.AddCustomOptions(o => o.UseSqlServer(SqlServerVersion.v2008, SqlServerProvider.MicrosoftDataSqlClient)))

[QianMoXi]

I've found a solution to this problem:

optionsBuilder.UseLinqToDB(x => x.AddCustomOptions(o => o.UseDataProvider(SQLiteTools.GetDataProvider(ProviderName.SQLiteMS))))