Scribd
Upload
24 views1 page

DB First2

Uploaded by

rushikeshkalwane141
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
24 views1 page

DB First2

Uploaded by

rushikeshkalwane141
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Db first approach

1. Add Nuget Packages


[Link]
[Link]
[Link]

2. Package Manager Console


Scaffold-DbContext "Data Source=(localdb)\MSSQLLocalDB;Initial
Catalog=EmpDetailsDB;Integrated Security=True;Connect
Timeout=30;Encrypt=False;Trust Server Certificate=False;Application
Intent=ReadWrite;Multi Subnet Failover=False"
[Link] -OutputDir Models

Note : read more at


[Link]

3. Add EF service in [Link]

public static void Main(string[] args)


{
[Link]();
[Link]<BookAdminContext>(options =>

[Link]([Link]("BookAdminContext"))
);

4. Specify connection string in [Link]


"ConnectionStrings": {
"BookAdminContext": "Data Source=(localdb)\\MsSqlLocalDb;Initial
Catalog=BookAdmin;Integrated Security=true;MultipleActiveResultSets=true"
}

Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=BookSellersDb;Integrated


Security=True;Connect Timeout=30;Encrypt=False;Trust Server
Certificate=False;Application Intent=ReadWrite;Multi Subnet Failover=False

Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=EmpDetailsDB;Integrated


Security=True;Connect Timeout=30;Encrypt=False;Trust Server
Certificate=False;Application Intent=ReadWrite;Multi Subnet Failover=False

You might also like