TWCore.Data.MySql 3.1.0

.NET 5.0 .NET Core 2.1 .NET Standard 2.0 .NET Framework 4.7.2 
dotnet add package TWCore.Data.MySql --version 3.1.0
NuGet\Install-Package TWCore.Data.MySql -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.MySql" 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.MySql --version 3.1.0
#r "nuget: TWCore.Data.MySql, 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.MySql as a Cake Addin
#addin nuget:?package=TWCore.Data.MySql&version=3.1.0

// Install TWCore.Data.MySql as a Cake Tool
#tool nuget:?package=TWCore.Data.MySql&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 191 10/22/2023
3.1.0-beta2 93 10/20/2023
3.1.0-beta1 82 10/19/2023
3.0.0-beta5 450 9/8/2019
3.0.0-beta4 390 9/8/2019
3.0.0-beta3 402 8/20/2019
3.0.0-beta2 392 8/18/2019
3.0.0-beta1 392 8/18/2019
2.1.181 745 7/24/2019
2.1.181-beta5 411 7/16/2019
2.1.181-beta4 426 5/10/2019
2.1.181-beta3 438 3/16/2019
2.1.181-beta2 462 3/8/2019
2.1.181-beta 441 3/3/2019
2.1.180 645 3/1/2019
2.1.180-rc1 452 2/28/2019
2.1.180-beta9 497 2/14/2019
2.1.180-beta8 512 2/14/2019
2.1.180-beta7 511 2/8/2019
2.1.180-beta6 502 2/7/2019
2.1.180-beta5 531 2/6/2019
2.1.180-beta4 509 2/5/2019
2.1.180-beta3 506 2/4/2019
2.1.180-beta2 508 2/4/2019
2.1.180-beta1 507 2/4/2019
2.1.180-alpha8 507 1/30/2019
2.1.180-alpha7 506 1/22/2019
2.1.180-alpha6 492 1/21/2019
2.1.180-alpha5 563 1/18/2019
2.1.180-alpha4 555 1/17/2019
2.1.180-alpha3 550 1/16/2019
2.1.180-alpha2 510 1/16/2019
2.1.180-alpha1 536 1/15/2019
2.1.179 699 1/9/2019
2.1.179-beta9 516 1/3/2019
2.1.179-beta8 527 1/2/2019
2.1.179-beta7 558 1/2/2019
2.1.179-beta6 491 12/21/2018
2.1.179-beta5 488 12/19/2018
2.1.179-beta4 473 12/19/2018
2.1.179-beta3 474 12/19/2018
2.1.179-beta2 505 12/18/2018
2.1.179-beta12 503 1/8/2019
2.1.179-beta11 523 1/7/2019
2.1.179-beta10 514 1/4/2019
2.1.179-beta1 516 12/18/2018
2.1.179-alpha9 470 12/18/2018
2.1.179-alpha8 537 11/28/2018
2.1.179-alpha7 531 11/22/2018
2.1.179-alpha6 538 11/20/2018
2.1.179-alpha5 546 11/20/2018
2.1.179-alpha4 530 11/20/2018
2.1.179-alpha3 553 11/19/2018
2.1.179-alpha2 550 11/16/2018
2.1.179-alpha 551 11/16/2018
2.1.178 757 11/6/2018
2.1.178-beta2 531 11/6/2018
2.1.178-beta1 560 10/29/2018
2.1.178-alpha7 566 10/22/2018
2.1.178-alpha6 553 10/19/2018
2.1.178-alpha5 546 10/17/2018
2.1.178-alpha4 652 10/14/2018
2.1.178-alpha3 568 10/13/2018
2.1.178-alpha2 577 10/9/2018
2.1.178-alpha 590 10/9/2018
2.1.177 766 9/27/2018
2.1.177-rc4 554 9/26/2018
2.1.177-rc3 565 9/26/2018
2.1.177-rc2 565 9/26/2018
2.1.177-rc1 559 9/25/2018
2.1.177-beta 569 9/25/2018
2.1.177-alpha 559 9/24/2018
2.1.176 759 9/20/2018
2.1.175 771 9/19/2018
2.1.174 775 9/16/2018
2.1.173 791 9/12/2018
2.1.173-beta 580 9/12/2018
2.1.172 784 9/11/2018
2.1.171 751 8/27/2018
2.1.171-rc1 578 8/27/2018
2.1.171-beta 588 8/27/2018
2.1.170 859 8/15/2018
2.1.169 855 8/14/2018
2.1.168 891 8/10/2018
2.1.167 931 8/9/2018
2.1.166 902 8/9/2018
2.1.165 919 8/9/2018
2.1.164 935 8/8/2018
2.1.163 895 8/8/2018
2.1.162 930 8/8/2018
2.1.161 901 8/8/2018
2.1.160 939 8/7/2018
2.1.159 892 8/3/2018
2.1.158 880 8/2/2018
2.1.157 867 8/1/2018
2.1.156 888 7/30/2018
2.1.155 868 7/29/2018
2.1.154 860 7/19/2018
2.1.153 991 7/12/2018
2.1.152 908 7/11/2018
2.1.151 1,002 7/11/2018
2.1.150 925 7/11/2018
2.1.149 928 7/10/2018
2.1.148 910 7/4/2018
2.1.147 890 7/3/2018
2.1.146 944 7/1/2018
2.1.145 858 7/1/2018
2.1.144 892 6/28/2018
2.1.143 1,019 6/25/2018
2.1.142 1,018 6/19/2018
2.1.141 1,023 6/19/2018
2.1.140 965 6/18/2018
2.0.149 978 7/10/2018
2.0.148 927 7/4/2018
2.0.147 919 7/3/2018
2.0.146 965 7/1/2018
2.0.145 1,001 7/1/2018
2.0.144 879 6/28/2018
2.0.143 1,048 6/25/2018
2.0.142 959 6/19/2018
2.0.141 1,005 6/19/2018
2.0.140 875 6/18/2018
2.0.139 1,007 6/18/2018
2.0.138 1,000 6/15/2018
2.0.137 983 6/15/2018
2.0.136 970 6/12/2018
2.0.135 978 6/11/2018
2.0.134 1,005 6/11/2018
2.0.133 909 6/11/2018
0.2.132 1,031 5/25/2018
0.2.131 974 5/21/2018
0.2.130 888 5/20/2018
0.2.129 893 5/20/2018
0.2.128 964 5/14/2018
0.2.127 973 5/11/2018
0.2.126 1,004 5/10/2018
0.2.125 998 5/8/2018
0.2.124 1,042 4/30/2018
0.2.123 1,042 4/29/2018
0.2.122 1,160 4/27/2018
0.2.121 937 4/26/2018
0.2.120 1,005 4/25/2018
0.2.119 961 4/25/2018
0.2.118 985 4/25/2018
0.2.117 1,018 4/24/2018
0.2.116 913 4/24/2018
0.2.115 994 4/19/2018
0.2.114 973 4/19/2018
0.2.113 986 4/19/2018
0.2.112 985 4/18/2018
0.2.111 875 4/18/2018
0.2.110 1,043 4/18/2018
0.2.109 947 4/17/2018
0.2.108 961 4/17/2018
0.2.107 1,031 4/9/2018
0.2.106 1,204 4/6/2018
0.2.105 989 4/3/2018
0.2.104 992 4/2/2018
0.2.103 1,072 3/28/2018
0.2.102 1,027 3/28/2018
0.2.101 1,003 3/28/2018
0.2.100 1,056 3/27/2018
0.2.99 1,123 3/24/2018
0.2.98 1,150 3/23/2018
0.2.97 1,042 3/19/2018
0.2.96 1,044 3/16/2018
0.2.95 1,033 3/15/2018
0.2.94 1,006 3/13/2018
0.2.93 1,025 3/12/2018
0.2.92 1,037 3/12/2018
0.2.91 1,012 3/12/2018
0.2.90 1,043 3/11/2018
0.2.89 1,062 3/6/2018
0.2.88 1,104 3/2/2018
0.2.87 921 3/1/2018
0.2.86 976 2/28/2018
0.2.85 978 2/28/2018
0.2.84 915 2/28/2018
0.2.83 921 2/27/2018
0.2.82 1,000 2/26/2018
0.2.81 965 2/23/2018
0.2.80 1,017 2/22/2018
0.2.79 1,001 2/21/2018
0.2.78 1,010 2/16/2018
0.2.77 1,125 2/14/2018
0.2.76 1,003 2/14/2018
0.2.75 964 2/9/2018
0.2.74 1,019 2/9/2018
0.2.73 1,033 2/1/2018
0.2.72 954 1/31/2018
0.2.71 1,060 1/30/2018
0.2.70 926 1/29/2018
0.2.69 1,055 1/26/2018
0.2.68 995 1/23/2018
0.2.67 999 1/22/2018
0.2.66 1,012 1/22/2018
0.2.65 1,021 1/19/2018
0.2.64 1,010 1/17/2018
0.2.63 1,047 1/16/2018
0.2.62 1,016 1/15/2018
0.2.61 976 12/18/2017
0.2.60 1,097 12/6/2017
0.2.59 964 12/5/2017
0.2.58 1,022 12/4/2017
0.2.57 961 12/1/2017
0.2.56 1,015 11/30/2017
0.2.55 1,004 11/28/2017
0.2.54 995 11/28/2017
0.2.53 926 11/28/2017
0.2.52 1,039 11/26/2017
0.2.51 1,056 11/24/2017
0.2.50 1,019 11/23/2017
0.2.49 1,021 11/17/2017
0.2.48 936 11/17/2017
0.2.47 961 11/16/2017
0.2.46 957 11/15/2017
0.2.45 918 11/13/2017
0.2.44 991 11/7/2017
0.2.43 951 11/7/2017
0.2.42 973 11/6/2017
0.2.41 984 10/31/2017
0.2.40 946 10/31/2017
0.2.39 965 10/26/2017
0.2.38 992 10/26/2017
0.2.37 934 10/25/2017
0.2.36 975 10/23/2017
0.2.35 955 10/20/2017
0.2.34 1,048 10/13/2017
0.2.33 988 10/10/2017
0.2.32 938 10/9/2017
0.2.31 954 10/7/2017
0.2.30 932 10/6/2017
0.2.29 935 9/29/2017
0.2.28 960 9/27/2017
0.2.27 948 9/25/2017
0.2.26 963 9/22/2017
0.2.25 1,017 9/20/2017
0.2.24 987 9/19/2017
0.2.23 1,006 9/13/2017
0.2.22 970 9/13/2017
0.2.21 909 9/13/2017
0.2.20 994 9/13/2017
0.2.19 983 9/12/2017
0.2.18 943 9/12/2017
0.2.17 949 9/11/2017
0.2.16 1,007 9/11/2017
0.2.15 1,015 9/8/2017
0.2.10 1,061 9/8/2017
0.2.9 962 8/29/2017
0.2.6 959 8/25/2017
0.2.5 953 8/16/2017
0.2.1-alpha 735 8/16/2017