TWCore.Data.SQLite 3.1.0

dotnet add package TWCore.Data.SQLite --version 3.1.0
NuGet\Install-Package TWCore.Data.SQLite -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.SQLite" 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.SQLite --version 3.1.0
#r "nuget: TWCore.Data.SQLite, 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.SQLite as a Cake Addin
#addin nuget:?package=TWCore.Data.SQLite&version=3.1.0

// Install TWCore.Data.SQLite as a Cake Tool
#tool nuget:?package=TWCore.Data.SQLite&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 194 10/22/2023
3.1.0-beta2 73 10/20/2023
3.1.0-beta1 68 10/19/2023
3.0.0-beta5 336 9/8/2019
3.0.0-beta4 293 9/8/2019
3.0.0-beta3 303 8/20/2019
3.0.0-beta2 291 8/18/2019
3.0.0-beta1 285 8/18/2019
2.1.181 675 7/24/2019
2.1.181-beta5 382 7/16/2019
2.1.181-beta4 408 5/10/2019
2.1.181-beta3 409 3/16/2019
2.1.181-beta2 419 3/8/2019
2.1.181-beta 429 3/3/2019
2.1.180 596 3/1/2019
2.1.180-rc1 428 2/28/2019
2.1.180-beta9 462 2/14/2019
2.1.180-beta8 484 2/14/2019
2.1.180-beta7 495 2/8/2019
2.1.180-beta6 472 2/7/2019
2.1.180-beta5 521 2/6/2019
2.1.180-beta4 485 2/5/2019
2.1.180-beta3 466 2/4/2019
2.1.180-beta2 484 2/4/2019
2.1.180-beta1 486 2/4/2019
2.1.180-alpha8 485 1/30/2019
2.1.180-alpha7 483 1/22/2019
2.1.180-alpha6 506 1/21/2019
2.1.180-alpha5 504 1/18/2019
2.1.180-alpha4 542 1/17/2019
2.1.180-alpha3 503 1/16/2019
2.1.180-alpha2 512 1/16/2019
2.1.180-alpha1 510 1/15/2019
2.1.179 682 1/9/2019
2.1.179-beta9 495 1/3/2019
2.1.179-beta8 509 1/2/2019
2.1.179-beta7 533 1/2/2019
2.1.179-beta6 484 12/21/2018
2.1.179-beta5 465 12/19/2018
2.1.179-beta4 471 12/19/2018
2.1.179-beta3 475 12/19/2018
2.1.179-beta2 485 12/18/2018
2.1.179-beta12 491 1/8/2019
2.1.179-beta11 513 1/7/2019
2.1.179-beta10 499 1/4/2019
2.1.179-beta1 504 12/18/2018
2.1.179-alpha9 475 12/18/2018
2.1.179-alpha8 524 11/28/2018
2.1.179-alpha7 506 11/22/2018
2.1.179-alpha6 520 11/20/2018
2.1.179-alpha5 520 11/20/2018
2.1.179-alpha4 522 11/20/2018
2.1.179-alpha3 545 11/19/2018
2.1.179-alpha2 545 11/16/2018
2.1.179-alpha 537 11/16/2018
2.1.178 720 11/6/2018
2.1.178-beta2 516 11/6/2018
2.1.178-beta1 533 10/29/2018
2.1.178-alpha7 557 10/22/2018
2.1.178-alpha6 540 10/19/2018
2.1.178-alpha5 541 10/17/2018
2.1.178-alpha4 580 10/14/2018
2.1.178-alpha3 539 10/13/2018
2.1.178-alpha2 558 10/9/2018
2.1.178-alpha 572 10/9/2018
2.1.177 747 9/27/2018
2.1.177-rc4 550 9/26/2018
2.1.177-rc3 538 9/26/2018
2.1.177-rc2 552 9/26/2018
2.1.177-rc1 534 9/25/2018
2.1.177-beta 547 9/25/2018
2.1.177-alpha 558 9/24/2018
2.1.176 726 9/20/2018
2.1.175 732 9/19/2018
2.1.174 780 9/16/2018
2.1.173 773 9/12/2018
2.1.173-beta 563 9/12/2018
2.1.172 813 9/11/2018
2.1.171 820 8/27/2018
2.1.171-rc1 585 8/27/2018
2.1.171-beta 580 8/27/2018
2.1.170 928 8/15/2018
2.1.169 859 8/14/2018
2.1.168 871 8/10/2018
2.1.167 920 8/9/2018
2.1.166 960 8/9/2018
2.1.165 971 8/9/2018
2.1.164 961 8/8/2018
2.1.163 869 8/8/2018
2.1.162 891 8/8/2018
2.1.161 901 8/8/2018
2.1.160 887 8/7/2018
2.1.159 896 8/3/2018
2.1.158 857 8/2/2018
2.1.157 849 8/1/2018
2.1.156 856 7/30/2018
2.1.155 894 7/29/2018
2.1.154 861 7/19/2018
2.1.153 1,012 7/12/2018
2.1.152 1,017 7/11/2018
2.1.151 1,002 7/11/2018
2.1.150 1,025 7/11/2018
2.1.149 1,021 7/10/2018
2.1.148 1,008 7/4/2018
2.1.147 984 7/3/2018
2.1.146 984 7/1/2018
2.1.145 906 7/1/2018
2.1.144 916 6/28/2018
2.1.143 912 6/25/2018
2.1.142 986 6/19/2018
2.1.141 979 6/19/2018
2.1.140 1,016 6/18/2018
2.0.149 942 7/10/2018
2.0.148 903 7/4/2018
2.0.147 887 7/3/2018
2.0.146 981 7/1/2018
2.0.145 1,046 7/1/2018
2.0.144 915 6/28/2018
2.0.143 1,099 6/25/2018
2.0.142 1,042 6/19/2018
2.0.141 940 6/19/2018
2.0.140 988 6/18/2018
2.0.139 885 6/18/2018
2.0.138 1,014 6/15/2018
2.0.137 897 6/15/2018
2.0.136 1,008 6/12/2018
2.0.135 951 6/11/2018
2.0.134 985 6/11/2018
2.0.133 984 6/11/2018
0.2.132 1,031 5/25/2018
0.2.131 903 5/21/2018
0.2.130 922 5/20/2018
0.2.129 976 5/20/2018
0.2.128 999 5/14/2018
0.2.127 922 5/11/2018
0.2.126 1,028 5/10/2018
0.2.125 1,060 5/8/2018
0.2.124 1,076 4/30/2018
0.2.123 1,095 4/29/2018
0.2.122 1,189 4/27/2018
0.2.121 1,074 4/26/2018
0.2.120 1,039 4/25/2018
0.2.119 1,024 4/25/2018
0.2.118 991 4/25/2018
0.2.117 1,036 4/24/2018
0.2.116 992 4/24/2018
0.2.115 1,019 4/19/2018
0.2.114 1,053 4/19/2018
0.2.113 1,037 4/19/2018
0.2.112 1,057 4/18/2018
0.2.111 1,063 4/18/2018
0.2.110 1,010 4/18/2018
0.2.109 945 4/17/2018
0.2.108 970 4/17/2018
0.2.107 1,084 4/9/2018
0.2.106 1,264 4/6/2018
0.2.105 1,032 4/3/2018
0.2.104 1,087 4/2/2018
0.2.103 1,000 3/28/2018
0.2.102 1,057 3/28/2018
0.2.101 1,040 3/28/2018
0.2.100 1,098 3/27/2018
0.2.99 1,178 3/24/2018
0.2.98 1,168 3/23/2018
0.2.97 974 3/19/2018
0.2.96 976 3/16/2018
0.2.95 1,044 3/15/2018
0.2.94 978 3/13/2018
0.2.93 1,076 3/12/2018
0.2.92 1,050 3/12/2018
0.2.91 1,050 3/12/2018
0.2.90 1,081 3/11/2018
0.2.89 1,030 3/6/2018
0.2.88 1,068 3/2/2018
0.2.87 936 3/1/2018
0.2.86 1,063 2/28/2018
0.2.85 1,060 2/28/2018
0.2.84 1,045 2/28/2018
0.2.83 962 2/27/2018
0.2.82 1,051 2/26/2018
0.2.81 1,083 2/23/2018
0.2.80 1,071 2/22/2018
0.2.79 1,048 2/21/2018
0.2.78 1,083 2/16/2018
0.2.77 1,108 2/14/2018
0.2.76 1,076 2/14/2018
0.2.75 971 2/9/2018
0.2.74 1,133 2/9/2018
0.2.73 1,101 2/1/2018
0.2.72 1,041 1/31/2018
0.2.71 1,075 1/30/2018
0.2.70 982 1/29/2018
0.2.69 1,036 1/26/2018
0.2.68 948 1/23/2018
0.2.67 1,049 1/22/2018
0.2.66 1,001 1/22/2018
0.2.65 1,071 1/19/2018
0.2.64 1,081 1/17/2018
0.2.63 1,047 1/16/2018
0.2.62 1,070 1/15/2018
0.2.61 951 12/18/2017
0.2.60 950 12/6/2017
0.2.59 949 12/5/2017
0.2.58 974 12/4/2017
0.2.57 970 12/1/2017
0.2.56 964 11/30/2017
0.2.55 979 11/28/2017
0.2.54 974 11/28/2017
0.2.53 980 11/28/2017
0.2.52 1,011 11/26/2017
0.2.51 1,000 11/24/2017
0.2.50 968 11/23/2017
0.2.49 1,006 11/17/2017
0.2.48 1,037 11/17/2017
0.2.47 965 11/16/2017
0.2.46 983 11/15/2017
0.2.45 978 11/13/2017
0.2.44 958 11/7/2017
0.2.43 971 11/7/2017
0.2.42 985 11/6/2017
0.2.41 987 10/31/2017
0.2.40 983 10/31/2017
0.2.39 963 10/26/2017
0.2.38 999 10/26/2017
0.2.37 952 10/25/2017
0.2.36 963 10/23/2017
0.2.35 950 10/20/2017
0.2.34 981 10/13/2017
0.2.33 982 10/10/2017
0.2.32 1,013 10/9/2017
0.2.31 981 10/7/2017
0.2.30 961 10/6/2017
0.2.29 962 9/29/2017
0.2.28 938 9/27/2017
0.2.27 969 9/25/2017
0.2.26 987 9/22/2017
0.2.25 953 9/20/2017
0.2.24 1,034 9/19/2017
0.2.23 1,013 9/13/2017
0.2.22 972 9/13/2017
0.2.21 980 9/13/2017
0.2.20 1,005 9/13/2017
0.2.19 969 9/12/2017
0.2.18 946 9/12/2017
0.2.17 948 9/11/2017
0.2.16 979 9/11/2017
0.2.15 997 9/8/2017
0.2.10 1,018 9/8/2017
0.2.9 966 8/29/2017
0.2.6 1,024 8/25/2017
0.2.5 983 8/16/2017
0.2.1-alpha 778 8/16/2017