Cascading Grids in a Blazor Application - Part 2

A Blazor application demonstrating the use of cascading grids. This is part 2 of a series that takes a step by step approach in creating a Blazor application that will calculate the total wall area of a room. In this video we install DB Browser for SQLite and add the database and tables (using a script). Back in the C# project we add a connection string to link the data to the project and finally add the model classes for the tables.
Playlist for Cascading Grids: • Blazor Cascading Grids
Resources:
Documentation: blazorcode.uk/wallareacalcula...
DB Browser for SQLite: sqlitebrowser.org/dl/

[@atirah14]

Completed this one as well. Fairly straightforward until now. Have you used postgres as a database?

[@christopherbell7186]

Well done. No, I haven't ever used Postgres, but it looks interesting - perhaps I should take a look.

[@richardwilliamson9433]

Great work! Can you post the solution file please?

[@christopherbell7186]

You can find the files for this video on the blog post at blazorcode.uk/wallareacalculator/database/index.html
From Part 3 onwards I have put the code on Github. See the Releases at: github.com/ChristopherJBell/BlazorWallAreaCalculator/releases.
I hope this helps...

[@gamingarea.eltayeb]

How can i open db file in sqlcipher
File has password and i can't open it ?

[@christopherbell7186]

I'm afraid I am not familiar with SQLCipher. Does their documentation help? www.zetetic.net/sqlcipher/documentation/ or look at this StackOverflow question & answer stackoverflow.com/questions/52215911/how-to-use-sqlcipher-in-net

[@abdokha6227]

Whay Using SQLLite ?

[@christopherbell7186]

Good question! My preference would naturally be Microsoft SQL Server, (it has the advantage of stored procedures for a start), but if one wants to publish to Azure there is (potentially) a charge for Microsoft SQL Server, but SQLite is free.