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.
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" />
paket add KininTech.SqlMapping --version 4.0.0
#r "nuget: KininTech.SqlMapping, 4.0.0"
// 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
In this major release (v.4.0.0) of KininTech.SqlMapping, there are a lot of significant additions and changes made to the package.
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.
This package has no dependencies.
This package is not used by any NuGet packages.
This package is not used by any popular GitHub repositories.