Viacheslav Eremin | My first Progressive Web App (PWA)

(MVC) MVC (2022)

1. Local Storage
2. AsyncJS
3. ServiceWorker
4. SQL JSON
5. EF composite key
6. Initialization ASP.NET DI container - DAL service, Swagger, CORS, AU, EF, SQL.
7. Working with Claim.
8. Working with custom Attributes and Reflection.
9. Pwa lecture and book
10. Related pages

My first Progressive Web App (PWA) - useful links.

In past year I made native Android apps and you can see a couple of small description from that project:

And very often I made site specially for mobile phone, for example:

But in this year I'm faced with my first Progressive Web App. This application can working offline and has some another interesting future.

Unfortunately russian invasion to Ukraine brake this project, I'm have to going out of Ukraine and project stopped. However I can show in this page a couple screen from key future of this application and I can collect useful links about PWA below.

1. Local Storage

Project working with Local Storage.

2. AsyncJS

Project uses asynchronous JS construction like Promise.

Also project used new JS future like Class.

W3Scool JavaScript Class

And CryptoJS to move to server SHA256-hash of password.

crypto-js NPM

3. ServiceWorker

Of course, main future of PWA is using ServiceWorker.

4. SQL JSON

Database of this project is always present, this is interesting DB with actively using JSON processing into SQL.

Usually I'm handle XML inside SQL, see for example

XML (2009) SQL-Client_for_remote_XML-WebService - client to meteonova.ru
XML (2009) How to parse XML SOAP inside MS SQL

But I never so far parse JSON inside SQL. And currently I have other project with parsing JSON inside SQL. Therefore I decide create separate page where I have collected useful links about SQL JSON SqlJson useful links.

5. EF composite key

Database for this project is always present and was be unusual. For example tables has composite key, so unique key can be compose only with combine a couple of tables. This is my first project where I create composite key.

6. Initialization ASP.NET DI container - DAL service, Swagger, CORS, AU, EF, SQL.

When I start this project it has some template, but initialization of ASP.NET DI container was be full incorrect. I have extract interface from DAL and inject DAL to controllers. Add Swagger, correct authentication, CORS policy and SQL and EF connection. This is my solution for correct init DI container.