Shaolinq.Sqlite 1.9.5

Shaolinq is a thoughtfully designed ORM and Linq provider for .NET
   
Use this package to add Shaolinq and out-of-the-box Sqlite support.
   
Designed to perform super fast and be easy to use, Shaolinq's features also include:
   
- First class schema-first ORM with WYSIWYG data access and minipulation.
- First class LINQ support (not the basic kind you see in most other OSS projects).
- Single trip updating of objects.
- Support for Sqlite, MySql and Postgres.
- Automatic database creation and schema migration.
- Delete LINQ extension for batch server side deletes.
- Full support for server side date functions (Date.DayOfWeek etc).
- Easily extensible with a simple interface for adding support for other ADO.NET compatible databases.
- Open Source!

There is a newer prerelease version of this package available.
See the version list below for details.
Install-Package Shaolinq.Sqlite -Version 1.9.5
dotnet add package Shaolinq.Sqlite --version 1.9.5
<PackageReference Include="Shaolinq.Sqlite" Version="1.9.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Shaolinq.Sqlite --version 1.9.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Shaolinq.Sqlite, 1.9.5"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install Shaolinq.Sqlite as a Cake Addin
#addin nuget:?package=Shaolinq.Sqlite&version=1.9.5

// Install Shaolinq.Sqlite as a Cake Tool
#tool nuget:?package=Shaolinq.Sqlite&version=1.9.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

# 1.9.5
- Added Rollback data model hook.
- Fixed when some data model hooks were called.
# 1.9.4
- Fixed bug where comparing a nullable enum property to nullable enum variable can throw an exception if the variable is null.
# 1.9.3
- Added IDataAccessObjectAdvanced.DeflatedPredicate property.
# 1.9.2
- Added DataAccessModel.GetReference{T}(id)  where T : DataAccessObject method.
# 1.9.1
- Allow querying new objects while committing by disabling transaction-context object cache (DataAccessObjectDataContext).
This can occur if there are any computed properties that need to perform additional queries (including implicit N+1 queries from dereferencing child properties) in order to generate the property value.
# 1.9.0
- Fixed potential query caching problems when using queries that include predicated deflated references.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.9.5.1477-refs-pull-109-merge 130 10/1/2020
1.9.5.1476-refs-pull-109-head 130 10/1/2020
1.9.5.1475-refs-pull-100-merge 133 9/30/2020
1.9.5.1474-refs-pull-104-merge 124 9/30/2020
1.9.5.1471-refs-pull-108-merge 144 9/30/2020
1.9.5.1470-refs-pull-108-merge 187 9/30/2020
1.9.5.1469-refs-pull-108-head 182 9/30/2020
1.9.5.1468-refs-pull-107-merge 178 9/30/2020
1.9.5.1467-refs-pull-107-head 185 9/30/2020
1.9.5.1466-refs-pull-106-merge 185 9/30/2020
1.9.5.1465-refs-pull-106-head 183 9/30/2020
1.9.5.1464-refs-pull-105-merge 222 9/30/2020
1.9.5.1462-refs-pull-104-merge 231 9/30/2020
1.9.5.1460-refs-pull-100-merge 210 4/1/2020
1.9.5 391 1/17/2020
1.9.4.1454-refs-pull-97-merge 233 9/18/2019
1.9.4.1453-refs-pull-97-head 216 9/18/2019
1.9.4.1452-refs-pull-96-merge 209 9/18/2019
1.9.4.1451-refs-pull-96-head 221 9/18/2019
1.9.4.1450-refs-pull-95-merge 217 9/18/2019
1.9.4.1449-refs-pull-95-head 210 9/18/2019
1.9.4 539 11/9/2018
1.9.3.1445-fix-null-enum-bug 354 11/9/2018
1.9.3 369 11/9/2018
1.9.1.1438-feature-allow-re... 389 10/23/2018
1.9.1 446 10/23/2018
1.9.0.1437-feature-model-ge... 379 10/21/2018
1.9.0.1435-fix-query-cachin... 384 10/18/2018
1.9.0 416 10/18/2018
1.8.15 405 10/17/2018
1.8.14.1433-fix-nested-quer... 365 10/17/2018
1.8.14 386 10/16/2018
1.8.13.1429-fix-fix-nested-... 386 10/15/2018
1.8.13 404 10/15/2018
1.8.12 445 10/2/2018
1.8.11.1420-feature-allow-i... 405 10/2/2018
1.8.11.1419-feature-allow-i... 410 10/1/2018
1.8.11.1418-feature-allow-i... 387 10/1/2018
1.8.11 455 9/25/2018
1.8.10.1416-fix-distinct-co... 387 9/25/2018
1.8.10 505 8/16/2018
1.8.9 450 8/16/2018
1.8.8.1409-feature-sqlserve... 443 8/13/2018
1.8.8 465 8/10/2018
1.8.7.1404-fix-sql-index-an... 436 8/10/2018
1.8.7 477 8/10/2018
1.8.6 484 8/8/2018
1.8.4.1394-feature-exclude-... 447 8/7/2018
1.8.4 473 8/7/2018
1.8.3.1391-feature-unique-i... 437 8/7/2018
1.8.3 453 8/6/2018
1.8.2.1387-fix-support-over... 435 8/6/2018
1.8.2 455 8/2/2018
1.8.1.1384-fix-computed-mem... 437 8/1/2018
1.8.1.1383-fix-computed-mem... 420 8/1/2018
1.8.1 452 7/29/2018
1.8.0 450 7/28/2018
1.7.2 445 7/23/2018
1.7.1 441 7/22/2018
1.7.0.1340-feature-support-... 430 7/22/2018
1.7.0.1338-feature-support-... 433 7/22/2018
1.7.0 451 7/22/2018
1.6.0.1329-feature-naming-t... 433 7/21/2018
1.5.0.1304 453 7/20/2018
1.5.0.1303-feature-class-le... 447 7/20/2018
1.5.0.1300 531 6/4/2018
1.5.0.1296-fix-datacontext-... 603 5/6/2018
1.5.0.1295 556 4/26/2018
1.5.0.1294 468 4/26/2018
1.5.0.1285 615 2/6/2018
1.5.0.1285-asynchooks-test 530 2/6/2018
1.5.0.1280-asynchooks-test 541 2/5/2018
1.3.1.1240 623 1/23/2018
1.3.1.1208 530 1/17/2018
1.3.1.1207 538 1/8/2018
1.3.1.1206 534 1/8/2018
1.3.1.1204 526 1/3/2018
1.3.1.1198 577 12/21/2017
1.3.1.1195 503 12/1/2017
1.3.1.1194 489 12/1/2017
1.3.1.1193 491 12/1/2017
1.3.1.1171 539 10/17/2017
1.3.1.1163 593 7/5/2017
1.3.1.1160 533 6/21/2017
1.3.1.1159 514 6/21/2017
1.3.1.1155 563 6/20/2017
1.3.1.1153 528 6/19/2017
1.3.1.1151 535 6/16/2017
1.3.1.1148 541 6/15/2017
1.3.0.1144 531 6/12/2017
1.3.0.1141 539 6/9/2017
1.3.0.1137 558 5/12/2017
1.3.0.1135 530 5/11/2017
1.3.0.1134 533 5/11/2017
1.3.0.1131 542 5/6/2017
1.3.0.1130 527 5/6/2017
1.3.0.1129 531 5/5/2017
1.3.0.1128 533 5/5/2017
1.2.0.1118 532 5/4/2017
1.2.0.1116 527 5/4/2017
1.2.0.1114 536 5/4/2017
1.2.0.1112 514 5/4/2017
1.2.0.1111 520 5/3/2017
1.2.0.1107 540 5/2/2017
1.2.0.1104 546 4/29/2017
1.2.0.1103 529 4/28/2017
1.2.0.1101 536 4/28/2017
1.2.0.1095 548 4/27/2017
1.2.0.1092 535 4/18/2017
1.2.0.1088 537 4/17/2017
1.2.0.1087 534 4/17/2017
1.2.0.1086 533 4/17/2017
1.2.0.1085 514 4/17/2017
1.2.0.1084 516 4/17/2017
1.2.0.1072-rc1 508 4/14/2017
1.2.0.1071-rc1 494 4/14/2017
1.2.0.1064-rc1 520 4/1/2017
1.2.0.1061-rc1 494 3/31/2017
1.2.0.1059-rc1 504 3/29/2017
1.2.0.1057-rc1 512 3/28/2017
1.2.0.1055-rc1 497 3/28/2017
1.1.1.1044 571 3/24/2017
1.1.1.1040 538 3/19/2017
1.1.1.1004 537 3/10/2017
1.1.1.1002 534 3/9/2017
1.1.1.1000 629 2/1/2017
1.1.1.998 554 1/31/2017
1.1.1.996 694 12/15/2016
1.1.1.991 639 11/28/2016
1.1.1.989 667 9/22/2016
1.1.1.987 558 9/22/2016
1.1.1.986 561 9/22/2016
1.1.1.985 549 9/22/2016
1.1.1.982 608 8/24/2016
1.1.1.980 584 8/24/2016
1.1.1.979 585 8/22/2016
1.1.0.975 616 8/22/2016
1.1.0.973 555 8/22/2016
1.1.0.972 568 8/22/2016
1.1.0.971 588 8/18/2016
1.1.0.970 589 8/16/2016
1.1.0.967 579 8/15/2016
1.1.0.966 626 8/15/2016
1.1.0.964 586 8/11/2016
1.1.0.963 628 8/9/2016
1.1.0.961 540 8/9/2016
1.1.0.960 594 8/9/2016
1.1.0.959 590 8/8/2016
1.1.0.957 588 8/7/2016
1.1.0.956 570 8/7/2016
1.1.0.947-rc 527 8/6/2016
1.1.0.946-rc 539 8/5/2016
1.1.0.945 575 8/5/2016
1.1.0.942 619 7/27/2016
1.1.0.941 593 7/27/2016
1.1.0.939 599 7/27/2016
1.1.0.938 604 7/27/2016
1.1.0.936 594 7/26/2016
1.1.0.935 579 7/26/2016
1.1.0.932 593 7/25/2016
1.1.0.930 604 7/23/2016
1.1.0.929 615 7/23/2016
1.1.0.928 600 7/22/2016
1.1.0.927 609 7/22/2016
1.1.0.924 661 7/22/2016
1.1.0.923 598 7/21/2016
1.1.0.918 573 7/20/2016
1.1.0.915 567 7/20/2016
1.1.0.912 583 7/20/2016
1.1.0.910 562 7/20/2016
1.1.0.904 588 7/19/2016
1.1.0.903 557 7/18/2016
1.1.0.902 552 7/18/2016
1.1.0.901 572 7/18/2016
1.1.0.887 633 7/16/2016
1.1.0.886 577 7/16/2016
1.1.0.883 748 7/14/2016
1.1.0.879 750 7/13/2016
1.1.0.877 710 7/12/2016
1.1.0.864 614 7/9/2016
1.1.0.863 629 7/9/2016
1.1.0.859 600 7/8/2016
1.1.0.858 594 7/8/2016
1.1.0.857 632 7/6/2016
1.1.0.856 607 6/29/2016
1.1.0.855 608 6/28/2016
1.1.0.854 580 6/25/2016
1.0.1.851-rc 548 6/17/2016
1.0.1.849-rc 558 6/17/2016
1.0.1.842-rc 599 6/9/2016
1.0.1.841-rc 562 6/9/2016
1.0.1.839-rc 574 6/9/2016
1.0.1.837-rc 641 5/31/2016
1.0.1.835-rc 555 5/26/2016
1.0.1.834-rc 585 5/24/2016
1.0.1.833-rc 590 5/20/2016
1.0.1.832-rc 550 5/20/2016
1.0.1.828-rc 580 5/9/2016
1.0.1.827-rc 558 5/7/2016
1.0.1.826-rc 578 5/2/2016
1.0.1.824-rc 570 5/1/2016
1.0.1.823-rc 574 4/21/2016
1.0.1.822-rc 554 4/20/2016
1.0.1.821-rc 573 4/11/2016
1.0.1.819-rc 624 4/11/2016
1.0.1.818-rc 565 4/8/2016
1.0.1.817-rc 579 4/7/2016
1.0.1.813-rc 562 4/7/2016
1.0.1.812-rc 810 3/30/2016
1.0.1.811-rc 577 3/30/2016
1.0.1.810-rc 558 3/30/2016
1.0.1.808-rc 556 3/30/2016
1.0.1.807-rc 612 3/29/2016
1.0.1.806-rc 600 3/29/2016
1.0.1.805-rc 580 3/29/2016
1.0.1.796-rc 581 3/27/2016
1.0.1.793-rc 574 3/27/2016
1.0.1.788-rc 567 3/26/2016
1.0.1.785-rc 600 3/26/2016
1.0.1.778-rc 595 3/22/2016
1.0.1.777-rc 562 3/22/2016
1.0.1.776-rc 558 3/18/2016
1.0.1.775-rc 587 3/18/2016
1.0.1.774-rc 582 3/16/2016
1.0.1.773-rc 594 3/16/2016
1.0.1.771-rc 548 3/15/2016
1.0.1.769-rc 542 3/15/2016
1.0.1.765-rc 589 3/15/2016
1.0.1.764-rc 586 3/15/2016
1.0.1.759-rc 585 3/14/2016
1.0.1.758-rc 537 3/14/2016
1.0.1.757-rc 535 3/14/2016
1.0.1.752-rc 553 3/13/2016
1.0.1.748-rc 558 3/13/2016
1.0.1.747-rc 570 3/13/2016
1.0.1.746-rc 571 3/13/2016
1.0.1.743-rc 548 3/9/2016
1.0.1.742-rc 560 3/8/2016
1.0.1.741-rc 588 3/8/2016
1.0.1.740-rc 585 3/7/2016
1.0.1.736-rc 576 3/7/2016
1.0.1.735-rc 593 3/7/2016
1.0.1.729-rc 571 3/6/2016
1.0.1.728-rc 588 3/6/2016
1.0.1.726-rc 568 3/6/2016
1.0.1.724-rc 608 3/4/2016
1.0.1.723-rc 555 3/3/2016
1.0.1.722-rc 613 3/3/2016
1.0.1.721-rc 582 3/3/2016
1.0.1.719-rc 552 3/2/2016
1.0.1.717-rc 561 3/1/2016
1.0.1.716-rc 625 2/28/2016
1.0.1.711-rc 604 2/28/2016
1.0.1.709-rc 595 2/27/2016
1.0.1.708-rc 591 2/27/2016
1.0.1.707-rc 625 2/27/2016
1.0.1.706-rc 596 2/26/2016
1.0.1.705-rc 620 2/26/2016
1.0.1.701-rc 558 2/25/2016
1.0.1.699-rc 567 2/23/2016
1.0.1.696-rc 633 2/21/2016
1.0.1.693-rc 600 2/20/2016
1.0.1.691-rc 541 2/19/2016
1.0.1.689-rc 553 2/19/2016
1.0.1.684-rc 576 2/18/2016
1.0.1.683-rc 561 2/18/2016
1.0.1.676-rc 553 2/17/2016
1.0.1.673-rc 566 2/17/2016
1.0.1.670-rc 545 2/17/2016
1.0.1.665-rc 580 2/15/2016
1.0.1.663-rc 587 2/14/2016
1.0.1.659-rc 581 2/14/2016
1.0.1.657-rc 592 2/14/2016
1.0.1.654-rc 624 2/14/2016
1.0.1.648-rc 610 2/13/2016
1.0.1.647-rc 606 2/13/2016
1.0.1.632-rc 557 2/11/2016
1.0.1.631-rc 567 2/11/2016
1.0.1.626-rc 543 2/10/2016
1.0.1.625-rc 553 2/10/2016
1.0.1.609-rc 563 2/4/2016
1.0.1.605-rc 567 2/4/2016
1.0.1.604-rc 589 2/4/2016
1.0.1.600-rc 569 1/28/2016
1.0.1.597-rc 560 1/27/2016
1.0.1.596-rc 671 1/26/2016
1.0.1.595-rc 556 1/22/2016
1.0.1.593-rc 581 1/22/2016
1.0.1.590-rc 580 1/21/2016
1.0.1.588-rc 620 1/20/2016
1.0.1.583-rc 574 1/20/2016
1.0.1.582-rc 588 1/20/2016
1.0.1.574-rc 587 1/19/2016
1.0.1.571-rc 547 1/19/2016
1.0.1.570-rc 571 1/18/2016
1.0.1.569-rc 557 1/17/2016
1.0.1.568-rc 637 1/15/2016
1.0.1.565-rc 587 1/8/2016
1.0.1.564-rc 561 1/8/2016
1.0.1.561-rc 564 1/6/2016
1.0.1.557-rc 570 1/3/2016
1.0.1.554-rc 636 12/22/2015
1.0.1.553-rc 631 12/22/2015
1.0.1.552-rc 639 12/22/2015
1.0.1.551-rc 549 12/21/2015
1.0.1.550-rc 557 12/20/2015
1.0.1.545-rc 558 12/17/2015
1.0.1.543-rc 551 12/17/2015
1.0.1.542-rc 600 12/16/2015
1.0.1.539-rc 559 12/16/2015
1.0.1.525-rc 571 12/16/2015
1.0.1.521-rc 591 12/15/2015
1.0.1.512-rc 558 12/14/2015
1.0.1.508-rc 563 12/14/2015
1.0.1.505-rc 562 12/14/2015
1.0.0.492-rc 626 12/11/2015
1.0.0.491-rc 645 12/11/2015
1.0.0.488-rc 623 12/11/2015
1.0.0.487-rc 617 12/11/2015
1.0.0.485-rc 574 12/9/2015
1.0.0.481-rc 575 12/8/2015
1.0.0.479-rc 570 12/7/2015
1.0.0.473-rc 542 12/6/2015
1.0.0.472-rc 565 12/3/2015
1.0.0.469-rc 605 12/1/2015
1.0.0.465-rc 579 11/19/2015
1.0.0.464-rc 589 11/16/2015
1.0.0.458-rc 584 11/3/2015
1.0.0.448-rc 579 10/27/2015
1.0.0.447-rc 563 10/27/2015
1.0.0.446-rc 580 10/27/2015
1.0.0.443-rc 592 10/27/2015
1.0.0.441-rc 584 10/26/2015
1.0.0.436-rc 572 10/26/2015
1.0.0.434-rc 582 10/26/2015
1.0.0.433-rc 594 10/26/2015
0.9.1.426 841 10/8/2015
0.9.1.424 620 10/6/2015
0.9.1.418 643 9/29/2015
0.9.1.415 597 9/29/2015
0.9.1.411 644 9/28/2015
0.9.1.408 673 9/3/2015
0.9.1.407 635 8/18/2015
0.9.1.406 619 8/13/2015
0.9.1.405 596 8/13/2015
0.9.1.404 601 8/13/2015
0.9.1.401 761 7/21/2015
0.9.1.395 685 7/5/2015
0.9.1.394 612 7/4/2015
0.9.1.393 625 7/4/2015
0.9.1.390 629 6/13/2015
0.9.1.388 599 6/13/2015
0.9.1.386 608 6/13/2015
0.9.1.385 602 6/12/2015
0.9.1.382 597 6/12/2015
0.9.1.381 656 6/12/2015
0.9.1.380 602 6/12/2015
0.9.1.378 598 6/12/2015
0.9.1.375 749 2/27/2015
0.9.1.373 686 2/25/2015
0.9.1.370 617 2/25/2015
0.9.1.367 716 2/23/2015
0.9.1.365 664 2/21/2015
0.9.1.361 614 2/21/2015
0.9.1.358 702 2/16/2015
0.9.1.357 682 2/11/2015
0.9.0.355 645 2/10/2015
0.9.0.354 652 2/1/2015
0.9.0.353 677 1/30/2015
0.9.0.350 676 1/29/2015
0.9.0.338 666 1/12/2015
0.9.0.328 636 11/25/2014
0.9.0.326 664 11/24/2014
0.9.0.325 636 11/24/2014
0.9.0.323 732 11/23/2014
0.9.0.313 716 11/22/2014
0.9.0.299 773 11/12/2014
0.9.0.295 959 11/12/2014
0.9.0.290 773 11/11/2014
0.9.0.279 983 11/9/2014
0.9.0.269 876 11/6/2014
0.9.0.268 1,160 11/4/2014
0.9.0.266 1,423 11/3/2014
0.9.0.265 948 11/3/2014
0.9.0.263 1,176 11/3/2014
0.9.0.262 901 11/3/2014
0.9.0.249 642 10/27/2014
0.9.0.236 637 10/25/2014
0.9.0.234 645 10/24/2014
0.9.0.233 633 10/21/2014
0.9.0.227 628 10/21/2014
0.9.0.226 653 10/21/2014
0.9.0.225 646 10/21/2014
0.9.0.222 682 10/19/2014
0.9.0.221 649 10/19/2014
0.9.0.204 649 10/17/2014
0.9.0.200 664 10/15/2014
0.9.0.199 670 10/15/2014
0.9.0.193 660 10/14/2014
0.9.0.189 656 10/14/2014
0.9.0.184-test 603 10/14/2014
0.9.0.183-test 630 10/13/2014
0.9.0.179 641 10/13/2014
0.9.0.174 668 10/13/2014
0.6.0.173 696 10/13/2014
0.6.0.165 684 10/3/2014
0.6.0.160 711 9/18/2014
0.6.0.157 697 9/18/2014
0.6.0.155 660 9/18/2014
0.6.0.151 628 9/17/2014
0.6.0.147 637 9/16/2014
0.6.0.143 691 9/12/2014
0.6.0.141 695 9/10/2014
0.6.0.139 680 9/3/2014
0.6.0.135 732 8/21/2014
0.6.0.134 710 8/8/2014
0.6.0.130 664 8/4/2014
0.6.0.127 675 7/1/2014
0.6.0.101 705 1/21/2014
0.6.0.97 679 1/16/2014
0.5.0.51 682 1/5/2014
0.5.0.36 664 12/9/2013
0.5.0.35 651 12/8/2013
0.5.0.29 686 12/1/2013
0.5.0.28 680 12/1/2013
Show less