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 72 11/25/2024
6.0.3 78 11/3/2024
6.0.2 132 8/11/2024
6.0.1 128 3/28/2024
6.0.0 276 12/27/2023
5.0.12 259 10/14/2023
5.0.11 100 10/14/2023
5.0.10 251 8/15/2023
5.0.9 231 7/16/2023
5.0.8 259 5/10/2023
5.0.7 674 10/1/2022
5.0.6 1,486 6/16/2022
5.0.4 636 4/15/2022
5.0.3 588 4/15/2022
5.0.2 357 12/24/2021
5.0.1 433 12/14/2021
5.0.0 338 12/14/2021
4.1.3 481 9/8/2021
4.1.3-preview.3 185 9/7/2021
4.1.3-preview.2 149 8/26/2021
4.1.3-preview.1 160 8/23/2021
4.1.3-preview.0 153 8/7/2021
4.1.2 390 5/11/2021
4.1.1 450 2/20/2021
4.1.1-preview.2 174 2/8/2021
4.1.1-preview.0 155 2/5/2021
4.1.0 442 1/13/2021
4.0.2 540 9/16/2020
4.0.1 255 9/8/2020
4.0.1-preview.1 251 9/4/2020
4.0.1-preview.0 242 8/26/2020
4.0.0 538 7/23/2020
4.0.0-preview02 335 7/20/2020
4.0.0-preview01 379 7/17/2020
3.0.0 597 1/3/2020
2.0.0 631 8/27/2019
1.0.0 839 12/30/2018
1.0.0-preview06 595 11/8/2018
1.0.0-preview05 671 9/18/2018
1.0.0-preview04 684 9/17/2018
1.0.0-preview03 707 9/17/2018

Supporting .NET 9.0.