ZayniFramework.DataAccess.LightORM 2.2.1

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

dotnet add package ZayniFramework.DataAccess.LightORM --version 2.2.1

NuGet\Install-Package ZayniFramework.DataAccess.LightORM -Version 2.2.1

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="ZayniFramework.DataAccess.LightORM" Version="2.2.1" />

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

paket add ZayniFramework.DataAccess.LightORM --version 2.2.1

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

#r "nuget: ZayniFramework.DataAccess.LightORM, 2.2.1"

#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 ZayniFramework.DataAccess.LightORM as a Cake Addin
#addin nuget:?package=ZayniFramework.DataAccess.LightORM&version=2.2.1

// Install ZayniFramework.DataAccess.LightORM as a Cake Tool
#tool nuget:?package=ZayniFramework.DataAccess.LightORM&version=2.2.1

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

Using DataContext template to execute CRUD methods.

Add using.

using ZayniFramework.Common;
using ZayniFramework.DataAccess.Lightweight;

Write your own DataContext class and extends the DataContext class.

/// <summary>Your DataContext class.
/// </summary>
internal class UserDataContext : DataContext<UserReqArgs, UserModel>

Then you can do some CRUD action like...

DataContext.Insert(); DataContext.Update(); DataContext.Delete(); DataContext.Select();

var model = new UserModel()
{
    Account = "Amber",
    Name    = "Amber Jane",
    Age     = 22,
    DOB     = new DateTime( 1993, 2, 17 ),
    Sex     = 0,
    IsVip   = true
};

var reqArgs = new UserReqArgs()
{
    Account = "Amber"
};

var wheres = new SqlParameter[] 
{ 
    new SqlParameter() { ColumnName = "AccountId", Name = "Account",  DbType = DbTypeCode.String, Value = "Amber001" },
    new SqlParameter() { ColumnName = "Name",      Name = "UserName", DbType = DbTypeCode.String, Value = "Amber" }
};

var r = dataContext.Select( new SelectInfo<UserReqArgs>() { DataContent = reqArgs } );
var c = dataContext.Insert( model );
var u = dataContext.Update( model, wheres: wheres, ignoreColumns: new string[] { "Birthday", "IsVIP" } );
var d = dataContext.Delete( model );

More DataContext examples. You can go to here and here.

Product	Compatible and additional computed target framework versions.
.NET	net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. 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.
.NET Core	netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed.
.NET Standard	netstandard2.0 is compatible. netstandard2.1 was computed.
.NET Framework	net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed.
MonoAndroid	monoandroid was computed.
MonoMac	monomac was computed.
MonoTouch	monotouch was computed.
Tizen	tizen40 was computed. tizen60 was computed.
Xamarin.iOS	xamarinios was computed.
Xamarin.Mac	xamarinmac was computed.
Xamarin.TVOS	xamarintvos was computed.
Xamarin.WatchOS	xamarinwatchos was computed.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

.NETStandard 2.0
- MySql.Data (>= 8.0.12)
- System.Data.SqlClient (>= 4.5.1)
- ZayniFramework.Caching (>= 2.2.1)
- ZayniFramework.Common (>= 2.2.1)
- ZayniFramework.DataAccess (>= 2.2.1)
- ZayniFramework.Logging (>= 2.2.1)

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
8.0.142	210	3/19/2024
8.0.141	1,887	1/4/2024
8.0.140	538	12/17/2023
6.0.138	106	3/19/2024
6.0.137	173	9/20/2023
6.0.136	141	9/14/2023
6.0.135	167	9/10/2023
6.0.134	175	7/12/2023
6.0.133	182	7/10/2023
6.0.132	170	7/7/2023
6.0.131	182	6/19/2023
6.0.130	172	6/19/2023
6.0.129	8,446	7/2/2022
6.0.128	357	1/16/2022
6.0.127	504	1/15/2022
6.0.126	479	1/15/2022
6.0.125	321	1/8/2022
6.0.125-hotfix1	225	1/8/2022
6.0.124	356	1/7/2022
6.0.123	433	11/14/2021
5.0.129	497	7/2/2022
5.0.128	519	1/16/2022
5.0.125	312	1/8/2022
5.0.124	334	1/7/2022
5.0.123	463	11/14/2021
5.0.122	505	10/11/2021
5.0.121	2,326	5/1/2021
3.1.137	206	9/20/2023
3.1.136	149	9/14/2023
3.1.135	156	9/10/2023
3.1.134	178	7/12/2023
3.1.133	173	7/11/2023
3.1.132	175	7/8/2023
3.1.131	148	6/19/2023
3.1.130	296	2/1/2023
3.1.129	503	7/2/2022
3.1.128	574	1/16/2022
3.1.125	318	1/8/2022
3.1.124	332	1/7/2022
3.1.123	501	11/14/2021
3.1.122	397	10/11/2021
3.1.121	527	5/1/2021
2.31.120	502	3/14/2021
2.30.115	1,948	3/6/2021
2.30.114	413	3/6/2021
2.20.101	470	3/1/2021
2.19.3	451	2/11/2021
2.19.2	10,023	2/6/2021
2.19.1	501	1/6/2021
2.19.0	575	1/1/2021
2.18.3	584	12/27/2020
2.18.2	791	8/29/2020
2.18.1	563	8/26/2020
2.18.0	4,771	8/20/2020
2.17.135	645	8/19/2020
2.17.134	663	7/28/2020
2.17.133	647	7/27/2020
2.17.132	655	7/18/2020
2.17.131	708	7/11/2020
2.16.130	692	6/13/2020
2.15.128	680	6/3/2020
2.15.127	729	5/31/2020
2.15.126	1,164	4/30/2020
2.14.122	597	4/13/2020
2.13.100	637	3/12/2020
2.12.51	718	2/18/2020
2.11.50	1,301	2/10/2020
2.10.44	1,340	1/30/2020
2.9.43	1,512	1/11/2020
2.8.42	1,309	1/10/2020
2.8.41	1,325	1/5/2020
2.7.40	1,332	1/2/2020
2.7.39	1,304	1/2/2020
2.7.38	1,443	1/1/2020
2.6.37	1,327	12/23/2019
2.6.35	1,514	12/4/2019
2.6.1	1,218	12/2/2019
2.6.0	1,256	11/28/2019
2.5.2	1,479	11/26/2019
2.5.1	1,398	11/12/2019
2.5.0	1,248	11/9/2019
2.4.3	1,471	10/16/2019
2.4.2	1,364	10/16/2019
2.4.1	1,444	9/20/2019
2.3.113	440	3/6/2021
2.3.112	440	3/6/2021
2.3.28	1,384	9/19/2019
2.3.27	1,438	8/30/2019
2.3.26	1,380	8/20/2019
2.3.25	1,332	8/12/2019
2.3.22	1,310	7/31/2019
2.3.21	1,495	7/20/2019
2.3.20	1,428	6/22/2019
2.3.19	1,321	6/14/2019
2.3.18	1,358	6/13/2019
2.3.17	1,347	6/13/2019
2.3.15	1,411	6/8/2019
2.3.14	1,352	6/8/2019
2.3.13	1,379	5/30/2019
2.3.12	740	5/24/2019
2.3.11	724	5/24/2019
2.3.10	695	5/21/2019
2.3.9	695	5/9/2019
2.3.8	725	5/8/2019
2.3.7	776	4/30/2019
2.3.6	864	4/23/2019
2.3.5	775	4/19/2019
2.3.4	726	4/18/2019
2.3.3	736	4/17/2019
2.3.2	741	4/6/2019
2.3.1	937	12/15/2018
2.3.0	772	12/7/2018
2.2.6	858	11/25/2018
2.2.1	863	11/17/2018
2.2.0	858	11/16/2018
2.1.0	855	11/15/2018
2.0.1	846	11/6/2018
2.0.0	882	11/4/2018

ZayniFramework.DataAccess.LightORM 2.2.1

Using DataContext template to execute CRUD methods.

.NETStandard 2.0

NuGet packages

GitHub repositories