Entity Framework & SQLite in a Blazor WebAssembly Application | Blazor Blog Series #4
HTML-код
- Опубликовано: 4 ноя 2020
- 🔥 Get up to 95% discount on the Blazor WebAssembly Full Stack Bootcamp: www.udemy.com/course/blazor-w...
☕ Buy me a coffee: www.buymeacoffee.com/patrickgod
💻 Code on GitHub: github.com/patrickgod/BlazorBlog
#Blazor #EntityFramework #PatrickGod
Thumbnail Image by katemangostar - freepik.com (www.freepik.com/free-vector/b...)
Hi Patrick, your Blazor Blog series #1 to #4 are great and clarified a lot for me, as I was not able to get the full picture until I watched your videos. I would suggest to add a playlist for your Blazor Blog series #-videos as well as they are not part of your E-commerce series.
Thank you so much and you are so right. Totally forgot about that. Here's the playlist: ruclips.net/p/PLF1jhYUTnHo5XFX9lgS0YsNSDJHpYnRxK
Thank you for sharing this great series.
Thank you for your great comment. :)
Dont know if you guys cares but if you are bored like me during the covid times you can stream pretty much all of the latest series on InstaFlixxer. Been watching with my gf for the last months xD
@Darius Kasen Definitely, have been using instaflixxer for since december myself =)
I am new to blazor, but the "startup.cs" is only in server app ? Not web assembly, no ?
I don't have any startup.cs in a web assembly app, but it's say "web assembly" in the title of the video.
But really helpfull video, we plan to make an computer / smartphone app, with a offline mode, so local db using sqlite is great :D
Yep, only on the server. The corresponding file in the client project is the Program.cs. It's an ASP.NET hosted application, that's why we also have the server and the shared project. Hope this helps!
@@PatrickGod Oh ok, thanks !
@@HaiDeuZ You're welcome! :)
Thanks again Patrick. Small comment: during the migration the CreateDate field of Type DateTime (of the class BlogPost) is converted to a Text field in the Sqlite causing some headaches in figuring out what went wrong ;-)
Oh, thanks for pointing that out. How did you fix this?
@@PatrickGod Not really a fix, i just skipped the field ;-).... hey, i'm just started to learn ;-)
@@pm-fl5kw As long as it works. ;)
Patrick, is SQLite your first choice as a lightweight RDBMS? Did you consider other RDBMS aside SQLite and, maybe, SQL server CE?
Hi Pavlo, Thanks for asking. Usually I would use SQL Server Express. But lots of people need a cross-plattform solution, so I went with SQLite. :) Take care, Patrick
Is it okay to store user accounts in SQLite? Like if I want to have an admin user and an author user can I set this up? I’m just wondering how secure a SQLite db is since you can’t set a username and password.
where is the repository for GetBlogPosts
For anyone on dotnet 7 the line for the dbcontext in Program.cs needs (x => x.UseSqlite(builder.Configuration…………
Thanks.
that was a Fire
sorry we let you tired at 6 man 😂
No worries! Glad you like the video. :)
Hi Patrick , normally for web u use indexdb. Any cons for using sqlite with blazor ? will the sqlite db file always exist in the browser , is there a risk that the browser might delete this db file ?
Hi Johan. The SQLite database is on the server, so there's no risk that the database will be deleted by the browser. :) Hope this helps!
@@PatrickGod Sorry my bad here, under the impression u got sqlite working client side.
@@johanmulder3940 No worries! :)
2:37
This isn't a Blazor WebAssembly project but a Blazor Server project, right? Is the title a mistake or am i missing something?
Hey! It's a Blazor WebAssembly ASP. Net Core hosted project, hence you get a solution with a client, server and shared project. But it's NOT Blazor Server. Definitely Blazor WebAssembly. Hope this helps! Take care.