KininTech.SqlMapping 3.0.0

Prefix Reserved

There is a newer version of this package available.
See the version list below for details.

dotnet add package KininTech.SqlMapping --version 3.0.0

NuGet\Install-Package KininTech.SqlMapping -Version 3.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="KininTech.SqlMapping" Version="3.0.0" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add KininTech.SqlMapping --version 3.0.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: KininTech.SqlMapping, 3.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 KininTech.SqlMapping as a Cake Addin
#addin nuget:?package=KininTech.SqlMapping&version=3.0.0

// Install KininTech.SqlMapping as a Cake Tool
#tool nuget:?package=KininTech.SqlMapping&version=3.0.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

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.

Product	Compatible and additional computed target framework versions.
.NET Framework	net461 is compatible. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

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	Downloads	Last updated
4.0.0	13,009	8/14/2020
3.0.0	2,464,694	7/31/2020
2.1.0	322,239	7/28/2020
2.0.0	357,172	7/27/2020
1.2.0	40,578	7/23/2020
1.1.0	23,931	7/21/2020
1.0.0	2,970	7/13/2020

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

v.3.0.0 changes:

Major Announcement from the Author: I would like to apologize for the package's inconvenient and ambiguous checkings that caused improbable exceptions during model validation. Especially, the nullable types between SQL Server and .NET Framework were not handled correctly. Moreover, the introduction of Key class has made the usage of the EntityTable class more complex. Having taken these factors into consideration, I decided to make the following changes:

- The Key class and the associated methods GetByKey(), Contains(), Delete() have been removed.
- The EntityTable class can now checks a nullable property correctly regardless of it being a generic, Nullable, type.
- The EntityTable class can now checks and retrieves the correct nullable value for the correct types in each Sql operation.
- Some unneccessary codes have been removed; some similar codes have been merged, so there is slight increase in the performance.

The next major release v.4.0.0 will be launched anytime between mid- and late- August, 2020. However, until then, the minor release of v3.0.0 will still be going on, so you will receieve one or two minor releases of v.2.0.0.