KininTech.SqlMapping 4.0.0

Provide an easy way of mapping objects to SQL Server database table by using Attributes. If you want to query a database table but do not want to write complex and complicated SQL query, you can use this package. By just specifying some metadata on class and its property using attributes, you can start querying the table in no time.

Sub-framework: KininTech.SqlMapping.ORM

Important Note: The main class for this package, EntityTable, implements IEnumerable interface, so you can easily use Linq to query the entities in the EntityTable as the entities are mapped to the records in the database table.

Install-Package KininTech.SqlMapping -Version 4.0.0
dotnet add package KininTech.SqlMapping --version 4.0.0
<PackageReference Include="KininTech.SqlMapping" Version="4.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add KininTech.SqlMapping --version 4.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: KininTech.SqlMapping, 4.0.0"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install KininTech.SqlMapping as a Cake Addin
#addin nuget:?package=KininTech.SqlMapping&version=4.0.0

// Install KininTech.SqlMapping as a Cake Tool
#tool nuget:?package=KininTech.SqlMapping&version=4.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

In this major release (v.4.0.0) of KininTech.SqlMapping, there are a lot of significant additions and changes made to the package.

v.4.0.0 changes:

This major release of KininTech.SqlMapping introduces a brand new sub-framework: KininTech.SqlMapping.ORM which consists of classes used to represent Microsoft SQL Server databases and their associated objects in the forms of object-oriented models.

The classes in the sub-framework KininTech.SqlMapping.ORM including DatabaseModel, DatabaseTable, DatabaseColumn, and EntityModel are coded to work cooperatively to provide an automatic and functional procedure of generating model classes from the database without having to write ones your own. With the help of this sub-framework, coding all the models that you need will be easily done beforehand.

Read how to use the sub-framework at: https://www.shorturl.at/jsQT0

The EntityTable now supports Model Object Validation: the validation of the length of the values of the properties that are mapped to string-typed and binary-typed columns to make sure that the values do not exceed the columns' maximum length.

The next major release v.5.0.0 will be launched anytime between mid- and late- September, 2020. However, until then, the minor release of v4.0.0 will still be going on, so you will receieve one or two minor releases of the current version.

Dependencies

This package has no dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
4.0.0 11,294 8/14/2020
3.0.0 2,463,697 7/31/2020
2.1.0 321,242 7/28/2020
2.0.0 356,118 7/27/2020
1.2.0 39,573 7/23/2020
1.1.0 22,923 7/21/2020
1.0.0 1,948 7/13/2020