Skip to content

Latest commit

 

History

History
89 lines (76 loc) · 2.71 KB

README.md

File metadata and controls

89 lines (76 loc) · 2.71 KB
Raw

DataCube ==^^==

This project contains use-cases exercises and concepts about EntityFrameworkCore. DataCube is data access layer solution that is fast and reliable for the .NET platform.

EF Core Concepts

  • Approaches
    • DatabaseFirst
    • CodeFirst
  • Relationships
    • One-To-Many
    • One-To-One
    • Many-To-Many
  • Conventions
    • Data Annotation
    • Fluent API
  • Scenarios
    • Connected Scenario
    • Disconnected Scenario

Installation from nuget

  • Install-Package Microsoft.EntityFrameworkCore.SqlServer
  • Install-Package Microsoft.EntityFrameworkCore.Design
  • Install-Package Microsoft.EntityFrameworkCore.Tools

EF Core Subjects

  • Modeling
    • Including-Excluding Types
      • [NotMapped] or Ignore
    • Including-Excluding Properties
      • [NotMapped] or Ignore
    • Keys
      • By default Id or (typename)Id
      • [Key] .HasKey
    • Generated Value
      • Data Annotation
        • [DatabaseGenerated(DatabaseGeneratedOption.None)]
        • [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        • [DatabaseGenerated(DatabaseGeneratedOption.Computed)]
      • Fluent API
        • .ValueGeneratedNever();
        • .ValueGeneratedOnAdd();
        • .ValueGeneratedOnAddOrUpdate();
    • Required and Optional Properties
      • [Required] , .IsRequired()
    • Shadow Properties
    • Index
      • .HasIndex(b => b.x) - .IsUnique();
    • Inheritance
    • Backing Fields
    • Keyless Entity Type
    • Value Conversions
      • Enums
      • Microsoft.EntityFrameworkCore.Storage.ValueConversion
      • .HasConversion(converter);
      • [Column(TypeName = "nvarchar(24)")]
  • Data Seeding
  • Manage Database
    • Migration
      • Seperate Project
    • Migration Commands - PMC
      • get-help entityframework
      • Add-Migration [MigrationName]
      • Remove-Migration
      • Update-Database
      • Drop-Database
      • Scaffold-DbContext
      • Script-Migration
    • Scaffolding
      • Generate entities from existing database

Useful Links 💥

Contribution 💪

Pull requests are welcome, but make sure you sign the Contributor License Agreement.

License

DataCube is licensed under the MIT license. Check the LICENSE file for details.