Code Monkey home page Code Monkey logo

efcore2gettingstarted's Introduction

efcore2gettingstarted

EF Core 2.0 - Getting Started (Pluralsight)

Creating a Data Model and Database with EF Core

Note: Run powershell commands where DbContext lives (Samurai.Data)

Add Migration

Add-Migration initial

Script Migration - Used for Renee

script-migration

Add Relationship (add schema update migration)

add-migration relationships

Update-Database (update database w/any changes since last snapshot - creates db if not exists)

update-database

Database-first script (sreate entities from existing db)

scaffold-dbcontext -provider Microsoft.EntityFrameworkCore.SqlServer -connection "ConStr" `

Helpful Poweshell script EF commands

get-help entityframeworkcore

Interacting with your EF Core Data Model

Note: Run powershell commands where DbContext lives (Samurai.Data)

Add Logging to see the SQL EF is generating

Nugetget pkg: Microsoft.Extensions.Logging.Console

optionsBuilder
     .UseLoggerFactory(MyConsoleLoggerFactory) //set logging factory
     .EnableSensitiveDataLogging(true) //view parameter values in the console logs
Helpful: Known Nuget Package Installs
 - Microsoft.EntityFrameworkCore.SqlServer v2.0.1
 - Microsoft.EntityFrameworkCore.Tools v2.0.1 
 - Microsoft.EntityFrameworkCore.Design v2.0.1
 - Microsoft.Extensions.Logging.Console v2.0.0

efcore2gettingstarted's People

Contributors

recbrasil5 avatar

Watchers

James Cloos avatar avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.