TWCore.Data.SqlServer 3.1.0-beta2

.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.
This is a prerelease version of TWCore.Data.SqlServer.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package TWCore.Data.SqlServer --version 3.1.0-beta2                

                    
                

            
NuGet\Install-Package TWCore.Data.SqlServer -Version 3.1.0-beta2
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-beta2" />
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-beta2                

                    
                

            
#r "nuget: TWCore.Data.SqlServer, 3.1.0-beta2"
#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-beta2&prerelease

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

<img src="https://raw.githubusercontent.com/tonyredondo/TWCore2/master/doc/icon.png" alt="Potato" width="45px" height="45px" /> 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

<img src="https://raw.githubusercontent.com/tonyredondo/TWCore2/master/doc/serializer-deserializer1.png" alt="Serializer Graph" />

Created by Daniel Redondo

Powered By

<img src="https://raw.githubusercontent.com/tonyredondo/TWCore2/master/doc/rider.jpg" alt="Rider" width="50px" height="50px" /><img src="https://raw.githubusercontent.com/tonyredondo/TWCore2/master/doc/dotTrace.png" alt="dotTrace" width="50px" height="50px" /><img src="https://raw.githubusercontent.com/tonyredondo/TWCore2/master/doc/dotMemory.png" alt="dotMemory" width="50px" height="50px" />

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 278 10/22/2023
3.1.0-beta2 102 10/20/2023
3.1.0-beta1 91 10/19/2023
3.0.0-beta5 358 9/8/2019
3.0.0-beta4 320 9/8/2019
3.0.0-beta3 322 8/20/2019
3.0.0-beta2 311 8/18/2019
3.0.0-beta1 309 8/18/2019
2.1.181 736 7/24/2019
2.1.181-beta5 455 7/16/2019
2.1.181-beta4 458 5/10/2019
2.1.181-beta3 480 3/16/2019
2.1.181-beta2 466 3/8/2019
2.1.181-beta 471 3/3/2019
2.1.180 622 3/1/2019
2.1.180-rc1 493 2/28/2019
2.1.180-beta9 537 2/14/2019
2.1.180-beta8 500 2/14/2019
2.1.180-beta7 533 2/8/2019
2.1.180-beta6 537 2/7/2019
2.1.180-beta5 527 2/6/2019
2.1.180-beta4 548 2/5/2019
2.1.180-beta3 510 2/4/2019
2.1.180-beta2 502 2/4/2019
2.1.180-beta1 526 2/4/2019
2.1.180-alpha8 526 1/30/2019
2.1.180-alpha7 547 1/22/2019
2.1.180-alpha6 535 1/21/2019
2.1.180-alpha5 553 1/18/2019
2.1.180-alpha4 577 1/17/2019
2.1.180-alpha3 562 1/16/2019
2.1.180-alpha2 517 1/16/2019
2.1.180-alpha1 535 1/15/2019
2.1.179 709 1/9/2019
2.1.179-beta9 513 1/3/2019
2.1.179-beta8 522 1/2/2019
2.1.179-beta7 574 1/2/2019
2.1.179-beta6 557 12/21/2018
2.1.179-beta5 485 12/19/2018
2.1.179-beta4 512 12/19/2018
2.1.179-beta3 484 12/19/2018
2.1.179-beta2 517 12/18/2018
2.1.179-beta12 548 1/8/2019
2.1.179-beta11 547 1/7/2019
2.1.179-beta10 524 1/4/2019
2.1.179-beta1 527 12/18/2018
2.1.179-alpha9 472 12/18/2018
2.1.179-alpha8 542 11/28/2018
2.1.179-alpha7 545 11/22/2018
2.1.179-alpha6 548 11/20/2018
2.1.179-alpha5 529 11/20/2018
2.1.179-alpha4 558 11/20/2018
2.1.179-alpha3 583 11/19/2018
2.1.179-alpha2 591 11/16/2018
2.1.179-alpha 567 11/16/2018
2.1.178 764 11/6/2018
2.1.178-beta2 538 11/6/2018
2.1.178-beta1 590 10/29/2018
2.1.178-alpha7 597 10/22/2018
2.1.178-alpha6 610 10/19/2018
2.1.178-alpha5 589 10/17/2018
2.1.178-alpha4 604 10/14/2018
2.1.178-alpha3 569 10/13/2018
2.1.178-alpha2 570 10/9/2018
2.1.178-alpha 599 10/9/2018
2.1.177 764 9/27/2018
2.1.177-rc4 577 9/26/2018
2.1.177-rc3 575 9/26/2018
2.1.177-rc2 577 9/26/2018
2.1.177-rc1 564 9/25/2018
2.1.177-beta 558 9/25/2018
2.1.177-alpha 560 9/24/2018
2.1.176 755 9/20/2018
2.1.175 770 9/19/2018
2.1.174 770 9/16/2018
2.1.173 769 9/12/2018
2.1.173-beta 616 9/12/2018
2.1.172 763 9/11/2018
2.1.171 776 8/27/2018
2.1.171-rc1 605 8/27/2018
2.1.171-beta 592 8/27/2018
2.1.170 826 8/15/2018
2.1.169 811 8/14/2018
2.1.168 838 8/10/2018
2.1.167 864 8/9/2018
2.1.166 894 8/9/2018
2.1.165 903 8/9/2018
2.1.164 893 8/8/2018
2.1.163 832 8/8/2018
2.1.162 874 8/8/2018
2.1.161 881 8/8/2018
2.1.160 868 8/7/2018
2.1.159 864 8/3/2018
2.1.158 856 8/2/2018
2.1.157 856 8/1/2018
2.1.156 838 7/30/2018
2.1.155 873 7/29/2018
2.1.154 871 7/19/2018
2.1.153 974 7/12/2018
2.1.152 855 7/11/2018
2.1.151 926 7/11/2018
2.1.150 992 7/11/2018
2.1.149 1,015 7/10/2018
2.1.148 975 7/4/2018
2.1.147 929 7/3/2018
2.1.146 974 7/1/2018
2.1.145 892 7/1/2018
2.1.144 861 6/28/2018
2.1.143 884 6/25/2018
2.1.142 941 6/19/2018
2.1.141 957 6/19/2018
2.1.140 948 6/18/2018
2.0.149 1,064 7/10/2018
2.0.148 887 7/4/2018
2.0.147 878 7/3/2018
2.0.146 936 7/1/2018
2.0.145 992 7/1/2018
2.0.144 871 6/28/2018
2.0.143 1,031 6/25/2018
2.0.142 915 6/19/2018
2.0.141 863 6/19/2018
2.0.140 953 6/18/2018
2.0.139 840 6/18/2018
2.0.138 891 6/15/2018
2.0.137 888 6/15/2018
2.0.136 925 6/12/2018
2.0.135 956 6/11/2018
2.0.134 960 6/11/2018
2.0.133 951 6/11/2018
0.2.132 902 5/25/2018
0.2.131 847 5/21/2018
0.2.130 916 5/20/2018
0.2.129 973 5/20/2018
0.2.128 993 5/14/2018
0.2.127 883 5/11/2018
0.2.126 972 5/10/2018
0.2.125 969 5/8/2018
0.2.124 909 4/30/2018
0.2.123 975 4/29/2018
0.2.122 1,100 4/27/2018
0.2.121 979 4/26/2018
0.2.120 865 4/25/2018
0.2.119 970 4/25/2018
0.2.118 1,004 4/25/2018
0.2.117 1,003 4/24/2018
0.2.116 836 4/24/2018
0.2.115 948 4/19/2018
0.2.114 856 4/19/2018
0.2.113 967 4/19/2018
0.2.112 941 4/18/2018
0.2.111 836 4/18/2018
0.2.110 915 4/18/2018
0.2.109 822 4/17/2018
0.2.108 920 4/17/2018
0.2.107 936 4/9/2018
0.2.106 1,099 4/6/2018
0.2.105 985 4/3/2018
0.2.104 996 4/2/2018
0.2.103 919 3/28/2018
0.2.102 1,031 3/28/2018
0.2.101 953 3/28/2018
0.2.100 975 3/27/2018
0.2.99 1,135 3/24/2018
0.2.98 1,103 3/23/2018
0.2.97 962 3/19/2018
0.2.96 838 3/16/2018
0.2.95 950 3/15/2018
0.2.94 993 3/13/2018
0.2.93 997 3/12/2018
0.2.92 979 3/12/2018
0.2.91 960 3/12/2018
0.2.90 959 3/11/2018
0.2.89 869 3/6/2018
0.2.88 999 3/2/2018
0.2.87 950 3/1/2018
0.2.86 968 2/28/2018
0.2.85 944 2/28/2018
0.2.84 966 2/28/2018
0.2.83 948 2/27/2018
0.2.82 952 2/26/2018
0.2.81 970 2/23/2018
0.2.80 945 2/22/2018
0.2.79 945 2/21/2018
0.2.78 954 2/16/2018
0.2.77 955 2/14/2018
0.2.76 947 2/14/2018
0.2.75 939 2/9/2018
0.2.74 955 2/9/2018
0.2.73 986 2/1/2018
0.2.72 1,007 1/31/2018
0.2.71 985 1/30/2018
0.2.70 895 1/29/2018
0.2.69 913 1/26/2018
0.2.68 954 1/23/2018
0.2.67 897 1/22/2018
0.2.66 967 1/22/2018
0.2.65 993 1/19/2018
0.2.64 993 1/17/2018
0.2.63 871 1/16/2018
0.2.62 874 1/15/2018
0.2.61 889 12/18/2017
0.2.60 938 12/6/2017
0.2.59 909 12/5/2017
0.2.58 865 12/4/2017
0.2.57 867 12/1/2017
0.2.56 909 11/30/2017
0.2.55 879 11/28/2017
0.2.54 884 11/28/2017
0.2.53 925 11/28/2017
0.2.52 869 11/26/2017
0.2.51 863 11/24/2017
0.2.50 874 11/23/2017
0.2.49 906 11/17/2017
0.2.48 901 11/17/2017
0.2.47 901 11/16/2017
0.2.46 909 11/15/2017
0.2.45 903 11/13/2017
0.2.44 869 11/7/2017
0.2.43 902 11/7/2017
0.2.42 905 11/6/2017
0.2.41 894 10/31/2017
0.2.40 878 10/31/2017
0.2.39 887 10/26/2017
0.2.38 879 10/26/2017
0.2.37 892 10/25/2017
0.2.36 879 10/23/2017
0.2.35 892 10/20/2017
0.2.34 870 10/13/2017
0.2.33 911 10/10/2017
0.2.32 871 10/9/2017
0.2.31 866 10/7/2017
0.2.30 853 10/6/2017
0.2.29 866 9/29/2017
0.2.28 889 9/27/2017
0.2.27 879 9/25/2017
0.2.26 916 9/22/2017
0.2.25 905 9/20/2017
0.2.24 896 9/19/2017
0.2.23 895 9/13/2017
0.2.22 870 9/13/2017
0.2.21 862 9/13/2017
0.2.20 885 9/13/2017
0.2.19 867 9/12/2017
0.2.18 873 9/12/2017
0.2.17 872 9/11/2017
0.2.16 892 9/11/2017
0.2.15 872 9/8/2017
0.2.10 906 9/8/2017
0.2.9 944 8/29/2017
0.2.6 895 8/25/2017
0.2.5 917 8/16/2017
0.2.1-alpha 717 8/16/2017