TWCore.Data.SqlServer 3.1.0

.NET 5.0 This package targets .NET 5.0. The package is compatible with this framework or higher. .NET Core 2.1 This package targets .NET Core 2.1. The package is compatible with this framework or higher. .NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. .NET Framework 4.7.2 This package targets .NET Framework 4.7.2. The package is compatible with this framework or higher. 
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.  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 293 10/22/2023
3.1.0-beta2 108 10/20/2023
3.1.0-beta1 95 10/19/2023
3.0.0-beta5 362 9/8/2019
3.0.0-beta4 324 9/8/2019
3.0.0-beta3 327 8/20/2019
3.0.0-beta2 316 8/18/2019
3.0.0-beta1 314 8/18/2019
2.1.181 744 7/24/2019
2.1.181-beta5 459 7/16/2019
2.1.181-beta4 462 5/10/2019
2.1.181-beta3 484 3/16/2019
2.1.181-beta2 470 3/8/2019
2.1.181-beta 475 3/3/2019
2.1.180 630 3/1/2019
2.1.180-rc1 497 2/28/2019
2.1.180-beta9 542 2/14/2019
2.1.180-beta8 504 2/14/2019
2.1.180-beta7 537 2/8/2019
2.1.180-beta6 541 2/7/2019
2.1.180-beta5 531 2/6/2019
2.1.180-beta4 552 2/5/2019
2.1.180-beta3 515 2/4/2019
2.1.180-beta2 507 2/4/2019
2.1.180-beta1 531 2/4/2019
2.1.180-alpha8 530 1/30/2019
2.1.180-alpha7 551 1/22/2019
2.1.180-alpha6 539 1/21/2019
2.1.180-alpha5 557 1/18/2019
2.1.180-alpha4 581 1/17/2019
2.1.180-alpha3 568 1/16/2019
2.1.180-alpha2 521 1/16/2019
2.1.180-alpha1 539 1/15/2019
2.1.179 717 1/9/2019
2.1.179-beta9 517 1/3/2019
2.1.179-beta8 526 1/2/2019
2.1.179-beta7 579 1/2/2019
2.1.179-beta6 561 12/21/2018
2.1.179-beta5 489 12/19/2018
2.1.179-beta4 516 12/19/2018
2.1.179-beta3 488 12/19/2018
2.1.179-beta2 521 12/18/2018
2.1.179-beta12 552 1/8/2019
2.1.179-beta11 551 1/7/2019
2.1.179-beta10 527 1/4/2019
2.1.179-beta1 531 12/18/2018
2.1.179-alpha9 476 12/18/2018
2.1.179-alpha8 550 11/28/2018
2.1.179-alpha7 552 11/22/2018
2.1.179-alpha6 556 11/20/2018
2.1.179-alpha5 539 11/20/2018
2.1.179-alpha4 568 11/20/2018
2.1.179-alpha3 590 11/19/2018
2.1.179-alpha2 601 11/16/2018
2.1.179-alpha 577 11/16/2018
2.1.178 775 11/6/2018
2.1.178-beta2 548 11/6/2018
2.1.178-beta1 599 10/29/2018
2.1.178-alpha7 607 10/22/2018
2.1.178-alpha6 618 10/19/2018
2.1.178-alpha5 599 10/17/2018
2.1.178-alpha4 613 10/14/2018
2.1.178-alpha3 578 10/13/2018
2.1.178-alpha2 580 10/9/2018
2.1.178-alpha 608 10/9/2018
2.1.177 779 9/27/2018
2.1.177-rc4 587 9/26/2018
2.1.177-rc3 585 9/26/2018
2.1.177-rc2 588 9/26/2018
2.1.177-rc1 575 9/25/2018
2.1.177-beta 568 9/25/2018
2.1.177-alpha 570 9/24/2018
2.1.176 770 9/20/2018
2.1.175 784 9/19/2018
2.1.174 784 9/16/2018
2.1.173 783 9/12/2018
2.1.173-beta 627 9/12/2018
2.1.172 776 9/11/2018
2.1.171 790 8/27/2018
2.1.171-rc1 615 8/27/2018
2.1.171-beta 603 8/27/2018
2.1.170 839 8/15/2018
2.1.169 825 8/14/2018
2.1.168 852 8/10/2018
2.1.167 878 8/9/2018
2.1.166 908 8/9/2018
2.1.165 917 8/9/2018
2.1.164 907 8/8/2018
2.1.163 846 8/8/2018
2.1.162 888 8/8/2018
2.1.161 895 8/8/2018
2.1.160 882 8/7/2018
2.1.159 876 8/3/2018
2.1.158 870 8/2/2018
2.1.157 870 8/1/2018
2.1.156 852 7/30/2018
2.1.155 887 7/29/2018
2.1.154 885 7/19/2018
2.1.153 986 7/12/2018
2.1.152 869 7/11/2018
2.1.151 947 7/11/2018
2.1.150 1,006 7/11/2018
2.1.149 1,029 7/10/2018
2.1.148 989 7/4/2018
2.1.147 944 7/3/2018
2.1.146 988 7/1/2018
2.1.145 906 7/1/2018
2.1.144 875 6/28/2018
2.1.143 898 6/25/2018
2.1.142 955 6/19/2018
2.1.141 969 6/19/2018
2.1.140 962 6/18/2018
2.0.149 1,078 7/10/2018
2.0.148 901 7/4/2018
2.0.147 892 7/3/2018
2.0.146 949 7/1/2018
2.0.145 1,006 7/1/2018
2.0.144 885 6/28/2018
2.0.143 1,045 6/25/2018
2.0.142 929 6/19/2018
2.0.141 877 6/19/2018
2.0.140 967 6/18/2018
2.0.139 854 6/18/2018
2.0.138 905 6/15/2018
2.0.137 902 6/15/2018
2.0.136 939 6/12/2018
2.0.135 970 6/11/2018
2.0.134 974 6/11/2018
2.0.133 965 6/11/2018
0.2.132 916 5/25/2018
0.2.131 861 5/21/2018
0.2.130 930 5/20/2018
0.2.129 987 5/20/2018
0.2.128 1,007 5/14/2018
0.2.127 897 5/11/2018
0.2.126 986 5/10/2018
0.2.125 983 5/8/2018
0.2.124 923 4/30/2018
0.2.123 989 4/29/2018
0.2.122 1,112 4/27/2018
0.2.121 993 4/26/2018
0.2.120 879 4/25/2018
0.2.119 984 4/25/2018
0.2.118 1,018 4/25/2018
0.2.117 1,017 4/24/2018
0.2.116 852 4/24/2018
0.2.115 960 4/19/2018
0.2.114 870 4/19/2018
0.2.113 979 4/19/2018
0.2.112 954 4/18/2018
0.2.111 850 4/18/2018
0.2.110 929 4/18/2018
0.2.109 836 4/17/2018
0.2.108 934 4/17/2018
0.2.107 950 4/9/2018
0.2.106 1,113 4/6/2018
0.2.105 1,001 4/3/2018
0.2.104 1,010 4/2/2018
0.2.103 933 3/28/2018
0.2.102 1,045 3/28/2018
0.2.101 967 3/28/2018
0.2.100 989 3/27/2018
0.2.99 1,149 3/24/2018
0.2.98 1,115 3/23/2018
0.2.97 974 3/19/2018
0.2.96 850 3/16/2018
0.2.95 964 3/15/2018
0.2.94 1,007 3/13/2018
0.2.93 1,011 3/12/2018
0.2.92 991 3/12/2018
0.2.91 974 3/12/2018
0.2.90 972 3/11/2018
0.2.89 883 3/6/2018
0.2.88 1,011 3/2/2018
0.2.87 964 3/1/2018
0.2.86 982 2/28/2018
0.2.85 958 2/28/2018
0.2.84 980 2/28/2018
0.2.83 962 2/27/2018
0.2.82 966 2/26/2018
0.2.81 984 2/23/2018
0.2.80 957 2/22/2018
0.2.79 957 2/21/2018
0.2.78 968 2/16/2018
0.2.77 969 2/14/2018
0.2.76 959 2/14/2018
0.2.75 953 2/9/2018
0.2.74 969 2/9/2018
0.2.73 1,000 2/1/2018
0.2.72 1,021 1/31/2018
0.2.71 999 1/30/2018
0.2.70 909 1/29/2018
0.2.69 927 1/26/2018
0.2.68 968 1/23/2018
0.2.67 909 1/22/2018
0.2.66 981 1/22/2018
0.2.65 1,008 1/19/2018
0.2.64 1,007 1/17/2018
0.2.63 885 1/16/2018
0.2.62 887 1/15/2018
0.2.61 903 12/18/2017
0.2.60 952 12/6/2017
0.2.59 923 12/5/2017
0.2.58 879 12/4/2017
0.2.57 879 12/1/2017
0.2.56 921 11/30/2017
0.2.55 891 11/28/2017
0.2.54 896 11/28/2017
0.2.53 937 11/28/2017
0.2.52 881 11/26/2017
0.2.51 875 11/24/2017
0.2.50 886 11/23/2017
0.2.49 918 11/17/2017
0.2.48 913 11/17/2017
0.2.47 913 11/16/2017
0.2.46 921 11/15/2017
0.2.45 915 11/13/2017
0.2.44 881 11/7/2017
0.2.43 914 11/7/2017
0.2.42 917 11/6/2017
0.2.41 906 10/31/2017
0.2.40 890 10/31/2017
0.2.39 899 10/26/2017
0.2.38 891 10/26/2017
0.2.37 904 10/25/2017
0.2.36 891 10/23/2017
0.2.35 904 10/20/2017
0.2.34 882 10/13/2017
0.2.33 923 10/10/2017
0.2.32 883 10/9/2017
0.2.31 878 10/7/2017
0.2.30 865 10/6/2017
0.2.29 880 9/29/2017
0.2.28 901 9/27/2017
0.2.27 891 9/25/2017
0.2.26 928 9/22/2017
0.2.25 917 9/20/2017
0.2.24 908 9/19/2017
0.2.23 907 9/13/2017
0.2.22 882 9/13/2017
0.2.21 874 9/13/2017
0.2.20 897 9/13/2017
0.2.19 879 9/12/2017
0.2.18 885 9/12/2017
0.2.17 884 9/11/2017
0.2.16 904 9/11/2017
0.2.15 884 9/8/2017
0.2.10 918 9/8/2017
0.2.9 956 8/29/2017
0.2.6 907 8/25/2017
0.2.5 929 8/16/2017
0.2.1-alpha 725 8/16/2017