Select Insert Update Delete (CRUD) in ASP.Net Core 2.0 MVC

Question

how to do insert Updateselect search in aspnet core20

dharmendr · Accepted Answer

Hi pratikshirRefer below exampleFor reading connection string refer below article Net Core Read Connection String inside Startupcs from AppSettingsjson fileDatabaseI have made use of table Customers with the schema as follows CustomerId is an AutoIncrement Identity columnI have already inserted few records in the tableYou can download the database table SQL by clicking the download link below         Download SQL fileNamespacesusing SystemDatausing SystemDataSqlClientusing MicrosoftAspNetCoreMvcusing MicrosoftExtensionsConfigurationModelpublic class Customer    public int Id  set get     public string Name  set get     public string Country  set get     public IEnumerableltCustomergt Customers  get set Controllerpublic class HomeController  Controller    private IConfiguration Configuration    public HomeControllerIConfiguration configuration            Configuration  configuration        private string GetConnectionString

dharmendr · Answer

Referhttpswwwgooglecoinsearchqaspnetcore20mvctutorialampsourcelnmsamptbmvidampsaXampved0ahUKEwis3ajSyo3XAhWIKY8KHTWCOYQAUICigBampbiw1440ampbih795

Select Insert Update Delete (CRUD) in ASP.Net Core 2.0 MVC

Company

Explore

Follow us

Contact Us