In this post we are going to Insert data using an UDF. We all know that User-defined functions (UDF) cannot be used to perform actions that modify the database state. Error Occur while Inserting using UDF: Invalid use of the side-affecting operator ‘INSERT’ within a function.
Category: MS SQL Server
Scaffolding ASP.Net Core MVC
In this post we are going to explore how to create model based on existing database (Db-First), with the help of Entityframework Core Command then learn how to generate Controller & Views using Scaffolding (Interface & Code-Generator Command) based on model.
.Net Core Code First Migration using Class Library
In this post we are going to elaborate how to work with EF code first migration using .Net core class library.
CRUD using .Net Core, Angular2, WebAPI
In Our previous article we have seen how to startup with .Net Core. In this article we will take a look on database operation according to previous sample application based previous concept. If you are new to .Net Core, Please read previous post about .Net Core Startup