TWCore.Data.SqlServer 3.1.0-beta1

.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-beta1                

                    
                

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

                    
                

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

// Install TWCore.Data.SqlServer as a Cake Tool
#tool nuget:?package=TWCore.Data.SqlServer&version=3.1.0-beta1&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 287 10/22/2023
3.1.0-beta2 106 10/20/2023
3.1.0-beta1 93 10/19/2023
3.0.0-beta5 361 9/8/2019
3.0.0-beta4 323 9/8/2019
3.0.0-beta3 326 8/20/2019
3.0.0-beta2 315 8/18/2019
3.0.0-beta1 313 8/18/2019
2.1.181 743 7/24/2019
2.1.181-beta5 458 7/16/2019
2.1.181-beta4 461 5/10/2019
2.1.181-beta3 483 3/16/2019
2.1.181-beta2 469 3/8/2019
2.1.181-beta 474 3/3/2019
2.1.180 629 3/1/2019
2.1.180-rc1 496 2/28/2019
2.1.180-beta9 541 2/14/2019
2.1.180-beta8 503 2/14/2019
2.1.180-beta7 536 2/8/2019
2.1.180-beta6 540 2/7/2019
2.1.180-beta5 530 2/6/2019
2.1.180-beta4 551 2/5/2019
2.1.180-beta3 514 2/4/2019
2.1.180-beta2 506 2/4/2019
2.1.180-beta1 530 2/4/2019
2.1.180-alpha8 529 1/30/2019
2.1.180-alpha7 550 1/22/2019
2.1.180-alpha6 538 1/21/2019
2.1.180-alpha5 556 1/18/2019
2.1.180-alpha4 580 1/17/2019
2.1.180-alpha3 567 1/16/2019
2.1.180-alpha2 520 1/16/2019
2.1.180-alpha1 538 1/15/2019
2.1.179 716 1/9/2019
2.1.179-beta9 516 1/3/2019
2.1.179-beta8 525 1/2/2019
2.1.179-beta7 578 1/2/2019
2.1.179-beta6 560 12/21/2018
2.1.179-beta5 488 12/19/2018
2.1.179-beta4 515 12/19/2018
2.1.179-beta3 487 12/19/2018
2.1.179-beta2 520 12/18/2018
2.1.179-beta12 551 1/8/2019
2.1.179-beta11 550 1/7/2019
2.1.179-beta10 526 1/4/2019
2.1.179-beta1 530 12/18/2018
2.1.179-alpha9 475 12/18/2018
2.1.179-alpha8 549 11/28/2018
2.1.179-alpha7 551 11/22/2018
2.1.179-alpha6 555 11/20/2018
2.1.179-alpha5 536 11/20/2018
2.1.179-alpha4 565 11/20/2018
2.1.179-alpha3 589 11/19/2018
2.1.179-alpha2 600 11/16/2018
2.1.179-alpha 574 11/16/2018
2.1.178 774 11/6/2018
2.1.178-beta2 545 11/6/2018
2.1.178-beta1 598 10/29/2018
2.1.178-alpha7 606 10/22/2018
2.1.178-alpha6 617 10/19/2018
2.1.178-alpha5 596 10/17/2018
2.1.178-alpha4 610 10/14/2018
2.1.178-alpha3 576 10/13/2018
2.1.178-alpha2 579 10/9/2018
2.1.178-alpha 607 10/9/2018
2.1.177 778 9/27/2018
2.1.177-rc4 586 9/26/2018
2.1.177-rc3 584 9/26/2018
2.1.177-rc2 587 9/26/2018
2.1.177-rc1 572 9/25/2018
2.1.177-beta 567 9/25/2018
2.1.177-alpha 567 9/24/2018
2.1.176 767 9/20/2018
2.1.175 783 9/19/2018
2.1.174 783 9/16/2018
2.1.173 782 9/12/2018
2.1.173-beta 626 9/12/2018
2.1.172 775 9/11/2018
2.1.171 787 8/27/2018
2.1.171-rc1 614 8/27/2018
2.1.171-beta 600 8/27/2018
2.1.170 838 8/15/2018
2.1.169 824 8/14/2018
2.1.168 851 8/10/2018
2.1.167 877 8/9/2018
2.1.166 905 8/9/2018
2.1.165 916 8/9/2018
2.1.164 904 8/8/2018
2.1.163 845 8/8/2018
2.1.162 887 8/8/2018
2.1.161 894 8/8/2018
2.1.160 881 8/7/2018
2.1.159 875 8/3/2018
2.1.158 867 8/2/2018
2.1.157 869 8/1/2018
2.1.156 851 7/30/2018
2.1.155 886 7/29/2018
2.1.154 884 7/19/2018
2.1.153 985 7/12/2018
2.1.152 868 7/11/2018
2.1.151 943 7/11/2018
2.1.150 1,003 7/11/2018
2.1.149 1,028 7/10/2018
2.1.148 988 7/4/2018
2.1.147 943 7/3/2018
2.1.146 985 7/1/2018
2.1.145 905 7/1/2018
2.1.144 872 6/28/2018
2.1.143 895 6/25/2018
2.1.142 954 6/19/2018
2.1.141 968 6/19/2018
2.1.140 961 6/18/2018
2.0.149 1,075 7/10/2018
2.0.148 898 7/4/2018
2.0.147 889 7/3/2018
2.0.146 947 7/1/2018
2.0.145 1,003 7/1/2018
2.0.144 884 6/28/2018
2.0.143 1,044 6/25/2018
2.0.142 928 6/19/2018
2.0.141 874 6/19/2018
2.0.140 964 6/18/2018
2.0.139 853 6/18/2018
2.0.138 902 6/15/2018
2.0.137 899 6/15/2018
2.0.136 938 6/12/2018
2.0.135 969 6/11/2018
2.0.134 971 6/11/2018
2.0.133 962 6/11/2018
0.2.132 915 5/25/2018
0.2.131 858 5/21/2018
0.2.130 927 5/20/2018
0.2.129 986 5/20/2018
0.2.128 1,006 5/14/2018
0.2.127 896 5/11/2018
0.2.126 983 5/10/2018
0.2.125 982 5/8/2018
0.2.124 922 4/30/2018
0.2.123 986 4/29/2018
0.2.122 1,111 4/27/2018
0.2.121 992 4/26/2018
0.2.120 878 4/25/2018
0.2.119 981 4/25/2018
0.2.118 1,015 4/25/2018
0.2.117 1,014 4/24/2018
0.2.116 851 4/24/2018
0.2.115 959 4/19/2018
0.2.114 867 4/19/2018
0.2.113 978 4/19/2018
0.2.112 952 4/18/2018
0.2.111 849 4/18/2018
0.2.110 928 4/18/2018
0.2.109 833 4/17/2018
0.2.108 933 4/17/2018
0.2.107 949 4/9/2018
0.2.106 1,110 4/6/2018
0.2.105 1,000 4/3/2018
0.2.104 1,009 4/2/2018
0.2.103 930 3/28/2018
0.2.102 1,044 3/28/2018
0.2.101 966 3/28/2018
0.2.100 988 3/27/2018
0.2.99 1,146 3/24/2018
0.2.98 1,114 3/23/2018
0.2.97 973 3/19/2018
0.2.96 849 3/16/2018
0.2.95 963 3/15/2018
0.2.94 1,004 3/13/2018
0.2.93 1,008 3/12/2018
0.2.92 990 3/12/2018
0.2.91 973 3/12/2018
0.2.90 970 3/11/2018
0.2.89 882 3/6/2018
0.2.88 1,010 3/2/2018
0.2.87 963 3/1/2018
0.2.86 981 2/28/2018
0.2.85 957 2/28/2018
0.2.84 977 2/28/2018
0.2.83 959 2/27/2018
0.2.82 965 2/26/2018
0.2.81 983 2/23/2018
0.2.80 956 2/22/2018
0.2.79 956 2/21/2018
0.2.78 965 2/16/2018
0.2.77 966 2/14/2018
0.2.76 958 2/14/2018
0.2.75 950 2/9/2018
0.2.74 966 2/9/2018
0.2.73 997 2/1/2018
0.2.72 1,020 1/31/2018
0.2.71 998 1/30/2018
0.2.70 906 1/29/2018
0.2.69 924 1/26/2018
0.2.68 967 1/23/2018
0.2.67 908 1/22/2018
0.2.66 978 1/22/2018
0.2.65 1,007 1/19/2018
0.2.64 1,006 1/17/2018
0.2.63 884 1/16/2018
0.2.62 885 1/15/2018
0.2.61 902 12/18/2017
0.2.60 949 12/6/2017
0.2.59 922 12/5/2017
0.2.58 878 12/4/2017
0.2.57 878 12/1/2017
0.2.56 920 11/30/2017
0.2.55 890 11/28/2017
0.2.54 895 11/28/2017
0.2.53 936 11/28/2017
0.2.52 880 11/26/2017
0.2.51 874 11/24/2017
0.2.50 885 11/23/2017
0.2.49 917 11/17/2017
0.2.48 912 11/17/2017
0.2.47 912 11/16/2017
0.2.46 920 11/15/2017
0.2.45 914 11/13/2017
0.2.44 880 11/7/2017
0.2.43 913 11/7/2017
0.2.42 916 11/6/2017
0.2.41 905 10/31/2017
0.2.40 889 10/31/2017
0.2.39 898 10/26/2017
0.2.38 890 10/26/2017
0.2.37 903 10/25/2017
0.2.36 890 10/23/2017
0.2.35 903 10/20/2017
0.2.34 881 10/13/2017
0.2.33 922 10/10/2017
0.2.32 882 10/9/2017
0.2.31 877 10/7/2017
0.2.30 864 10/6/2017
0.2.29 877 9/29/2017
0.2.28 900 9/27/2017
0.2.27 890 9/25/2017
0.2.26 927 9/22/2017
0.2.25 916 9/20/2017
0.2.24 907 9/19/2017
0.2.23 906 9/13/2017
0.2.22 881 9/13/2017
0.2.21 873 9/13/2017
0.2.20 896 9/13/2017
0.2.19 878 9/12/2017
0.2.18 884 9/12/2017
0.2.17 883 9/11/2017
0.2.16 903 9/11/2017
0.2.15 883 9/8/2017
0.2.10 917 9/8/2017
0.2.9 955 8/29/2017
0.2.6 906 8/25/2017
0.2.5 928 8/16/2017
0.2.1-alpha 724 8/16/2017