Skip to main content

Code First Approach in ASP.NET CORE MVC

 How to implement Code First Approach in ASP.NET CORE MVC:-


Code First Approach is best for light-weight and smaller project in ASP.NET MVC Core, it is basically created to those developer who is not know about SQL. without SQL Server or any database package developer can create complete project.



Step 1 New Project

Once you have installed the Visual Studio 2019 and .Net Core 3.1 SDK, you can start building a new ASP.NET Core Application.


Step 2nd:-

Create a web app and From the Visual Studio select Create a new project. Select ASP.NET Core Web Application > Next.


Step 3rd:-

Give your project a name i.e. SampleCodeFirstExample and give your project a location where it’ll be saved and click Create.


Step4th:-

 Install the NuGet Packages

From the Solution right click on dependency, select Manage NuGet Packages and Select the Browse tab, and then enter Microsoft.EntityFrameworkCore.SqlServer in the search box, select Latest Stable Version and Install.


Step5h:-


Now, install Microsoft.EntityFrameworkCore.Tools as same as above steps.


Step6th:-


Create Model and Context Classes:

Now, Add new class with name “Emp”, using Right-click the Models folder and select Add Class.


public class Emp

    {

        public long empid { get; set; }

        public string empname { get; set; }

        public int salary { get; set; }


        public string designation { get; set; }


    }



Step7th:-


Right-click the Models folder and select Add > Class. Name the class MyDbContext and click Add and change code in MyDbContext.cs as following:


  public class MyDbContext:DbContext

    {

        public MyDbContext(DbContextOptions<MyDbContext> options):base(options)

        {


        }

        public DbSet<Emp> emps { get; set; }

    }



Step8th:-


Connection string you need to write inside the appsetting.json file as follows:


 "ConnectionStrings": {

    "Conn": "Data Source=SHIVA-PC\\SQLEXPRESS;Initial Catalog=collegeerp;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;"

  },


Step9th:-


Register Connection String under Program.cs file



Step10th:-


builder.Services.AddDbContext<MyDbContext>(options => options.UseSqlServer(builder.Configuration.GetConnectionString("Conn")));



Step11th:-


Create Database using Migration Commmand


add-migration initialmigration



Step12th:-


Write update database command


update-database



Step13


We can check MS-SQL Server and Check Database 


Step14th:-


Add new column in table then add new property in model class


public int age{get;set;}


Step15:-

write followings commands for migration

add-migration addedColumnname

update-database assedColumnname




Comments

Popular posts from this blog

Uncontrolled form input in React-JS

  Uncontrolled form input in React-JS? If we want to take input from users without any separate event handling then we can uncontrolled the data binding technique. The uncontrolled input is similar to the traditional HTML form inputs. The DOM itself handles the form data. Here, the HTML elements maintain their own state that will be updated when the input value changes. To write an uncontrolled component, you need to use a ref to get form values from the DOM. In other words, there is no need to write an event handler for every state update. You can use a ref to access the input field value of the form from the DOM. Example of Uncontrolled Form Input:- import React from "react" ; export class Info extends React . Component {     constructor ( props )     {         super ( props );         this . fun = this . fun . bind ( this ); //event method binding         this . input = React . createRef ();...

JSP Page design using Internal CSS

  JSP is used to design the user interface of an application, CSS is used to provide set of properties. Jsp provide proper page template to create user interface of dynamic web application. We can write CSS using three different ways 1)  inline CSS:-   we will write CSS tag under HTML elements <div style="width:200px; height:100px; background-color:green;"></div> 2)  Internal CSS:-  we will write CSS under <style> block. <style type="text/css"> #abc { width:200px;  height:100px;  background-color:green; } </style> <div id="abc"></div> 3) External CSS:-  we will write CSS to create a separate file and link it into HTML Web pages. create a separate file and named it style.css #abc { width:200px;  height:100px;  background-color:green; } go into Jsp page and link style.css <link href="style.css"  type="text/css" rel="stylesheet"   /> <div id="abc"> </div> Exam...

JDBC using JSP and Servlet

JDBC means Java Database Connectivity ,It is intermediates from Application to database. JDBC has different type of divers and provides to communicate from database server. JDBC contain four different type of approach to communicate with Database Type 1:- JDBC-ODBC Driver Type2:- JDBC Vendor specific Type3 :- JDBC Network Specific Type4:- JDBC Client-Server based Driver  or JAVA thin driver:- Mostly we prefer Type 4 type of Driver to communicate with database server. Step for JDBC:- 1  Create Database using MYSQL ,ORACLE ,MS-SQL or any other database 2   Create Table using database server 3   Create Form according to database table 4  Submit Form and get form data into servlet 5  write JDBC Code:-     5.1)   import package    import java.sql.*     5.2)  Add JDBC Driver according to database ide tools     5.3)  call driver in program         ...