Tosinso.STORM.SqlServer
1.1.6
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.1.6
NuGet\Install-Package Tosinso.STORM.SqlServer -Version 1.1.6
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.1.6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Tosinso.STORM.SqlServer --version 1.1.6
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Tosinso.STORM.SqlServer, 1.1.6"
#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.1.6
// Install Tosinso.STORM.SqlServer as a Cake Tool
#tool nuget:?package=Tosinso.STORM.SqlServer&version=1.1.6
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 |
|------------------------------- |-----------:|---------:|---------:|
| STORM_Insert | 828.1 ms | 21.33 ms | 61.89 ms |
| EFCore_Insert | 1,854.1 ms | 25.60 ms | 23.94 ms |
| STORM_Insert_WithNavigations | 1,622.1 ms | 32.02 ms | 34.26 ms |
| EFCore_Insert_WithNavigations | 2,998.5 ms | 57.34 ms | 97.37 ms |
| STORM_Update | 970.0 ms | 19.37 ms | 44.90 ms |
| EFCore_Update | 2,626.8 ms | 50.55 ms | 54.08 ms |
| STORM_Query | 597.4 ms | 11.51 ms | 12.31 ms |
| EFCore_Query | 1,437.0 ms | 26.18 ms | 23.21 ms |
| STORM_Query_NoTrack | 193.5 ms | 2.85 ms | 2.67 ms |
| EFCore_Query_NoTrack | 682.0 ms | 12.95 ms | 18.57 ms |
| STORM_Query_NoTrack_NoProxies | 184.5 ms | 2.56 ms | 2.27 ms |
| EFCore_Query_NoTrack_NoProxies | 236.3 ms | 4.70 ms | 7.85 ms |
| Dapper_Query | 212.9 ms | 2.65 ms | 2.48 ms |
| STORM_Delete | 119.8 ms | 5.62 ms | 16.49 ms |
| EFCore_Delete | 176.3 ms | 3.41 ms | 6.66 ms |
| 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.1 is compatible. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETCoreApp 3.1
- Microsoft.Data.SqlClient (>= 2.0.1)
- Tosinso.STORM (>= 1.1.6)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.