Idea: WebSQL Provider (Sqlite on Blazor)

[grahamehorner]

now that the blazor project is an official research project at Microsoft please consider creating a client side entity framework core provider for WebSQL so that blazor client can work with local data storage and utilise the power of entity framework core, linq etc.

[ajcvickers]

@grahamehorner This is an interesting idea that has been discussed recently, but we're not 100% sure that EF is a good fit here. Assigning to @divega to follow up more.

[grahamehorner]

@ajcvickers understand, the reason for asking was that IMHO if EF Core was able to target WebSQL within Blazor/Mono wasm runtime this would bring a great benefits to the developer have aligned data access in both client/server and allow client side caching of data and possibly offline functionality.

[HalidCisse]

Very useful for electron apps, where frontend size is not big issue.
Electron + blazor + EfCore = ?

[divega]

Here are some initial thoughts on this (based on a conversations with @SteveSandersonMS):

Reasons EF Core may not be a good fit for Blazor:

• Size constraints: I don't know what the effective constraints are, but perhaps @SteveSandersonMS can provide some more information. Presumably this maybe less of an issue for Electron apps (as mentioned above in the thread)?
• Reliance on executing LINQ expressions that are compiled and cached at run-time, which Blazor may not be efficient at

Reasons EF Core may be a good fit for WebSQL:

• We already have a Sqlite provider, so this should at least be less work than IndexDB

Regardless, we may want to have an EF Core-like experience for Blazor. We will keep this issue in the backlog, waiting to learn more.

[mpaine-act]

I'm not sure if it helps, but github has various examples of modern SQLite compiled to WebAssembly. If that is functional, WebSQL Provider wouldn't be necessary.

[970065574]

I'm not sure if it helps, but github has various examples of modern SQLite compiled to WebAssembly. If that is functional, WebSQL Provider wouldn't be necessary.

can you recall that example link please? I am looking for the Blazor webassembly with sqlite (without .net core hosted).

[bricelam]

See also #18908

[ajcvickers]

Note from triage: we don't plan to support this directly in EF Core, but we do want to support/enable external efforts to compile and use SQLite in WASM.