Microsoft.Data.Sqlite: No SqliteDataAdapter

[faib920]

No SqliteDataAdapter is inconvenient to batch update data.

[Perksey]

I made a custom one for Beagle Framework, the entirety of it is found here: https://github.com/aspnet/Microsoft.Data.Sqlite/issues/523#issue-328782809

[Perksey]

Also, I believe this has been requested many times before, but the developers passed it as "old-fashioned".

So this is a duplicate of #455, read up on the conversation on there.

[bricelam]

@DylanFPS So there's actually no code for generating DML? If that's the case, we may be more open to accepting a PR...

[Perksey]

@bricelam A code snippet wouldn't make sense out of context, so here is the file that generates commands:
https://hub.ultz.co.uk/code/projects/BF/repos/beagle/browse/Ultz.BeagleFramework/Sql/SqlTable.Commands.cs

In that repo, the Ultz.BeagleFramework.Sqlite project is the SQLite implementation.

[Perksey]

The SqliteDataAdapter works as expected, however its the dynamic type system that really messes up DataTables. Once there's a solution for this, I might PR.

[bnuzhouwei]

Why this issue goes so slow, CreateDataadapter method return null, that lead cann't upgrade the net48 app to net6, so sad

[coredreamsolutions]

Does your fix work on .NET 6? I had to go back to System.Data.Sqlite which surprisingly now works in .NET 6.

[pmcfernandes]

Try this:

SqliteCommand cmd = (SqliteCommand)SqliteFactory.Instance.CreateCommand();
cmd.CommandText = strSQL;
cmd.Connection = conn;

DataTable dt;

using (SqliteDataReader dr = cmd.ExecuteReader())
{
     do
     {
                dt = new DataTable();
                dt.BeginLoadData();
                dt.Load(dr);
                dt.EndLoadData();

     } while (!dr.IsClosed && dr.NextResult());
}