yemrekeskin / datacube

🔠🔢 Data access layer solution that is fast, featured and reliable for the .NET platform

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 💥

• https://docs.microsoft.com/en-us/ef/core
• https://www.learnentityframeworkcore.com
• https://entityframeworkcore.com
• https://www.entityframeworktutorial.net
• https://entityframework-plus.net/

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.