LogicBuilder.EntityFrameworkCore.SqlServer 7.0.0

Prefix Reserved
dotnet add package LogicBuilder.EntityFrameworkCore.SqlServer --version 7.0.0                
NuGet\Install-Package LogicBuilder.EntityFrameworkCore.SqlServer -Version 7.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="LogicBuilder.EntityFrameworkCore.SqlServer" Version="7.0.0" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add LogicBuilder.EntityFrameworkCore.SqlServer --version 7.0.0                
#r "nuget: LogicBuilder.EntityFrameworkCore.SqlServer, 7.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.
// Install LogicBuilder.EntityFrameworkCore.SqlServer as a Cake Addin
#addin nuget:?package=LogicBuilder.EntityFrameworkCore.SqlServer&version=7.0.0

// Install LogicBuilder.EntityFrameworkCore.SqlServer as a Cake Tool
#tool nuget:?package=LogicBuilder.EntityFrameworkCore.SqlServer&version=7.0.0                

LogicBuilder.EntityFrameworkCore.SqlServer

  • Maps business model objects to and from data objects.
  • Maps query expressions from business model to data model.

To use:

    //Create a context
    public class SchoolContext : DbContext
    {
        public SchoolContext(DbContextOptions<SchoolContext> options) : base(options)
        {
        }
    }

    //Create Store
    public interface ISchoolStore : IStore
    {
    }
    public class SchoolStore : StoreBase, ISchoolStore
    {
        public SchoolStore(SchoolContext context)
            : base(context)
        {
        }
    }

    //Create Repository
    public interface ISchoolRepository : IContextRepository
    {
    }
    public class SchoolRepository : ContextRepositoryBase, ISchoolRepository
    {
        public SchoolRepository(ISchoolStore store, IMapper mapper) : base(store, mapper)
        {
        }
    }

    //Register Services including AutoMapper profiles.
    IServiceProvider serviceProvider = new ServiceCollection()
                .AddDbContext<SchoolContext>
                (
                    options =>
                    {
                        options.UseInMemoryDatabase("ContosoUniVersity");
                        options.UseInternalServiceProvider(new ServiceCollection().AddEntityFrameworkInMemoryDatabase().BuildServiceProvider());
                    }
                )
                .AddTransient<ISchoolStore, SchoolStore>()
                .AddTransient<ISchoolRepository, SchoolRepository>()
                .AddSingleton<AutoMapper.IConfigurationProvider>(new MapperConfiguration(cfg => cfg.AddProfiles(typeof(SchoolProfile).GetTypeInfo().Assembly)))
                .AddTransient<IMapper>(sp => new Mapper(sp.GetRequiredService<AutoMapper.IConfigurationProvider>(), sp.GetService))
                .BuildServiceProvider();

    //Call the repository
    ISchoolRepository repository = serviceProvider.GetRequiredService<ISchoolRepository>();
    ICollection<StudentModel> list = Task.Run(() => repository.GetItemsAsync<StudentModel, Student>()).Result;
Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 is compatible. 
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
7.0.0 97 11/25/2024
6.0.3 90 11/3/2024
6.0.2 143 8/11/2024
6.0.1 132 3/28/2024
6.0.0 280 12/27/2023
5.0.12 263 10/14/2023
5.0.11 104 10/14/2023
5.0.10 255 8/15/2023
5.0.9 235 7/16/2023
5.0.8 263 5/10/2023
5.0.7 678 10/1/2022
5.0.6 1,492 6/16/2022
5.0.4 642 4/15/2022
5.0.3 594 4/15/2022
5.0.2 363 12/24/2021
5.0.1 439 12/14/2021
5.0.0 344 12/14/2021
4.1.3 487 9/8/2021
4.1.3-preview.3 187 9/7/2021
4.1.3-preview.2 151 8/26/2021
4.1.3-preview.1 162 8/23/2021
4.1.3-preview.0 155 8/7/2021
4.1.2 396 5/11/2021
4.1.1 456 2/20/2021
4.1.1-preview.2 176 2/8/2021
4.1.1-preview.0 157 2/5/2021
4.1.0 448 1/13/2021
4.0.2 548 9/16/2020
4.0.1 261 9/8/2020
4.0.1-preview.1 253 9/4/2020
4.0.1-preview.0 244 8/26/2020
4.0.0 544 7/23/2020
4.0.0-preview02 337 7/20/2020
4.0.0-preview01 381 7/17/2020
3.0.0 603 1/3/2020
2.0.0 637 8/27/2019
1.0.0 847 12/30/2018
1.0.0-preview06 602 11/8/2018
1.0.0-preview05 678 9/18/2018
1.0.0-preview04 691 9/17/2018
1.0.0-preview03 714 9/17/2018

Supporting .NET 9.0.