Skip to content

Instantly share code, notes, and snippets.

@f7q

f7q/EFCoreLearn.md

Last active July 2, 2017 00:57
Show Gist options
  • Save f7q/b2b9eec16147abecc36d4615cfbf3363 to your computer and use it in GitHub Desktop.
Save f7q/b2b9eec16147abecc36d4615cfbf3363 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
EFCoreLearn.md
  • Migration
  • Scaffolding
  • Transaction
  • SQL Logging

操作情報dotnet ef migrations add sampleMigration

  • O/RM <=> Model <=> Database
  • Database <=> Model <=> O/RM

手動によるSQL管理しない開発方法の習得

接続情報

  • SQLite
    • Data Source=..\..\..\db.sqlite
  • SQL Server
    • Data Source=COMPUTERNAME;Initial Catalog=test;Integrated Security=True;Connect Timeout=15;Encrypt=False; TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False
    • Server=(COMPUTERNAME\username);Database=test;Trusted_Connection=True;MultipleActiveResultSets=true
  • SQL Server Local
    • Server=(localdb)\mssqllocaldb;Database=aspnetcore;Trusted_Connection=True;MultipleActiveResultSets=true
  • PostgreSQL
    • User Id=postgres;Password=postgresql;Host=localhost;Port=5432;Database=mydb; aspnet/Tooling#797

トランザクション

  • 1.0だとUnitOfWorkによる実装
  • 2.0からTransactionScopeクラス追加
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment