How to Create a SQLite Database with Entity Framework Core in an ASP.NET Core MVC WebApp! #1

[kevvaull]

This was amazing! I have looked everywhere for a article or video like this. You made me finaly understand how the connection between db and views work. Big thanks!

[legionsman]

not sure if i'll get a response, but when i go to add migration and then update database, i get the following:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SNI_PN11, error: 26 - Error Locating Server/Instance Specified)

any help is appreciated.

[leonidascarranza]

nice video but have a question, this only work for create DB on Sqlite?, dont work if I tray to conect with a existing DB?

[JJ-cwku]

Sir, Thank you for your video. But in my visual studio, when I typed add -migration, it says "The term 'add' is not recognized as the naem of a cmdlet, function, script file, or operable problem.

Do you know how to fix this?

[waliqadri]

Why the migration has some sql lite specific code, i thought the migrations were cross platform. I was thinking all you have to do is to change your DB context do a different database technology and run the migration 😅

[pietrononame]

BTW. Arrow operators make it unreadable. Hardcoded databasename and path. Please, do not USE it. BTW, how to create database automatically, in code, to be checking and creating nonexistent DB FILE on runtime.