NICL UrbanMobility – Data

The Data layer provides persistence for the NICL UrbanMobility project.

Contents

• Entities: Poi, Price, UrbanMobilityState, TransportPoint
• DbContext: GlobalDbContext
• Repository implementations for the interfaces defined in TD.UrbanMobility.Application package

Dependencies

• References Application for interfaces and DTOs
• DbContext and entities are fully contained within this layer

Usage

• The API project registers the DbContext(using AddDbContext()) and repository implementations
• Application uses only the interfaces and DTOs from this layer
• To scaffold the DbContext and entities from the existing database, use the following command in the Package Manager Console: dotnet ef dbcontext scaffold "Server=xx;Database=Global_Test;Persist Security Info=True;Encrypt=true;TrustServerCertificate=true;User Id=xx;Password=xx;" Microsoft.EntityFrameworkCore.SqlServer --output-dir Persistence/Entities --context-dir Persistence --context GlobalDbContext --use-database-names --no-pluralize --force --no-onconfiguring --table Poi --table PoiPrice --table PoiType --table UrbanMobilityState --table TransportPoint --table Municipality --table Agency