Skip to content

cornshakes/LocalNorthwindEF

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Entity Framework Practice Kit With Northwind Sample DB

LocalNorthwindEF is a self contained Northwind db to practice Entity Framework skills. You don't have to connect it to a database first, instead you can just start.

It uses a pre-generated northwind.db sqlite file from northwind-SQLite3 by @jpwhite3.

It creates a new northwind.db file in the build folder if there isn't one. Cleaning or rebuilding the project will reset your database! Copy it out of the build folder first if you want to keep it.

EF Core Power Tools were used to generate all the model & context classes.

Usage

Install the nuget package LocalNorthwindEF.

There is the simple context which contains all the tables:

using var context = new SimpleNorthwindContext();
var customers = context.Customers.ToList();
...

If you want to use the views too, use the extended context:

using var context = new NorthwindContextWithViews();
var products = context.AlphabeticalListOfProducts.ToList();
...

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages