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 276 10/22/2023
3.1.0-beta2 98 10/20/2023
3.1.0-beta1 89 10/19/2023
3.0.0-beta5 356 9/8/2019
3.0.0-beta4 318 9/8/2019
3.0.0-beta3 320 8/20/2019
3.0.0-beta2 309 8/18/2019
3.0.0-beta1 307 8/18/2019
2.1.181 733 7/24/2019
2.1.181-beta5 451 7/16/2019
2.1.181-beta4 456 5/10/2019
2.1.181-beta3 478 3/16/2019
2.1.181-beta2 464 3/8/2019
2.1.181-beta 469 3/3/2019
2.1.180 620 3/1/2019
2.1.180-rc1 489 2/28/2019
2.1.180-beta9 535 2/14/2019
2.1.180-beta8 498 2/14/2019
2.1.180-beta7 529 2/8/2019
2.1.180-beta6 535 2/7/2019
2.1.180-beta5 525 2/6/2019
2.1.180-beta4 546 2/5/2019
2.1.180-beta3 505 2/4/2019
2.1.180-beta2 500 2/4/2019
2.1.180-beta1 524 2/4/2019
2.1.180-alpha8 524 1/30/2019
2.1.180-alpha7 545 1/22/2019
2.1.180-alpha6 533 1/21/2019
2.1.180-alpha5 550 1/18/2019
2.1.180-alpha4 575 1/17/2019
2.1.180-alpha3 560 1/16/2019
2.1.180-alpha2 515 1/16/2019
2.1.180-alpha1 533 1/15/2019
2.1.179 707 1/9/2019
2.1.179-beta9 511 1/3/2019
2.1.179-beta8 520 1/2/2019
2.1.179-beta7 572 1/2/2019
2.1.179-beta6 555 12/21/2018
2.1.179-beta5 483 12/19/2018
2.1.179-beta4 510 12/19/2018
2.1.179-beta3 482 12/19/2018
2.1.179-beta2 515 12/18/2018
2.1.179-beta12 546 1/8/2019
2.1.179-beta11 545 1/7/2019
2.1.179-beta10 520 1/4/2019
2.1.179-beta1 525 12/18/2018
2.1.179-alpha9 470 12/18/2018
2.1.179-alpha8 540 11/28/2018
2.1.179-alpha7 543 11/22/2018
2.1.179-alpha6 544 11/20/2018
2.1.179-alpha5 527 11/20/2018
2.1.179-alpha4 556 11/20/2018
2.1.179-alpha3 581 11/19/2018
2.1.179-alpha2 589 11/16/2018
2.1.179-alpha 565 11/16/2018
2.1.178 762 11/6/2018
2.1.178-beta2 536 11/6/2018
2.1.178-beta1 588 10/29/2018
2.1.178-alpha7 595 10/22/2018
2.1.178-alpha6 608 10/19/2018
2.1.178-alpha5 587 10/17/2018
2.1.178-alpha4 602 10/14/2018
2.1.178-alpha3 567 10/13/2018
2.1.178-alpha2 568 10/9/2018
2.1.178-alpha 597 10/9/2018
2.1.177 761 9/27/2018
2.1.177-rc4 575 9/26/2018
2.1.177-rc3 573 9/26/2018
2.1.177-rc2 575 9/26/2018
2.1.177-rc1 561 9/25/2018
2.1.177-beta 556 9/25/2018
2.1.177-alpha 558 9/24/2018
2.1.176 753 9/20/2018
2.1.175 768 9/19/2018
2.1.174 768 9/16/2018
2.1.173 767 9/12/2018
2.1.173-beta 614 9/12/2018
2.1.172 761 9/11/2018
2.1.171 774 8/27/2018
2.1.171-rc1 603 8/27/2018
2.1.171-beta 590 8/27/2018
2.1.170 824 8/15/2018
2.1.169 809 8/14/2018
2.1.168 835 8/10/2018
2.1.167 862 8/9/2018
2.1.166 892 8/9/2018
2.1.165 901 8/9/2018
2.1.164 891 8/8/2018
2.1.163 830 8/8/2018
2.1.162 872 8/8/2018
2.1.161 879 8/8/2018
2.1.160 866 8/7/2018
2.1.159 862 8/3/2018
2.1.158 854 8/2/2018
2.1.157 854 8/1/2018
2.1.156 836 7/30/2018
2.1.155 871 7/29/2018
2.1.154 869 7/19/2018
2.1.153 972 7/12/2018
2.1.152 853 7/11/2018
2.1.151 923 7/11/2018
2.1.150 990 7/11/2018
2.1.149 1,013 7/10/2018
2.1.148 973 7/4/2018
2.1.147 927 7/3/2018
2.1.146 972 7/1/2018
2.1.145 890 7/1/2018
2.1.144 859 6/28/2018
2.1.143 882 6/25/2018
2.1.142 939 6/19/2018
2.1.141 955 6/19/2018
2.1.140 946 6/18/2018
2.0.149 1,062 7/10/2018
2.0.148 885 7/4/2018
2.0.147 876 7/3/2018
2.0.146 934 7/1/2018
2.0.145 990 7/1/2018
2.0.144 869 6/28/2018
2.0.143 1,029 6/25/2018
2.0.142 913 6/19/2018
2.0.141 861 6/19/2018
2.0.140 951 6/18/2018
2.0.139 838 6/18/2018
2.0.138 889 6/15/2018
2.0.137 886 6/15/2018
2.0.136 923 6/12/2018
2.0.135 954 6/11/2018
2.0.134 958 6/11/2018
2.0.133 949 6/11/2018
0.2.132 900 5/25/2018
0.2.131 845 5/21/2018
0.2.130 914 5/20/2018
0.2.129 971 5/20/2018
0.2.128 991 5/14/2018
0.2.127 881 5/11/2018
0.2.126 970 5/10/2018
0.2.125 967 5/8/2018
0.2.124 907 4/30/2018
0.2.123 973 4/29/2018
0.2.122 1,098 4/27/2018
0.2.121 977 4/26/2018
0.2.120 863 4/25/2018
0.2.119 968 4/25/2018
0.2.118 1,002 4/25/2018
0.2.117 1,001 4/24/2018
0.2.116 834 4/24/2018
0.2.115 946 4/19/2018
0.2.114 854 4/19/2018
0.2.113 965 4/19/2018
0.2.112 939 4/18/2018
0.2.111 834 4/18/2018
0.2.110 913 4/18/2018
0.2.109 820 4/17/2018
0.2.108 918 4/17/2018
0.2.107 934 4/9/2018
0.2.106 1,097 4/6/2018
0.2.105 983 4/3/2018
0.2.104 994 4/2/2018
0.2.103 917 3/28/2018
0.2.102 1,029 3/28/2018
0.2.101 951 3/28/2018
0.2.100 973 3/27/2018
0.2.99 1,133 3/24/2018
0.2.98 1,101 3/23/2018
0.2.97 960 3/19/2018
0.2.96 836 3/16/2018
0.2.95 948 3/15/2018
0.2.94 991 3/13/2018
0.2.93 995 3/12/2018
0.2.92 977 3/12/2018
0.2.91 958 3/12/2018
0.2.90 957 3/11/2018
0.2.89 867 3/6/2018
0.2.88 997 3/2/2018
0.2.87 948 3/1/2018
0.2.86 966 2/28/2018
0.2.85 942 2/28/2018
0.2.84 964 2/28/2018
0.2.83 946 2/27/2018
0.2.82 950 2/26/2018
0.2.81 968 2/23/2018
0.2.80 943 2/22/2018
0.2.79 943 2/21/2018
0.2.78 952 2/16/2018
0.2.77 953 2/14/2018
0.2.76 945 2/14/2018
0.2.75 937 2/9/2018
0.2.74 953 2/9/2018
0.2.73 984 2/1/2018
0.2.72 1,005 1/31/2018
0.2.71 983 1/30/2018
0.2.70 893 1/29/2018
0.2.69 911 1/26/2018
0.2.68 952 1/23/2018
0.2.67 895 1/22/2018
0.2.66 965 1/22/2018
0.2.65 991 1/19/2018
0.2.64 991 1/17/2018
0.2.63 869 1/16/2018
0.2.62 872 1/15/2018
0.2.61 887 12/18/2017
0.2.60 936 12/6/2017
0.2.59 907 12/5/2017
0.2.58 863 12/4/2017
0.2.57 865 12/1/2017
0.2.56 907 11/30/2017
0.2.55 877 11/28/2017
0.2.54 882 11/28/2017
0.2.53 923 11/28/2017
0.2.52 867 11/26/2017
0.2.51 861 11/24/2017
0.2.50 872 11/23/2017
0.2.49 904 11/17/2017
0.2.48 899 11/17/2017
0.2.47 899 11/16/2017
0.2.46 907 11/15/2017
0.2.45 901 11/13/2017
0.2.44 867 11/7/2017
0.2.43 900 11/7/2017
0.2.42 903 11/6/2017
0.2.41 892 10/31/2017
0.2.40 876 10/31/2017
0.2.39 885 10/26/2017
0.2.38 877 10/26/2017
0.2.37 890 10/25/2017
0.2.36 877 10/23/2017
0.2.35 890 10/20/2017
0.2.34 868 10/13/2017
0.2.33 909 10/10/2017
0.2.32 869 10/9/2017
0.2.31 864 10/7/2017
0.2.30 851 10/6/2017
0.2.29 864 9/29/2017
0.2.28 887 9/27/2017
0.2.27 877 9/25/2017
0.2.26 914 9/22/2017
0.2.25 903 9/20/2017
0.2.24 894 9/19/2017
0.2.23 893 9/13/2017
0.2.22 868 9/13/2017
0.2.21 860 9/13/2017
0.2.20 883 9/13/2017
0.2.19 865 9/12/2017
0.2.18 871 9/12/2017
0.2.17 870 9/11/2017
0.2.16 890 9/11/2017
0.2.15 870 9/8/2017
0.2.10 904 9/8/2017
0.2.9 942 8/29/2017
0.2.6 893 8/25/2017
0.2.5 915 8/16/2017
0.2.1-alpha 715 8/16/2017