How to use SQLite in your Blazor WebAssembly apps

[@owner2959]

Next, please make a WASM/PWA App that will use Dapper and SQLite to perform CRUD.

[@MohiyoDeen]

thats a very nice suggestion, hope @Jeremy will deliver

[@JohnMarsing]

Nice.
6:20
I like how you can access the cached blob and export it

[@abdussalamashuaebi7185]

Thank you for this video, Is there update for. Net7

[@jorgepedraza1275]

Is there a way to access the sqlite database outside of the browser session, for example in a folder on disk?

[@stefanboon]

How do you clear the .db file from within the blazor app?

[@SuperSteini89]

is it possiple to change the entity afterwards. Create different Migrations for example

[@davidheale6435]

Hey Jeremy, any chance you'll be updating your package to include stable versions of Eric Sink's projects?

[@JeremyLikness]

Yes I'll look into that.

[@eliezerbwana2526]

Thank you for the video.

[@JeremyLikness]

You're welcome

[@Spylak]

Awesome! I was checking if there is a way to do the same with indexeddb, do you think it's possible ( for more permanent storage).

[@JeremyLikness]

Yes. In fact, you should just be able to swap out the JavaScript file with one that uses indexedDb. Cache Database, Path Key, Response File.

[@Spylak]

@@JeremyLikness Thank you, I will give it a shot!

[@Gonkers44]

The audio was of poor quality for me, however great content. I love the idea! Thanks for sharing.

[@after2003]

Hey Jeremy, I am having issues when persisting objects with properties of type "double" to sqlite database. The package works fine with integers and strings but I could not get it to work with double properties. I would appreciate any help.

[@EricKing]

Very nice. I have a project that can use this. Thanks!

[@EricKing]

Took me about 10 minutes to set it up and hook it into my Fluxor store. Works like a charm! I'll be keeping an eye on this. Thanks again.

[@dhirenpathak]

Hi can you make one videos to Blazor Hybrid crud using SQL server?? Web and native ??? Help me how to make this ?? Can we use Razor class lib

[@codigoadictivo]

Hi, is there a way to do this but with "sqlite-net-pcl" nugget package?

[@Mercdad320]

This does not work on a new blank project of Blazor Web Assembly (with individual accounts, .net 6, PWA) - the error is:
Microsoft.AspNetCore.Components.WebAssembly.Rendering.WebAssemblyRenderer[100]
Unhandled exception rendering component: The type initializer for 'Microsoft.Data.Sqlite.SqliteConnection' threw an exception.
System.TypeInitializationException: The type initializer for 'Microsoft.Data.Sqlite.SqliteConnection' threw an exception.
---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
---> System.DllNotFoundException: e_sqlite3
at SQLitePCL.SQLite3Provider_e_sqlite3.SQLitePCL.ISQLite3Provider.sqlite3_libversion_number()
at SQLitePCL.raw.SetProvider(ISQLite3Provider imp)
at SQLitePCL.Batteries_V2.Init()
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
--- End of inner exception stack trace ---
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
at Microsoft.Data.Sqlite.Utilities.BundleInitializer.Initialize()
at Microsoft.Data.Sqlite.SqliteConnection..cctor()
--- End of inner exception stack trace ---
at Microsoft.EntityFrameworkCore.Sqlite.Storage.Internal.SqliteRelationalConnection.CreateDbConnection()
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)
at Microsoft.EntityFrameworkCore.Sqlite.Storage.Internal.SqliteDatabaseCreator.Exists()
at Microsoft.EntityFrameworkCore.Storage.RelationalDatabaseCreator.ExistsAsync(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalDatabaseCreator.EnsureCreatedAsync(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalDatabaseCreator.EnsureCreatedAsync(CancellationToken cancellationToken)
at SqliteWasmHelper.SqliteWasmDbContextFactory`1.d__14

[@TheHershHDx]

Hi, if you're still having this issue and following the video, the program property has to be true instead of true

[@dhirenpathak]

Great

[@dhirenpathak]

Good

[@gerocsolutionsltd456]

is it possible to load downloaded dataset into sql lite when application opens?