Wissance.nOrm.MySql
2.0.0
dotnet add package Wissance.nOrm.MySql --version 2.0.0
NuGet\Install-Package Wissance.nOrm.MySql -Version 2.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="Wissance.nOrm.MySql" Version="2.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Wissance.nOrm.MySql" Version="2.0.0" />
<PackageReference Include="Wissance.nOrm.MySql" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Wissance.nOrm.MySql --version 2.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Wissance.nOrm.MySql, 2.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.
#addin nuget:?package=Wissance.nOrm.MySql&version=2.0.0
#tool nuget:?package=Wissance.nOrm.MySql&version=2.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Norm
Ultra fast multi threads/tasks .Net Database framework.
Features
Norm
is stands for Not an ORM is a C#
lib for very HIGH Speed DB
data processing in async
way with immediately operations and at background with Processing data with Batches. It at least 10 times faster then EF/EF.Core
. In Comparison to ORMs Norm has following disadvantages:
- No object tracking
- No Lazy loading properties
But it gives us the following:
- Read spead is fast (10000 rows select from 100000 rows Mysql database ~100-200 ms)
Table size (rows) | Rows to select | Time, ms |
---|---|---|
100k | 10k | 154 |
100k | 10k in a middle | 190 |
100k | 100k | 1114 |
1M | 100k | 1135 |
1M | 500k | 5624 |
- Insert speed is fast (10000 rows ~ 600 ms, 100000 rows ~ 3000-5000 ms on
i5
CPU forMySql 8.0.23
with default settings)
Rows to insert | Time, ms |
---|---|
100 | 13 |
1000 | 62 |
10000 | 549 |
100000 | 5111 |
- Can work with DB in multiple threads unlike do all
ORMs
- Can synchronize data in background (for quite big operations, truly
async
behavior) - Can be used in
CQRS
approach because works in own thread and uses multiple tasks.
Nuget
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. 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 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 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net6.0
- MySql.Data (>= 9.3.0)
-
net8.0
- MySql.Data (>= 9.3.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Implemented general operations with bulk operations support