AugusteVN.Modules.Commerce.Database.EfCore 1.0.0

.NET 10.0 This package targets .NET 10.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package AugusteVN.Modules.Commerce.Database.EfCore --version 1.0.0
                    


                    

                
NuGet\Install-Package AugusteVN.Modules.Commerce.Database.EfCore -Version 1.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="AugusteVN.Modules.Commerce.Database.EfCore" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="AugusteVN.Modules.Commerce.Database.EfCore" Version="1.0.0" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="AugusteVN.Modules.Commerce.Database.EfCore" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add AugusteVN.Modules.Commerce.Database.EfCore --version 1.0.0
                    


                    

                
#r "nuget: AugusteVN.Modules.Commerce.Database.EfCore, 1.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#:package AugusteVN.Modules.Commerce.Database.EfCore@1.0.0
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=AugusteVN.Modules.Commerce.Database.EfCore&version=1.0.0
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=AugusteVN.Modules.Commerce.Database.EfCore&version=1.0.0
                    


                            Install as a Cake Tool

AugusteVN.Modules.Commerce.Database

EF Core CommerceDbContext with entities for products, shop orders, and order line items.

Part of the AugusteVN Modules collection.

DbContext

ICommerceDbContext

Interface exposing DbSet properties for testability and loose coupling. Implements ISaveChangesAsync.

CommerceDbContext

Concrete EF Core DbContext targeting SQL Server with no-tracking query behavior.

DbSets:

DbSet Entity Description
Products Product Product catalog
ShopOrders ShopOrder Customer orders
ShopOrderProducts ShopOrderProduct Order line items (join entity)
ProductAttachments AttachmentEntity File attachments for digital products

Configuration:

  • Connection string: DefaultConnection
  • Migrations assembly: Commerce.Database project
  • Migration history table: Commerce_EFMigrationHistory
  • Default query tracking: NoTracking
  • Auto-auditing: CreatedBy, CreatedAt, LastModifiedBy, LastModifiedAt via AuditableEntity base

Entities

Product (extends AuditableEntity)

Property Type Description
Id Guid Primary key (from Entity)
Title string Display title
CoverPhotoUrl string Cover image URL
BodyAsMarkdown string Description in Markdown
BodyAsHtml string Description in HTML
Slug string URL-friendly slug
IsAvailable bool Available for purchase
IsPinned bool Pinned to top of listings
AmountInStock int Stock quantity
Price double Regular price
Discounted Discounted Owned type: discounted price and expiration
IsDigital bool Digital product flag
IsLeadMagnet bool Free lead magnet flag
Downloadable DownloadableEntity? Owned type: file attachment info

ShopOrder (extends TrackingBaseEntity)

Property Type Default Description
Id Guid — Primary key
Email string — Customer email
Address string? — Shipping address
Products List<ShopOrderProduct> — Navigation: line items
PaymentRefId Guid? — Payment reference
Status string ShopOrderStatuses.Pending Order lifecycle status
TotalPrice double? — Calculated total

ShopOrderProduct (extends AuditableEntity)

Property Type Description
Id Guid Primary key
Quantity int Ordered quantity
ProductId Guid Foreign key to Product
Product Product Navigation: product
Title string Product title snapshot
ShopOrderId Guid Foreign key to ShopOrder
ShopOrder ShopOrder Navigation: parent order

Owned Types

Type Parent Entity Properties
Discounted Product Price (double), ExpiresAt (DateTime?)
DownloadableEntity Product (from AugusteVN._Shared.Contracts.Downloadable)

Extension Method

AddCommerceDbContext

public static void AddCommerceDbContext(this IServiceCollection services, IConfiguration configuration)

Registers ICommerceDbContext / CommerceDbContext with SQL Server, no-tracking queries, and a dedicated migration history table.

Registration

// Program.cs
builder.Services.AddCommerceDbContext(builder.Configuration);

Migrations

# Create migration
dotnet ef migrations add <MigrationName> `
  --project ./_Modules/Commerce/Commerce.Database `
  --startup-project <YourStartupProject> `
  --context CommerceDbContext

# Apply migrations
dotnet ef database update `
  --project ./_Modules/Commerce/Commerce.Database `
  --startup-project <YourStartupProject> `
  --context CommerceDbContext

Installation

dotnet add package AugusteVN.Modules.Commerce.Database

Dependencies

  • AugusteVN.Database.EFCore
  • AugusteVN.Database.Entities
  • AugusteVN.Modules.Commerce._Shared
  • Commerce module overview
  • Commerce._Shared
  • Commerce.Api
  • Commerce.Features
  • Commerce.Templates
  • Commerce._Shared.Spa
Product Compatible and additional computed target framework versions.
.NET net10.0 is compatible.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.0.8 80 8/9/2026
1.0.7 79 8/9/2026
1.0.6 81 8/9/2026
1.0.2 90 8/8/2026
1.0.1 80 8/8/2026
1.0.0 83 8/8/2026