Tosinso.STORM.SqlServer
1.2.0
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package Tosinso.STORM.SqlServer --version 1.2.0
NuGet\Install-Package Tosinso.STORM.SqlServer -Version 1.2.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="Tosinso.STORM.SqlServer" Version="1.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Tosinso.STORM.SqlServer --version 1.2.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Tosinso.STORM.SqlServer, 1.2.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 Tosinso.STORM.SqlServer as a Cake Addin
#addin nuget:?package=Tosinso.STORM.SqlServer&version=1.2.0
// Install Tosinso.STORM.SqlServer as a Cake Tool
#tool nuget:?package=Tosinso.STORM.SqlServer&version=1.2.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Microsoft SQL Server provider for Tosinso.STORM.
STORM is an ORM for .NET Core. It's fast, full-featured and easy to use object database mapper. To know more about STORM, read our documentation:
- Getting Started
- Benchmarks
- DbSession, DbTable and Entities
- Microsoft ASP.NET Core integration
- Navigations
- Using enum
- Map with attributes
- Map with fluent api
- Create database from model
- Add entities
- Update entities
- Delete entities
- Introuction to query data
- Output projection
- Joins
- Advance query features
- Performance tips
- Optimistic concurrency
- JSON Columns
- Indexes
- Squences, Defaults and Check Constraints
- Shadow properties
- Entity validators
- Session configuration
This package is Core for STORM Database Providers. STORM currently support Microsoft SQL Server provider. To use SQL Server provider install following package:
Install-Package Tosinso.STORM.SqlServer
Following providers is under development:
1. Oracle
2. MySQL
3. SQLite
Benchmarks
STORM is fast in all CRUD operations. The following benchmark compared STORM with EF Core and Dapper. Benchmark is based on:
- Inserting 5000 records
- Inserting 25000 records (1000 users, 5 blog post for each user)
- Updating 10000 records
- Deleting 1500 records
- Query 100000 records
| Method | Mean | Error | StdDev | Allocated |
|------------------------------- |------------:|----------:|----------:|----------:|
| STORM_Insert | 754.82 ms | 17.510 ms | 49.958 ms | 29.27 MB |
| EFCore_Insert | 1,787.91 ms | 35.452 ms | 39.404 ms | 78.57 MB |
| STORM_Insert_WithNavigations | 1,599.69 ms | 31.776 ms | 77.947 ms | 181.99 MB |
| EFCore_Insert_WithNavigations | 2,721.27 ms | 17.618 ms | 14.712 ms | 127.34 MB |
| STORM_Update | 929.25 ms | 19.046 ms | 55.257 ms | 64.87 MB |
| EFCore_Update | 2,494.05 ms | 22.519 ms | 17.582 ms | 152.97 MB |
| STORM_Query | 552.79 ms | 10.589 ms | 12.195 ms | 154.94 MB |
| EFCore_Query | 1,456.24 ms | 26.596 ms | 24.878 ms | 273.65 MB |
| STORM_Query_NoTrack | 183.06 ms | 3.618 ms | 6.524 ms | 38.88 MB |
| EFCore_Query_NoTrack | 693.58 ms | 13.681 ms | 15.207 ms | 188.08 MB |
| STORM_Query_NoTrack_NoProxies | 181.34 ms | 1.858 ms | 1.551 ms | 38.88 MB |
| EFCore_Query_NoTrack_NoProxies | 224.82 ms | 4.347 ms | 5.498 ms | 60.17 MB |
| Dapper_Query | 204.98 ms | 3.520 ms | 3.293 ms | 44.12 MB |
| STORM_Delete | 99.01 ms | 3.852 ms | 10.990 ms | 5.05 MB |
| EFCore_Delete | 160.41 ms | 2.661 ms | 2.489 ms | 19.99 MB |
| Product | Versions 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 | netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.1 is compatible. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | 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.1
- Microsoft.Data.SqlClient (>= 2.0.1)
- Tosinso.STORM (>= 1.2.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.