TWCore.Data.SqlServer 3.1.0

dotnet add package TWCore.Data.SqlServer --version 3.1.0
                    
NuGet\Install-Package TWCore.Data.SqlServer -Version 3.1.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="TWCore.Data.SqlServer" Version="3.1.0" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="TWCore.Data.SqlServer" Version="3.1.0" />
                    
Directory.Packages.props
<PackageReference Include="TWCore.Data.SqlServer" />
                    
Project file
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 TWCore.Data.SqlServer --version 3.1.0
                    
#r "nuget: TWCore.Data.SqlServer, 3.1.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=TWCore.Data.SqlServer&version=3.1.0
                    
Install TWCore.Data.SqlServer as a Cake Addin
#tool nuget:?package=TWCore.Data.SqlServer&version=3.1.0
                    
Install TWCore.Data.SqlServer as a Cake Tool

TWCore 3.1

Build status Nuget

A multipurpose framework library used to create microservices solutions on multiple platforms (runs on windows, linux, linux-arm [raspberry pi], and osx).

Compatible with

  • .NET Framework 4.7.2
  • netstandard2.0
  • netcoreapp2.1
  • netcoreapp2.2
  • netcoreapp3.1
  • net5.0
  • net6.0
  • net7.0
  • net8.0

Advantages

  • Easy development of microservices: With fewer code you can subscribe to a message broker and start to process messages as pub/sub or RPC architecture.
  • Completely agnostic and loosely coupled: All subsystems of the framework are registered with a dependency injector engine, so using only the configurations files you can switch between Messages brokers, Serialization formats, Rpc transports, Stream compressors, and many more.
  • Integrated Log, Trace, and Status engines: you can log on different storage, also use differents trace storages and you have an integrated status library to check your service health.
  • A bot subsystem to create bot services on Telegram and Slack
  • Extensions methods for objects, strings, and IEnumerables.
  • Aspnet Core object viewer and compiler developer tool.
Supported log storages
  • Console
  • File
  • Html File
  • MessageBroker
  • ElasticSearch
  • Mail
Supported trace storages
  • File
  • MessageBroker
Supported compressors
  • Gzip
  • Deflate
  • Brotli
Supported messages brokers
  • RabbitMQ
  • NATS
  • NSQ
  • Kafka
  • Redis (Pub/Sub)
Supported key/value cache storages
  • Custom TWCore
  • Redis
Supported bot connectors
  • Slack
  • Telegram
Supported serializers
  • Newtonsoft JsonNet
  • XmlSerializer
  • BinaryFormatter
  • Utf8Json
  • MsgPack
  • NSerializer (Custom binary serializer with object reference graph support and cyclic reference)
  • RawSerializer (Like NSerializer but without internal caching, faster, but serialized objects are bigger in bytes size.)

Simple Object Serializer Benchmark

BenchmarkDotNet=v0.11.3, OS=Windows 10.0.17134.523 (1803/April2018Update/Redstone4)\
Intel Core i7-4770R CPU 3.20GHz (Haswell), 1 CPU, 8 logical and 4 physical cores\
.NET Core SDK=2.2.101\
  [Host] : .NET Core 2.2.0 (CoreCLR 4.6.27110.04, CoreFX 4.6.27110.04), 64bit RyuJIT\
  Core   : .NET Core 2.2.0 (CoreCLR 4.6.27110.04, CoreFX 4.6.27110.04), 64bit RyuJIT\
Job=Core  Runtime=Core
Method N Mean Error StdDev Min Max Gen 0/1k Op Gen 1/1k Op Gen 2/1k Op Allocated Memory/Op
NewtonsoftJsonSerializerToStream 1 42.935 us 0.4296 us 0.4019 us 42.123 us 43.608 us 3.6621 0.1831 - 23296 B
NewtonsoftJsonDeserializerFromStream 1 78.432 us 1.5565 us 1.4560 us 76.154 us 80.546 us 3.5400 0.8545 - 22960 B
XmlSerializerToStream 1 45.512 us 0.3721 us 0.3299 us 44.858 us 46.154 us 1.8921 - - 12224 B
XmlDeserializerFromStream 1 91.809 us 1.4537 us 1.3598 us 89.874 us 94.327 us 4.5166 0.3662 - 28608 B
BinaryFormatterSerializerToStream 1 53.381 us 0.5491 us 0.5137 us 52.418 us 54.022 us 2.5635 - - 16504 B
BinaryFormatterDeserializerFromStream 1 44.802 us 0.5174 us 0.4840 us 43.914 us 45.613 us 3.6011 0.4883 - 22720 B
Utf8JsonSerializerToStream 1 7.609 us 0.1364 us 0.1276 us 7.429 us 7.832 us - - - -
Utf8JsonDeserializerFromStream 1 20.249 us 0.2015 us 0.1885 us 20.009 us 20.641 us 0.9460 0.1831 - 6016 B
MessagePackSerializerToStream 1 7.777 us 0.0682 us 0.0638 us 7.658 us 7.900 us - - - 96 B
MessagePackDeserializerFromStream 1 11.087 us 0.1592 us 0.1489 us 10.795 us 11.419 us 1.3123 0.3204 - 8272 B
NSerializerToStream 1 7.823 us 0.1440 us 0.1347 us 7.607 us 8.051 us - - - -
NDeserializerFromStream 1 7.301 us 0.0702 us 0.0657 us 7.106 us 7.405 us 0.4425 0.0458 - 2800 B
RawSerializerToStream 1 6.574 us 0.1298 us 0.1275 us 6.375 us 6.781 us - - - -
RawDeserializerFromStream 1 7.837 us 0.0655 us 0.0613 us 7.748 us 7.937 us 0.5569 0.0763 - 3520 B

Serializer Graph

Created by Tony Redondo

Powered By

Thanks to @jetbrains for helping on this development with the licenses for Rider, dotTrace and dotMemory

Product Compatible and additional computed target framework versions.
.NET net5.0 is compatible.  net5.0-windows was computed.  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 is compatible.  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. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 is compatible.  netcoreapp2.2 is compatible.  netcoreapp3.0 was computed.  netcoreapp3.1 is compatible. 
.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 is compatible.  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.

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
3.1.0 305 10/22/2023
3.1.0-beta2 109 10/20/2023
3.1.0-beta1 95 10/19/2023
3.0.0-beta5 386 9/8/2019
3.0.0-beta4 348 9/8/2019
3.0.0-beta3 350 8/20/2019
3.0.0-beta2 339 8/18/2019
3.0.0-beta1 337 8/18/2019
2.1.181 768 7/24/2019
2.1.181-beta5 482 7/16/2019
2.1.181-beta4 487 5/10/2019
2.1.181-beta3 510 3/16/2019
2.1.181-beta2 496 3/8/2019
2.1.181-beta 500 3/3/2019
2.1.180 657 3/1/2019
2.1.180-rc1 522 2/28/2019
2.1.180-beta9 567 2/14/2019
2.1.180-beta8 529 2/14/2019
2.1.180-beta7 562 2/8/2019
2.1.180-beta6 566 2/7/2019
2.1.180-beta5 556 2/6/2019
2.1.180-beta4 577 2/5/2019
2.1.180-beta3 540 2/4/2019
2.1.180-beta2 532 2/4/2019
2.1.180-beta1 557 2/4/2019
2.1.180-alpha8 555 1/30/2019
2.1.180-alpha7 576 1/22/2019
2.1.180-alpha6 565 1/21/2019
2.1.180-alpha5 582 1/18/2019
2.1.180-alpha4 608 1/17/2019
2.1.180-alpha3 593 1/16/2019
2.1.180-alpha2 548 1/16/2019
2.1.180-alpha1 565 1/15/2019
2.1.179 746 1/9/2019
2.1.179-beta9 543 1/3/2019
2.1.179-beta8 553 1/2/2019
2.1.179-beta7 606 1/2/2019
2.1.179-beta6 587 12/21/2018
2.1.179-beta5 516 12/19/2018
2.1.179-beta4 542 12/19/2018
2.1.179-beta3 514 12/19/2018
2.1.179-beta2 548 12/18/2018
2.1.179-beta12 578 1/8/2019
2.1.179-beta11 578 1/7/2019
2.1.179-beta10 559 1/4/2019
2.1.179-beta1 557 12/18/2018
2.1.179-alpha9 503 12/18/2018
2.1.179-alpha8 579 11/28/2018
2.1.179-alpha7 582 11/22/2018
2.1.179-alpha6 593 11/20/2018
2.1.179-alpha5 573 11/20/2018
2.1.179-alpha4 603 11/20/2018
2.1.179-alpha3 627 11/19/2018
2.1.179-alpha2 635 11/16/2018
2.1.179-alpha 611 11/16/2018
2.1.178 810 11/6/2018
2.1.178-beta2 583 11/6/2018
2.1.178-beta1 635 10/29/2018
2.1.178-alpha7 643 10/22/2018
2.1.178-alpha6 655 10/19/2018
2.1.178-alpha5 635 10/17/2018
2.1.178-alpha4 649 10/14/2018
2.1.178-alpha3 614 10/13/2018
2.1.178-alpha2 616 10/9/2018
2.1.178-alpha 643 10/9/2018
2.1.177 817 9/27/2018
2.1.177-rc4 623 9/26/2018
2.1.177-rc3 621 9/26/2018
2.1.177-rc2 625 9/26/2018
2.1.177-rc1 611 9/25/2018
2.1.177-beta 605 9/25/2018
2.1.177-alpha 606 9/24/2018
2.1.176 808 9/20/2018
2.1.175 821 9/19/2018
2.1.174 821 9/16/2018
2.1.173 819 9/12/2018
2.1.173-beta 663 9/12/2018
2.1.172 814 9/11/2018
2.1.171 829 8/27/2018
2.1.171-rc1 652 8/27/2018
2.1.171-beta 640 8/27/2018
2.1.170 878 8/15/2018
2.1.169 864 8/14/2018
2.1.168 892 8/10/2018
2.1.167 917 8/9/2018
2.1.166 945 8/9/2018
2.1.165 956 8/9/2018
2.1.164 946 8/8/2018
2.1.163 909 8/8/2018
2.1.162 954 8/8/2018
2.1.161 960 8/8/2018
2.1.160 946 8/7/2018
2.1.159 941 8/3/2018
2.1.158 935 8/2/2018
2.1.157 935 8/1/2018
2.1.156 916 7/30/2018
2.1.155 952 7/29/2018
2.1.154 950 7/19/2018
2.1.153 1,087 7/12/2018
2.1.152 934 7/11/2018
2.1.151 1,051 7/11/2018
2.1.150 1,106 7/11/2018
2.1.149 1,129 7/10/2018
2.1.148 1,089 7/4/2018
2.1.147 1,044 7/3/2018
2.1.146 1,090 7/1/2018
2.1.145 974 7/1/2018
2.1.144 941 6/28/2018
2.1.143 965 6/25/2018
2.1.142 1,058 6/19/2018
2.1.141 1,073 6/19/2018
2.1.140 1,064 6/18/2018
2.0.149 1,176 7/10/2018
2.0.148 968 7/4/2018
2.0.147 957 7/3/2018
2.0.146 1,052 7/1/2018
2.0.145 1,108 7/1/2018
2.0.144 951 6/28/2018
2.0.143 1,147 6/25/2018
2.0.142 1,031 6/19/2018
2.0.141 944 6/19/2018
2.0.140 1,069 6/18/2018
2.0.139 921 6/18/2018
2.0.138 1,005 6/15/2018
2.0.137 1,004 6/15/2018
2.0.136 1,041 6/12/2018
2.0.135 1,072 6/11/2018
2.0.134 1,076 6/11/2018
2.0.133 1,068 6/11/2018
0.2.132 983 5/25/2018
0.2.131 926 5/21/2018
0.2.130 1,035 5/20/2018
0.2.129 1,090 5/20/2018
0.2.128 1,119 5/14/2018
0.2.127 967 5/11/2018
0.2.126 1,098 5/10/2018
0.2.125 1,096 5/8/2018
0.2.124 995 4/30/2018
0.2.123 1,101 4/29/2018
0.2.122 1,226 4/27/2018
0.2.121 1,105 4/26/2018
0.2.120 951 4/25/2018
0.2.119 1,097 4/25/2018
0.2.118 1,130 4/25/2018
0.2.117 1,129 4/24/2018
0.2.116 924 4/24/2018
0.2.115 1,131 4/19/2018
0.2.114 942 4/19/2018
0.2.113 1,095 4/19/2018
0.2.112 1,067 4/18/2018
0.2.111 921 4/18/2018
0.2.110 1,039 4/18/2018
0.2.109 907 4/17/2018
0.2.108 1,046 4/17/2018
0.2.107 1,060 4/9/2018
0.2.106 1,223 4/6/2018
0.2.105 1,111 4/3/2018
0.2.104 1,122 4/2/2018
0.2.103 1,005 3/28/2018
0.2.102 1,158 3/28/2018
0.2.101 1,079 3/28/2018
0.2.100 1,101 3/27/2018
0.2.99 1,262 3/24/2018
0.2.98 1,229 3/23/2018
0.2.97 1,086 3/19/2018
0.2.96 925 3/16/2018
0.2.95 1,077 3/15/2018
0.2.94 1,119 3/13/2018
0.2.93 1,124 3/12/2018
0.2.92 1,105 3/12/2018
0.2.91 1,086 3/12/2018
0.2.90 1,084 3/11/2018
0.2.89 954 3/6/2018
0.2.88 1,124 3/2/2018
0.2.87 1,075 3/1/2018
0.2.86 1,095 2/28/2018
0.2.85 1,069 2/28/2018
0.2.84 1,091 2/28/2018
0.2.83 1,074 2/27/2018
0.2.82 1,079 2/26/2018
0.2.81 1,096 2/23/2018
0.2.80 1,071 2/22/2018
0.2.79 1,069 2/21/2018
0.2.78 1,081 2/16/2018
0.2.77 1,081 2/14/2018
0.2.76 1,072 2/14/2018
0.2.75 1,064 2/9/2018
0.2.74 1,082 2/9/2018
0.2.73 1,115 2/1/2018
0.2.72 1,135 1/31/2018
0.2.71 1,111 1/30/2018
0.2.70 981 1/29/2018
0.2.69 1,000 1/26/2018
0.2.68 1,085 1/23/2018
0.2.67 983 1/22/2018
0.2.66 1,098 1/22/2018
0.2.65 1,124 1/19/2018
0.2.64 1,123 1/17/2018
0.2.63 958 1/16/2018
0.2.62 961 1/15/2018
0.2.61 976 12/18/2017
0.2.60 1,025 12/6/2017
0.2.59 999 12/5/2017
0.2.58 955 12/4/2017
0.2.57 953 12/1/2017
0.2.56 996 11/30/2017
0.2.55 967 11/28/2017
0.2.54 971 11/28/2017
0.2.53 1,012 11/28/2017
0.2.52 955 11/26/2017
0.2.51 950 11/24/2017
0.2.50 964 11/23/2017
0.2.49 991 11/17/2017
0.2.48 988 11/17/2017
0.2.47 986 11/16/2017
0.2.46 995 11/15/2017
0.2.45 990 11/13/2017
0.2.44 958 11/7/2017
0.2.43 987 11/7/2017
0.2.42 992 11/6/2017
0.2.41 981 10/31/2017
0.2.40 964 10/31/2017
0.2.39 975 10/26/2017
0.2.38 967 10/26/2017
0.2.37 980 10/25/2017
0.2.36 967 10/23/2017
0.2.35 978 10/20/2017
0.2.34 956 10/13/2017
0.2.33 998 10/10/2017
0.2.32 959 10/9/2017
0.2.31 953 10/7/2017
0.2.30 944 10/6/2017
0.2.29 955 9/29/2017
0.2.28 976 9/27/2017
0.2.27 966 9/25/2017
0.2.26 1,001 9/22/2017
0.2.25 991 9/20/2017
0.2.24 988 9/19/2017
0.2.23 983 9/13/2017
0.2.22 955 9/13/2017
0.2.21 950 9/13/2017
0.2.20 973 9/13/2017
0.2.19 954 9/12/2017
0.2.18 960 9/12/2017
0.2.17 960 9/11/2017
0.2.16 979 9/11/2017
0.2.15 957 9/8/2017
0.2.10 994 9/8/2017
0.2.9 1,031 8/29/2017
0.2.6 983 8/25/2017
0.2.5 1,004 8/16/2017
0.2.1-alpha 799 8/16/2017