SQL database

Question

Hi anyone can help me to add the existing database to c#.NET and insert values from the interface

Answer 1

▪You can use Entity Framework to work with databases. Firstly, you need to define models (classes with properties) that you need to store in a database. Later you will work with them as a result of db queries. Secondly, you need to setup the db context class. That includes defining a connection string, initialize strategy optionally. It's the main object you will be working with. Adding / inserting data is performed by LINQ methods.
▪If you need a local db you may create .mdf file anywhere in your project.
▪https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-application