Author: ganesh

[quads id=RndAds] [quads id=RndAds] Entity Framework Core SaveChanges | Save DataIn this entity framework core tutorial will discuss to save data using entity framework core savechanges method and it will includes insert, update and delete operations.Entity Framework Core provides different ways to add, update, or delete data in the database for that we need to use entity framework core savechanges method. An entity contains data in its scalar property will be either inserted or updated or deleted based on its EntityState.Step 1: Create interface ‘IStudentContract.cs’.public interface IStudentContract { Student GetStudent(int id); List GetAllStudent(); List GetAllStudentByName(string name); void Add(Student student); void Update(Student student); void Delete(int studentID); }Step 2: Create service ‘StudentService.cs’ which impments the above contract.public class StudentService : IStudentContract { public List GetAllStudent() { var context = new SchoolContext(); List students =…

[quads id=RndAds] Entity Framework Core Query to Database.In this tutorial will discuss to write queries into entity framework core and below point and querying entity framework core.Entity Framework Core uses Language Integrated Query (LINQ) to query data from the database.LINQ allows you to use C# (or your .NET language of choice) to write strongly typed queries based on your derived context and entity classes.Querying in Entity Framework Core remains the same as in EF 6 to load entities from the database.It provides more optimized SQL queries and the ability to include C#/VB.NET functions into LINQ-to-Entities queries.Step 1: Create interface 'IStudentContract.cs'.public interface IStudentContract { Student GetStudent(int id); List GetAllStudent(); List GetAllStudentByName(string name); }Step 2: Create service 'StudentService.cs' which impments the above contract.public class StudentService : IStudentContract { public List GetAllStudent() { throw…

[quads id=RndAds] Database First Approach.In this tutorial will see how to create model from database in entity framework core and will see implementation database first approach in entity framework core.The Database First Approach creates the entity framework from an existing database. We use all other functionalities, such as the model/database sync and the code generation, in the same way we used them in the Model First approach.The Database First Approach provides an alternative to the Code First and Model First approaches to the Entity Data Model. It creates model codes (classes, properties, DbContext etc.) from the database in the project and those classes become the link between the database and controller.So lets create database and table require.We have a simple database created in the previous article, and it contains two…

[quads id=RndAds] Code First ApproachIn this tutorial we discuss what code first approach in entity framework core and generate database from out domain entity.Entity Framework introduced the Code-First approach with Entity Framework 4.1. Code-First is mainly useful in Domain Driven Design. In the Code-First approach, we will focus on the domain of your application and start creating classes for your domain entity rather than design your database first and then create the classes which match your database design.We will create Entities, which are regular C# classes with DB attributes. Entities are not “DTO” objects because it's designed for Database interactions. We will be using the code-first approach, so these Entity classes are inputs for DB creation.Step 1: Let create folder with name entity in our project into root directory and…