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. 
.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 264 10/22/2023
3.1.0-beta2 95 10/20/2023
3.1.0-beta1 86 10/19/2023
3.0.0-beta5 348 9/8/2019
3.0.0-beta4 313 9/8/2019
3.0.0-beta3 309 8/20/2019
3.0.0-beta2 304 8/18/2019
3.0.0-beta1 302 8/18/2019
2.1.181 731 7/24/2019
2.1.181-beta5 445 7/16/2019
2.1.181-beta4 450 5/10/2019
2.1.181-beta3 472 3/16/2019
2.1.181-beta2 460 3/8/2019
2.1.181-beta 466 3/3/2019
2.1.180 615 3/1/2019
2.1.180-rc1 485 2/28/2019
2.1.180-beta9 525 2/14/2019
2.1.180-beta8 493 2/14/2019
2.1.180-beta7 525 2/8/2019
2.1.180-beta6 531 2/7/2019
2.1.180-beta5 520 2/6/2019
2.1.180-beta4 541 2/5/2019
2.1.180-beta3 503 2/4/2019
2.1.180-beta2 495 2/4/2019
2.1.180-beta1 521 2/4/2019
2.1.180-alpha8 521 1/30/2019
2.1.180-alpha7 539 1/22/2019
2.1.180-alpha6 528 1/21/2019
2.1.180-alpha5 546 1/18/2019
2.1.180-alpha4 571 1/17/2019
2.1.180-alpha3 552 1/16/2019
2.1.180-alpha2 512 1/16/2019
2.1.180-alpha1 530 1/15/2019
2.1.179 705 1/9/2019
2.1.179-beta9 506 1/3/2019
2.1.179-beta8 515 1/2/2019
2.1.179-beta7 562 1/2/2019
2.1.179-beta6 551 12/21/2018
2.1.179-beta5 479 12/19/2018
2.1.179-beta4 501 12/19/2018
2.1.179-beta3 473 12/19/2018
2.1.179-beta2 512 12/18/2018
2.1.179-beta12 543 1/8/2019
2.1.179-beta11 542 1/7/2019
2.1.179-beta10 517 1/4/2019
2.1.179-beta1 522 12/18/2018
2.1.179-alpha9 467 12/18/2018
2.1.179-alpha8 535 11/28/2018
2.1.179-alpha7 540 11/22/2018
2.1.179-alpha6 540 11/20/2018
2.1.179-alpha5 524 11/20/2018
2.1.179-alpha4 552 11/20/2018
2.1.179-alpha3 577 11/19/2018
2.1.179-alpha2 587 11/16/2018
2.1.179-alpha 561 11/16/2018
2.1.178 759 11/6/2018
2.1.178-beta2 533 11/6/2018
2.1.178-beta1 587 10/29/2018
2.1.178-alpha7 587 10/22/2018
2.1.178-alpha6 605 10/19/2018
2.1.178-alpha5 583 10/17/2018
2.1.178-alpha4 598 10/14/2018
2.1.178-alpha3 563 10/13/2018
2.1.178-alpha2 563 10/9/2018
2.1.178-alpha 593 10/9/2018
2.1.177 756 9/27/2018
2.1.177-rc4 570 9/26/2018
2.1.177-rc3 568 9/26/2018
2.1.177-rc2 571 9/26/2018
2.1.177-rc1 550 9/25/2018
2.1.177-beta 551 9/25/2018
2.1.177-alpha 548 9/24/2018
2.1.176 748 9/20/2018
2.1.175 763 9/19/2018
2.1.174 764 9/16/2018
2.1.173 762 9/12/2018
2.1.173-beta 609 9/12/2018
2.1.172 756 9/11/2018
2.1.171 770 8/27/2018
2.1.171-rc1 598 8/27/2018
2.1.171-beta 586 8/27/2018
2.1.170 819 8/15/2018
2.1.169 803 8/14/2018
2.1.168 830 8/10/2018
2.1.167 858 8/9/2018
2.1.166 887 8/9/2018
2.1.165 898 8/9/2018
2.1.164 887 8/8/2018
2.1.163 826 8/8/2018
2.1.162 862 8/8/2018
2.1.161 875 8/8/2018
2.1.160 861 8/7/2018
2.1.159 858 8/3/2018
2.1.158 850 8/2/2018
2.1.157 851 8/1/2018
2.1.156 832 7/30/2018
2.1.155 868 7/29/2018
2.1.154 865 7/19/2018
2.1.153 967 7/12/2018
2.1.152 848 7/11/2018
2.1.151 919 7/11/2018
2.1.150 985 7/11/2018
2.1.149 1,008 7/10/2018
2.1.148 968 7/4/2018
2.1.147 922 7/3/2018
2.1.146 967 7/1/2018
2.1.145 881 7/1/2018
2.1.144 855 6/28/2018
2.1.143 878 6/25/2018
2.1.142 936 6/19/2018
2.1.141 950 6/19/2018
2.1.140 942 6/18/2018
2.0.149 1,057 7/10/2018
2.0.148 881 7/4/2018
2.0.147 871 7/3/2018
2.0.146 929 7/1/2018
2.0.145 985 7/1/2018
2.0.144 865 6/28/2018
2.0.143 1,024 6/25/2018
2.0.142 908 6/19/2018
2.0.141 857 6/19/2018
2.0.140 945 6/18/2018
2.0.139 834 6/18/2018
2.0.138 884 6/15/2018
2.0.137 882 6/15/2018
2.0.136 918 6/12/2018
2.0.135 949 6/11/2018
2.0.134 953 6/11/2018
2.0.133 944 6/11/2018
0.2.132 896 5/25/2018
0.2.131 841 5/21/2018
0.2.130 909 5/20/2018
0.2.129 966 5/20/2018
0.2.128 986 5/14/2018
0.2.127 877 5/11/2018
0.2.126 965 5/10/2018
0.2.125 962 5/8/2018
0.2.124 903 4/30/2018
0.2.123 968 4/29/2018
0.2.122 1,093 4/27/2018
0.2.121 972 4/26/2018
0.2.120 859 4/25/2018
0.2.119 962 4/25/2018
0.2.118 997 4/25/2018
0.2.117 991 4/24/2018
0.2.116 832 4/24/2018
0.2.115 940 4/19/2018
0.2.114 850 4/19/2018
0.2.113 960 4/19/2018
0.2.112 934 4/18/2018
0.2.111 830 4/18/2018
0.2.110 902 4/18/2018
0.2.109 816 4/17/2018
0.2.108 912 4/17/2018
0.2.107 929 4/9/2018
0.2.106 1,091 4/6/2018
0.2.105 980 4/3/2018
0.2.104 989 4/2/2018
0.2.103 915 3/28/2018
0.2.102 1,024 3/28/2018
0.2.101 939 3/28/2018
0.2.100 968 3/27/2018
0.2.99 1,128 3/24/2018
0.2.98 1,096 3/23/2018
0.2.97 955 3/19/2018
0.2.96 832 3/16/2018
0.2.95 942 3/15/2018
0.2.94 986 3/13/2018
0.2.93 990 3/12/2018
0.2.92 971 3/12/2018
0.2.91 953 3/12/2018
0.2.90 952 3/11/2018
0.2.89 863 3/6/2018
0.2.88 993 3/2/2018
0.2.87 945 3/1/2018
0.2.86 960 2/28/2018
0.2.85 937 2/28/2018
0.2.84 959 2/28/2018
0.2.83 941 2/27/2018
0.2.82 945 2/26/2018
0.2.81 962 2/23/2018
0.2.80 938 2/22/2018
0.2.79 938 2/21/2018
0.2.78 947 2/16/2018
0.2.77 948 2/14/2018
0.2.76 942 2/14/2018
0.2.75 932 2/9/2018
0.2.74 947 2/9/2018
0.2.73 978 2/1/2018
0.2.72 1,000 1/31/2018
0.2.71 980 1/30/2018
0.2.70 891 1/29/2018
0.2.69 907 1/26/2018
0.2.68 947 1/23/2018
0.2.67 890 1/22/2018
0.2.66 960 1/22/2018
0.2.65 986 1/19/2018
0.2.64 988 1/17/2018
0.2.63 865 1/16/2018
0.2.62 868 1/15/2018
0.2.61 883 12/18/2017
0.2.60 932 12/6/2017
0.2.59 903 12/5/2017
0.2.58 859 12/4/2017
0.2.57 863 12/1/2017
0.2.56 903 11/30/2017
0.2.55 872 11/28/2017
0.2.54 878 11/28/2017
0.2.53 908 11/28/2017
0.2.52 863 11/26/2017
0.2.51 855 11/24/2017
0.2.50 868 11/23/2017
0.2.49 900 11/17/2017
0.2.48 896 11/17/2017
0.2.47 878 11/16/2017
0.2.46 901 11/15/2017
0.2.45 897 11/13/2017
0.2.44 863 11/7/2017
0.2.43 888 11/7/2017
0.2.42 893 11/6/2017
0.2.41 885 10/31/2017
0.2.40 866 10/31/2017
0.2.39 881 10/26/2017
0.2.38 868 10/26/2017
0.2.37 884 10/25/2017
0.2.36 866 10/23/2017
0.2.35 888 10/20/2017
0.2.34 862 10/13/2017
0.2.33 905 10/10/2017
0.2.32 867 10/9/2017
0.2.31 858 10/7/2017
0.2.30 848 10/6/2017
0.2.29 861 9/29/2017
0.2.28 883 9/27/2017
0.2.27 873 9/25/2017
0.2.26 912 9/22/2017
0.2.25 897 9/20/2017
0.2.24 890 9/19/2017
0.2.23 889 9/13/2017
0.2.22 864 9/13/2017
0.2.21 856 9/13/2017
0.2.20 879 9/13/2017
0.2.19 858 9/12/2017
0.2.18 866 9/12/2017
0.2.17 866 9/11/2017
0.2.16 885 9/11/2017
0.2.15 866 9/8/2017
0.2.10 899 9/8/2017
0.2.9 938 8/29/2017
0.2.6 889 8/25/2017
0.2.5 910 8/16/2017
0.2.1-alpha 713 8/16/2017