TWCore.Data.SqlServer 3.1.0

.NET 5.0 .NET Core 2.1 .NET Standard 2.0 .NET Framework 4.7.2 
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. 
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. 
// Install TWCore.Data.SqlServer as a Cake Addin
#addin nuget:?package=TWCore.Data.SqlServer&version=3.1.0

// Install TWCore.Data.SqlServer as a Cake Tool
#tool nuget:?package=TWCore.Data.SqlServer&version=3.1.0

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. 
.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 224 10/22/2023
3.1.0-beta2 75 10/20/2023
3.1.0-beta1 67 10/19/2023
3.0.0-beta5 338 9/8/2019
3.0.0-beta4 308 9/8/2019
3.0.0-beta3 305 8/20/2019
3.0.0-beta2 294 8/18/2019
3.0.0-beta1 296 8/18/2019
2.1.181 711 7/24/2019
2.1.181-beta5 430 7/16/2019
2.1.181-beta4 431 5/10/2019
2.1.181-beta3 460 3/16/2019
2.1.181-beta2 446 3/8/2019
2.1.181-beta 446 3/3/2019
2.1.180 594 3/1/2019
2.1.180-rc1 465 2/28/2019
2.1.180-beta9 512 2/14/2019
2.1.180-beta8 490 2/14/2019
2.1.180-beta7 513 2/8/2019
2.1.180-beta6 509 2/7/2019
2.1.180-beta5 507 2/6/2019
2.1.180-beta4 523 2/5/2019
2.1.180-beta3 484 2/4/2019
2.1.180-beta2 492 2/4/2019
2.1.180-beta1 501 2/4/2019
2.1.180-alpha8 500 1/30/2019
2.1.180-alpha7 520 1/22/2019
2.1.180-alpha6 524 1/21/2019
2.1.180-alpha5 532 1/18/2019
2.1.180-alpha4 555 1/17/2019
2.1.180-alpha3 539 1/16/2019
2.1.180-alpha2 489 1/16/2019
2.1.180-alpha1 508 1/15/2019
2.1.179 679 1/9/2019
2.1.179-beta9 493 1/3/2019
2.1.179-beta8 512 1/2/2019
2.1.179-beta7 544 1/2/2019
2.1.179-beta6 527 12/21/2018
2.1.179-beta5 465 12/19/2018
2.1.179-beta4 481 12/19/2018
2.1.179-beta3 460 12/19/2018
2.1.179-beta2 494 12/18/2018
2.1.179-beta12 523 1/8/2019
2.1.179-beta11 521 1/7/2019
2.1.179-beta10 504 1/4/2019
2.1.179-beta1 505 12/18/2018
2.1.179-alpha9 461 12/18/2018
2.1.179-alpha8 529 11/28/2018
2.1.179-alpha7 524 11/22/2018
2.1.179-alpha6 526 11/20/2018
2.1.179-alpha5 519 11/20/2018
2.1.179-alpha4 534 11/20/2018
2.1.179-alpha3 556 11/19/2018
2.1.179-alpha2 562 11/16/2018
2.1.179-alpha 541 11/16/2018
2.1.178 727 11/6/2018
2.1.178-beta2 518 11/6/2018
2.1.178-beta1 568 10/29/2018
2.1.178-alpha7 570 10/22/2018
2.1.178-alpha6 582 10/19/2018
2.1.178-alpha5 555 10/17/2018
2.1.178-alpha4 573 10/14/2018
2.1.178-alpha3 546 10/13/2018
2.1.178-alpha2 546 10/9/2018
2.1.178-alpha 569 10/9/2018
2.1.177 729 9/27/2018
2.1.177-rc4 542 9/26/2018
2.1.177-rc3 539 9/26/2018
2.1.177-rc2 548 9/26/2018
2.1.177-rc1 532 9/25/2018
2.1.177-beta 533 9/25/2018
2.1.177-alpha 530 9/24/2018
2.1.176 720 9/20/2018
2.1.175 738 9/19/2018
2.1.174 736 9/16/2018
2.1.173 735 9/12/2018
2.1.173-beta 585 9/12/2018
2.1.172 744 9/11/2018
2.1.171 749 8/27/2018
2.1.171-rc1 573 8/27/2018
2.1.171-beta 562 8/27/2018
2.1.170 792 8/15/2018
2.1.169 794 8/14/2018
2.1.168 797 8/10/2018
2.1.167 832 8/9/2018
2.1.166 861 8/9/2018
2.1.165 875 8/9/2018
2.1.164 846 8/8/2018
2.1.163 799 8/8/2018
2.1.162 836 8/8/2018
2.1.161 854 8/8/2018
2.1.160 841 8/7/2018
2.1.159 835 8/3/2018
2.1.158 823 8/2/2018
2.1.157 824 8/1/2018
2.1.156 810 7/30/2018
2.1.155 837 7/29/2018
2.1.154 839 7/19/2018
2.1.153 941 7/12/2018
2.1.152 823 7/11/2018
2.1.151 898 7/11/2018
2.1.150 958 7/11/2018
2.1.149 977 7/10/2018
2.1.148 941 7/4/2018
2.1.147 890 7/3/2018
2.1.146 935 7/1/2018
2.1.145 853 7/1/2018
2.1.144 823 6/28/2018
2.1.143 852 6/25/2018
2.1.142 925 6/19/2018
2.1.141 925 6/19/2018
2.1.140 921 6/18/2018
2.0.149 1,021 7/10/2018
2.0.148 853 7/4/2018
2.0.147 851 7/3/2018
2.0.146 908 7/1/2018
2.0.145 959 7/1/2018
2.0.144 853 6/28/2018
2.0.143 993 6/25/2018
2.0.142 887 6/19/2018
2.0.141 836 6/19/2018
2.0.140 916 6/18/2018
2.0.139 811 6/18/2018
2.0.138 856 6/15/2018
2.0.137 861 6/15/2018
2.0.136 897 6/12/2018
2.0.135 920 6/11/2018
2.0.134 932 6/11/2018
2.0.133 914 6/11/2018
0.2.132 868 5/25/2018
0.2.131 813 5/21/2018
0.2.130 882 5/20/2018
0.2.129 939 5/20/2018
0.2.128 960 5/14/2018
0.2.127 856 5/11/2018
0.2.126 954 5/10/2018
0.2.125 929 5/8/2018
0.2.124 872 4/30/2018
0.2.123 940 4/29/2018
0.2.122 1,067 4/27/2018
0.2.121 938 4/26/2018
0.2.120 838 4/25/2018
0.2.119 940 4/25/2018
0.2.118 972 4/25/2018
0.2.117 952 4/24/2018
0.2.116 821 4/24/2018
0.2.115 919 4/19/2018
0.2.114 818 4/19/2018
0.2.113 925 4/19/2018
0.2.112 909 4/18/2018
0.2.111 803 4/18/2018
0.2.110 882 4/18/2018
0.2.109 799 4/17/2018
0.2.108 892 4/17/2018
0.2.107 908 4/9/2018
0.2.106 1,066 4/6/2018
0.2.105 953 4/3/2018
0.2.104 962 4/2/2018
0.2.103 893 3/28/2018
0.2.102 1,003 3/28/2018
0.2.101 919 3/28/2018
0.2.100 935 3/27/2018
0.2.99 1,109 3/24/2018
0.2.98 1,085 3/23/2018
0.2.97 926 3/19/2018
0.2.96 811 3/16/2018
0.2.95 932 3/15/2018
0.2.94 975 3/13/2018
0.2.93 969 3/12/2018
0.2.92 951 3/12/2018
0.2.91 942 3/12/2018
0.2.90 932 3/11/2018
0.2.89 842 3/6/2018
0.2.88 964 3/2/2018
0.2.87 912 3/1/2018
0.2.86 933 2/28/2018
0.2.85 910 2/28/2018
0.2.84 934 2/28/2018
0.2.83 920 2/27/2018
0.2.82 912 2/26/2018
0.2.81 934 2/23/2018
0.2.80 914 2/22/2018
0.2.79 913 2/21/2018
0.2.78 936 2/16/2018
0.2.77 937 2/14/2018
0.2.76 916 2/14/2018
0.2.75 916 2/9/2018
0.2.74 919 2/9/2018
0.2.73 958 2/1/2018
0.2.72 971 1/31/2018
0.2.71 961 1/30/2018
0.2.70 870 1/29/2018
0.2.69 877 1/26/2018
0.2.68 936 1/23/2018
0.2.67 864 1/22/2018
0.2.66 933 1/22/2018
0.2.65 957 1/19/2018
0.2.64 958 1/17/2018
0.2.63 854 1/16/2018
0.2.62 857 1/15/2018
0.2.61 847 12/18/2017
0.2.60 900 12/6/2017
0.2.59 868 12/5/2017
0.2.58 838 12/4/2017
0.2.57 851 12/1/2017
0.2.56 869 11/30/2017
0.2.55 840 11/28/2017
0.2.54 856 11/28/2017
0.2.53 877 11/28/2017
0.2.52 842 11/26/2017
0.2.51 836 11/24/2017
0.2.50 857 11/23/2017
0.2.49 864 11/17/2017
0.2.48 868 11/17/2017
0.2.47 843 11/16/2017
0.2.46 880 11/15/2017
0.2.45 868 11/13/2017
0.2.44 851 11/7/2017
0.2.43 867 11/7/2017
0.2.42 870 11/6/2017
0.2.41 858 10/31/2017
0.2.40 840 10/31/2017
0.2.39 848 10/26/2017
0.2.38 856 10/26/2017
0.2.37 855 10/25/2017
0.2.36 845 10/23/2017
0.2.35 859 10/20/2017
0.2.34 834 10/13/2017
0.2.33 872 10/10/2017
0.2.32 845 10/9/2017
0.2.31 837 10/7/2017
0.2.30 822 10/6/2017
0.2.29 834 9/29/2017
0.2.28 858 9/27/2017
0.2.27 844 9/25/2017
0.2.26 884 9/22/2017
0.2.25 876 9/20/2017
0.2.24 868 9/19/2017
0.2.23 863 9/13/2017
0.2.22 837 9/13/2017
0.2.21 827 9/13/2017
0.2.20 855 9/13/2017
0.2.19 833 9/12/2017
0.2.18 845 9/12/2017
0.2.17 834 9/11/2017
0.2.16 850 9/11/2017
0.2.15 838 9/8/2017
0.2.10 872 9/8/2017
0.2.9 909 8/29/2017
0.2.6 863 8/25/2017
0.2.5 889 8/16/2017
0.2.1-alpha 688 8/16/2017