Entity Framework DB First

 

  • Create a Project of Type Class Library with the name EFDBFirst.Data
  • Add following Nuget Packages
  • Microsoft.EntityFrameworkCore (6.0.6 or latest stable package)
  • Microsoft.EntityFrameworkCore.SQLServer (6.0.6 or latest stable package)
  • Microsoft.EntityFrameworkCore.Tools (6.0.6 or latest stable package)
  • Microsoft.EntityFrameworkCore.Design(6.0.6 or latest stable package)
  • Create a New Database with the name DBFirst and Add 2 tables Employee and EmployeeEducation with 1 to many relationship
  • Run the following commands in package manager console
Scaffold-DbContext "Server=KELLGGNLPTP1078\SQLEXPRESS;Database=DBFirst;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

  • This command will generate the DB context class and model for all table. After this the process remains same as code First Approach
  • If we make any changes in DB tables and wanted to update our code then we need to run Scaffold-DbContext command with -force flag

Scaffold-DbContext "Server=KELLGGNLPTP1078\SQLEXPRESS;Database=DBFirst;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models  -force

Reference Link: https://www.entityframeworktutorial.net/efcore/create-model-for-existing-database-in-ef-core.aspx

Source Code Link: https://github.com/kumarabhimanyu/EFDBFirst

Comments

Post a Comment

Popular posts from this blog

Publish .Net Core Web API to Linux Host

Image
Publish .Net Core Web API to Linux Host In this post below, I am going to detail out the step of publishing a .NET Core Web API to Linux Host SSH the Linux host Open any SSH client like gitbash Go to the location where the .pem file exists ssh -i <pemfilename> -v <username>@<host_IP_Address> use sudo su for super admin access to run further command Create project folder Go to /var/www folder (cd /var/www) create a new folder for the project. For example SampleWebAPI (mkdir SampleWebAPI ) Publish project in release mode Open command prompt as administrator Go to Project folder - cd <foldername> dotnet publish  --configuration release Copy latest publish code to project folder Open file transfer tool like FileZilla Connect to linux host with right credentials Copy the file from local published folder to  /var/www/SampleWebAPI  Change the Nginx configuration file Go to cd /etc/nginx/sites-available/ Edit default config file: vim default...
Read more

Entity Relationship Using EF Core Code First Approach

 In this section, we are going to talk about the different kind of relationship between entities and how to establish that using C# code. Followings are the type of relationship One to Many An employee can have more than 1 education details. To Achieve this, we need to have a property in employee class like the below one. public ICollection<EmployeeEducation> EducationList { get; set; } Once we do this and add the migration, it will add a new column EmployeeID in EmployeeEducations table, but as a nullable attribute. In this case, if we try to add data in EmployeeEducations table, it will set EmployeeID as null To fix this, we need to add a cross reference in the EmployeeEducation Class, to denote that Every education record must have an employee ID. This will ensure that allow null attribute of EmployeeID column in EmployeeEducations  table is set to false. public Employee Employee { get; set; } If we try to insert values in EmployeeEducations table with below code...
Read more

Web API Using EF Core

Image
What is Web API  As the name suggests, is an API over the web which can be accessed using HTTP protocol. We can build Web API using different technologies such as Java, .NET etc.  Web API breaks the limitation of language. For example a web API written in .Net can be utilized by Java and vice verssa, because the request/response format of Web API is JSON which is understood by all language. For example, Twitter's  REST APIs  provide programmatic access to read and write data using which we can integrate twitter's capabilities into our own application. We can use tools like Fiddler, PostMan and Swagger for testing Web API .Net Core Web API -   Is an Ideal platform for building RESTful services. Is built on top of ASP.NET and supports ASP.NET request/response pipeline Maps HTTP verbs to method names. Supports different formats of response data. Built-in support for JSON, XML, BSON format. C...
Read more