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 225 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 681 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 729 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 731 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 722 9/20/2018
2.1.175 740 9/19/2018
2.1.174 738 9/16/2018
2.1.173 737 9/12/2018
2.1.173-beta 585 9/12/2018
2.1.172 746 9/11/2018
2.1.171 751 8/27/2018
2.1.171-rc1 573 8/27/2018
2.1.171-beta 562 8/27/2018
2.1.170 794 8/15/2018
2.1.169 796 8/14/2018
2.1.168 799 8/10/2018
2.1.167 834 8/9/2018
2.1.166 863 8/9/2018
2.1.165 877 8/9/2018
2.1.164 848 8/8/2018
2.1.163 801 8/8/2018
2.1.162 838 8/8/2018
2.1.161 856 8/8/2018
2.1.160 843 8/7/2018
2.1.159 837 8/3/2018
2.1.158 825 8/2/2018
2.1.157 826 8/1/2018
2.1.156 812 7/30/2018
2.1.155 839 7/29/2018
2.1.154 841 7/19/2018
2.1.153 943 7/12/2018
2.1.152 825 7/11/2018
2.1.151 900 7/11/2018
2.1.150 960 7/11/2018
2.1.149 979 7/10/2018
2.1.148 943 7/4/2018
2.1.147 892 7/3/2018
2.1.146 937 7/1/2018
2.1.145 855 7/1/2018
2.1.144 825 6/28/2018
2.1.143 854 6/25/2018
2.1.142 927 6/19/2018
2.1.141 927 6/19/2018
2.1.140 923 6/18/2018
2.0.149 1,023 7/10/2018
2.0.148 855 7/4/2018
2.0.147 853 7/3/2018
2.0.146 910 7/1/2018
2.0.145 961 7/1/2018
2.0.144 855 6/28/2018
2.0.143 995 6/25/2018
2.0.142 889 6/19/2018
2.0.141 838 6/19/2018
2.0.140 918 6/18/2018
2.0.139 813 6/18/2018
2.0.138 858 6/15/2018
2.0.137 863 6/15/2018
2.0.136 899 6/12/2018
2.0.135 922 6/11/2018
2.0.134 934 6/11/2018
2.0.133 916 6/11/2018
0.2.132 870 5/25/2018
0.2.131 815 5/21/2018
0.2.130 884 5/20/2018
0.2.129 941 5/20/2018
0.2.128 962 5/14/2018
0.2.127 858 5/11/2018
0.2.126 956 5/10/2018
0.2.125 931 5/8/2018
0.2.124 874 4/30/2018
0.2.123 942 4/29/2018
0.2.122 1,069 4/27/2018
0.2.121 940 4/26/2018
0.2.120 840 4/25/2018
0.2.119 942 4/25/2018
0.2.118 974 4/25/2018
0.2.117 954 4/24/2018
0.2.116 823 4/24/2018
0.2.115 921 4/19/2018
0.2.114 820 4/19/2018
0.2.113 927 4/19/2018
0.2.112 911 4/18/2018
0.2.111 805 4/18/2018
0.2.110 884 4/18/2018
0.2.109 801 4/17/2018
0.2.108 894 4/17/2018
0.2.107 910 4/9/2018
0.2.106 1,068 4/6/2018
0.2.105 955 4/3/2018
0.2.104 964 4/2/2018
0.2.103 895 3/28/2018
0.2.102 1,005 3/28/2018
0.2.101 921 3/28/2018
0.2.100 937 3/27/2018
0.2.99 1,111 3/24/2018
0.2.98 1,087 3/23/2018
0.2.97 928 3/19/2018
0.2.96 813 3/16/2018
0.2.95 934 3/15/2018
0.2.94 977 3/13/2018
0.2.93 971 3/12/2018
0.2.92 953 3/12/2018
0.2.91 944 3/12/2018
0.2.90 934 3/11/2018
0.2.89 844 3/6/2018
0.2.88 966 3/2/2018
0.2.87 914 3/1/2018
0.2.86 935 2/28/2018
0.2.85 912 2/28/2018
0.2.84 936 2/28/2018
0.2.83 922 2/27/2018
0.2.82 914 2/26/2018
0.2.81 936 2/23/2018
0.2.80 916 2/22/2018
0.2.79 915 2/21/2018
0.2.78 938 2/16/2018
0.2.77 939 2/14/2018
0.2.76 918 2/14/2018
0.2.75 918 2/9/2018
0.2.74 921 2/9/2018
0.2.73 960 2/1/2018
0.2.72 973 1/31/2018
0.2.71 963 1/30/2018
0.2.70 872 1/29/2018
0.2.69 879 1/26/2018
0.2.68 938 1/23/2018
0.2.67 866 1/22/2018
0.2.66 935 1/22/2018
0.2.65 959 1/19/2018
0.2.64 960 1/17/2018
0.2.63 856 1/16/2018
0.2.62 859 1/15/2018
0.2.61 849 12/18/2017
0.2.60 902 12/6/2017
0.2.59 870 12/5/2017
0.2.58 840 12/4/2017
0.2.57 853 12/1/2017
0.2.56 871 11/30/2017
0.2.55 842 11/28/2017
0.2.54 858 11/28/2017
0.2.53 879 11/28/2017
0.2.52 844 11/26/2017
0.2.51 838 11/24/2017
0.2.50 859 11/23/2017
0.2.49 866 11/17/2017
0.2.48 870 11/17/2017
0.2.47 845 11/16/2017
0.2.46 882 11/15/2017
0.2.45 870 11/13/2017
0.2.44 853 11/7/2017
0.2.43 869 11/7/2017
0.2.42 872 11/6/2017
0.2.41 860 10/31/2017
0.2.40 842 10/31/2017
0.2.39 850 10/26/2017
0.2.38 858 10/26/2017
0.2.37 857 10/25/2017
0.2.36 847 10/23/2017
0.2.35 861 10/20/2017
0.2.34 836 10/13/2017
0.2.33 874 10/10/2017
0.2.32 847 10/9/2017
0.2.31 839 10/7/2017
0.2.30 824 10/6/2017
0.2.29 836 9/29/2017
0.2.28 860 9/27/2017
0.2.27 846 9/25/2017
0.2.26 886 9/22/2017
0.2.25 878 9/20/2017
0.2.24 870 9/19/2017
0.2.23 865 9/13/2017
0.2.22 839 9/13/2017
0.2.21 829 9/13/2017
0.2.20 857 9/13/2017
0.2.19 835 9/12/2017
0.2.18 847 9/12/2017
0.2.17 836 9/11/2017
0.2.16 852 9/11/2017
0.2.15 840 9/8/2017
0.2.10 874 9/8/2017
0.2.9 911 8/29/2017
0.2.6 865 8/25/2017
0.2.5 891 8/16/2017
0.2.1-alpha 688 8/16/2017