Shaolinq.SqlServer 0.9.1.388

There is a newer version of this package available.
See the version list below for details.
dotnet add package Shaolinq.SqlServer --version 0.9.1.388
NuGet\Install-Package Shaolinq.SqlServer -Version 0.9.1.388
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="Shaolinq.SqlServer" Version="0.9.1.388" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Shaolinq.SqlServer --version 0.9.1.388
#r "nuget: Shaolinq.SqlServer, 0.9.1.388"
#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 Shaolinq.SqlServer as a Cake Addin
#addin nuget:?package=Shaolinq.SqlServer&version=0.9.1.388

// Install Shaolinq.SqlServer as a Cake Tool
#tool nuget:?package=Shaolinq.SqlServer&version=0.9.1.388

Shaolinq is a thoughtfully designed ORM and Linq provider for .NET
   
Use this package to add Shaolinq and out-of-the-box MySql 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, Postgres and SQL Server.
- 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!

Product Compatible and additional computed target framework versions.
.NET Framework net40 is compatible.  net403 was computed.  net45 was computed.  net451 was computed.  net452 was computed.  net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 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
1.9.5.1477-refs-pull-109-merge 331 10/1/2020
1.9.5.1476-refs-pull-109-head 285 10/1/2020
1.9.5.1475-refs-pull-100-merge 306 9/30/2020
1.9.5.1474-refs-pull-104-merge 306 9/30/2020
1.9.5.1471-refs-pull-108-merge 329 9/30/2020
1.9.5.1470-refs-pull-108-merge 353 9/30/2020
1.9.5.1469-refs-pull-108-head 352 9/30/2020
1.9.5.1468-refs-pull-107-merge 368 9/30/2020
1.9.5.1467-refs-pull-107-head 370 9/30/2020
1.9.5.1466-refs-pull-106-merge 363 9/30/2020
1.9.5.1465-refs-pull-106-head 347 9/30/2020
1.9.5.1464-refs-pull-105-merge 398 9/30/2020
1.9.5.1462-refs-pull-104-merge 421 9/30/2020
1.9.5.1460-refs-pull-100-merge 367 4/1/2020
1.9.5 1,109 1/17/2020
1.9.4.1454-refs-pull-97-merge 424 9/18/2019
1.9.4.1453-refs-pull-97-head 411 9/18/2019
1.9.4.1452-refs-pull-96-merge 403 9/18/2019
1.9.4.1451-refs-pull-96-head 409 9/18/2019
1.9.4.1450-refs-pull-95-merge 409 9/18/2019
1.9.4.1449-refs-pull-95-head 409 9/18/2019
1.9.4 947 11/9/2018
1.9.3.1445-fix-null-enum-bug 578 11/9/2018
1.9.3 765 11/9/2018
1.9.1.1438-feature-allow-re... 588 10/23/2018
1.9.1 814 10/23/2018
1.9.0.1437-feature-model-ge... 581 10/21/2018
1.9.0.1435-fix-query-cachin... 605 10/18/2018
1.9.0 851 10/18/2018
1.8.15 829 10/17/2018
1.8.14.1433-fix-nested-quer... 582 10/17/2018
1.8.14 825 10/16/2018
1.8.13.1429-fix-fix-nested-... 590 10/15/2018
1.8.13 836 10/15/2018
1.8.12 860 10/2/2018
1.8.11.1420-feature-allow-i... 619 10/2/2018
1.8.11.1419-feature-allow-i... 584 10/1/2018
1.8.11.1418-feature-allow-i... 614 10/1/2018
1.8.11 865 9/25/2018
1.8.10.1416-fix-distinct-co... 626 9/25/2018
1.8.10 993 8/16/2018
1.8.9 980 8/16/2018
1.8.8.1409-feature-sqlserve... 693 8/13/2018
1.8.8 915 8/10/2018
1.8.7.1404-fix-sql-index-an... 696 8/10/2018
1.8.7 914 8/10/2018
1.8.6 962 8/8/2018
1.8.4.1394-feature-exclude-... 674 8/7/2018
1.8.4 885 8/7/2018
1.8.3.1391-feature-unique-i... 652 8/7/2018
1.8.3 905 8/6/2018
1.8.2.1387-fix-support-over... 661 8/6/2018
1.8.2 922 8/2/2018
1.8.1.1384-fix-computed-mem... 659 8/1/2018
1.8.1.1383-fix-computed-mem... 672 8/1/2018
1.8.1 960 7/29/2018
1.8.0 898 7/28/2018
1.7.2 870 7/23/2018
1.7.1 859 7/22/2018
1.7.0.1340-feature-support-... 702 7/22/2018
1.7.0.1338-feature-support-... 667 7/22/2018
1.7.0 895 7/22/2018
1.6.0.1329-feature-naming-t... 686 7/21/2018
1.5.0.1304 912 7/20/2018
1.5.0.1303-feature-class-le... 652 7/20/2018
1.5.0.1300 937 6/4/2018
1.5.0.1296-fix-datacontext-... 897 5/6/2018
1.5.0.1295 1,054 4/26/2018
1.5.0.1294 1,042 4/26/2018
1.5.0.1285 963 2/6/2018
1.5.0.1285-asynchooks-test 820 2/6/2018
1.5.0.1280-asynchooks-test 796 2/5/2018
1.3.1.1240 1,080 1/23/2018
1.3.1.1208 1,068 1/17/2018
1.3.1.1207 1,053 1/8/2018
1.3.1.1206 1,058 1/8/2018
1.3.1.1204 981 1/3/2018
1.3.1.1198 1,044 12/21/2017
1.3.1.1195 985 12/1/2017
1.3.1.1194 933 12/1/2017
1.3.1.1193 875 12/1/2017
1.3.1.1171 992 10/17/2017
1.3.1.1163 1,044 7/5/2017
1.3.1.1160 982 6/21/2017
1.3.1.1159 970 6/21/2017
1.3.1.1155 977 6/20/2017
1.3.1.1153 978 6/19/2017
1.3.1.1151 992 6/16/2017
1.3.1.1148 979 6/15/2017
1.3.0.1144 978 6/12/2017
1.3.0.1141 1,014 6/9/2017
1.3.0.1137 1,021 5/12/2017
1.3.0.1135 1,015 5/11/2017
1.3.0.1134 1,050 5/11/2017
1.3.0.1131 1,036 5/6/2017
1.3.0.1130 1,040 5/6/2017
1.3.0.1129 1,001 5/5/2017
1.3.0.1128 969 5/5/2017
1.2.0.1118 976 5/4/2017
1.2.0.1116 1,044 5/4/2017
1.2.0.1114 995 5/4/2017
1.2.0.1112 980 5/4/2017
1.2.0.1111 1,038 5/3/2017
1.2.0.1107 987 5/2/2017
1.2.0.1104 1,023 4/29/2017
1.2.0.1103 1,015 4/28/2017
1.2.0.1101 971 4/28/2017
1.2.0.1095 993 4/27/2017
1.2.0.1092 992 4/18/2017
1.2.0.1088 983 4/17/2017
1.2.0.1087 1,030 4/17/2017
1.2.0.1086 981 4/17/2017
1.2.0.1085 978 4/17/2017
1.2.0.1084 978 4/17/2017
1.2.0.1072-rc1 795 4/14/2017
1.2.0.1071-rc1 761 4/14/2017
1.2.0.1064-rc1 762 4/1/2017
1.2.0.1061-rc1 749 3/31/2017
1.2.0.1059-rc1 769 3/29/2017
1.2.0.1057-rc1 801 3/28/2017
1.2.0.1055-rc1 736 3/28/2017
1.1.1.1044 1,031 3/24/2017
1.1.1.1040 1,014 3/19/2017
1.1.1.1004 1,019 3/10/2017
1.1.1.1002 988 3/9/2017
1.1.1.1000 1,095 2/1/2017
1.1.1.998 1,014 1/31/2017
1.1.1.996 1,147 12/15/2016
1.1.1.991 1,093 11/28/2016
1.1.1.989 1,197 9/22/2016
1.1.1.987 1,449 9/22/2016
1.1.1.986 1,413 9/22/2016
1.1.1.985 1,457 9/22/2016
1.1.1.982 1,056 8/24/2016
1.1.1.980 1,037 8/24/2016
1.1.1.979 1,025 8/22/2016
1.1.0.975 1,017 8/22/2016
1.1.0.973 1,019 8/22/2016
1.1.0.972 1,031 8/22/2016
1.1.0.971 1,001 8/18/2016
1.1.0.970 1,006 8/16/2016
1.1.0.967 1,050 8/15/2016
1.1.0.966 1,056 8/15/2016
1.1.0.964 1,013 8/11/2016
1.1.0.963 1,056 8/9/2016
1.1.0.961 1,063 8/9/2016
1.1.0.960 1,033 8/9/2016
1.1.0.959 1,011 8/8/2016
1.1.0.957 1,029 8/7/2016
1.1.0.956 1,064 8/7/2016
1.1.0.947-rc 806 8/6/2016
1.1.0.946-rc 812 8/5/2016
1.1.0.945 1,067 8/5/2016
1.1.0.942 1,217 7/27/2016
1.1.0.941 1,222 7/27/2016
1.1.0.939 1,169 7/27/2016
1.1.0.938 1,215 7/27/2016
1.1.0.936 1,348 7/26/2016
1.1.0.935 1,060 7/26/2016
1.1.0.932 1,041 7/25/2016
1.1.0.930 1,031 7/23/2016
1.1.0.929 1,058 7/23/2016
1.1.0.928 1,060 7/22/2016
1.1.0.927 1,063 7/22/2016
1.1.0.924 1,160 7/22/2016
1.1.0.923 1,040 7/21/2016
1.1.0.918 997 7/20/2016
1.1.0.915 1,007 7/20/2016
1.1.0.912 1,038 7/20/2016
1.1.0.910 1,049 7/20/2016
1.1.0.904 1,081 7/19/2016
1.1.0.903 1,013 7/18/2016
1.1.0.902 971 7/18/2016
1.1.0.901 1,053 7/18/2016
1.1.0.887 1,075 7/16/2016
1.1.0.886 1,077 7/16/2016
1.1.0.883 1,172 7/14/2016
1.1.0.879 1,200 7/13/2016
1.1.0.877 1,148 7/12/2016
1.1.0.864 1,073 7/9/2016
1.1.0.863 1,049 7/9/2016
1.1.0.859 1,062 7/8/2016
1.1.0.858 994 7/8/2016
1.1.0.857 1,056 7/6/2016
1.1.0.856 1,014 6/29/2016
1.1.0.855 1,017 6/28/2016
1.1.0.854 1,006 6/25/2016
1.0.1.851-rc 1,154 6/17/2016
1.0.1.849-rc 1,143 6/17/2016
1.0.1.842-rc 939 6/9/2016
1.0.1.841-rc 980 6/9/2016
1.0.1.839-rc 1,025 6/9/2016
1.0.1.837-rc 921 5/31/2016
1.0.1.835-rc 851 5/26/2016
1.0.1.834-rc 842 5/24/2016
1.0.1.833-rc 836 5/20/2016
1.0.1.832-rc 843 5/20/2016
1.0.1.828-rc 802 5/9/2016
1.0.1.827-rc 827 5/7/2016
1.0.1.826-rc 836 5/2/2016
1.0.1.824-rc 880 5/1/2016
1.0.1.823-rc 949 4/21/2016
1.0.1.822-rc 802 4/20/2016
1.0.1.821-rc 817 4/11/2016
1.0.1.819-rc 866 4/11/2016
1.0.1.818-rc 815 4/8/2016
1.0.1.817-rc 817 4/7/2016
1.0.1.813-rc 808 4/7/2016
1.0.1.812-rc 834 3/30/2016
1.0.1.811-rc 831 3/30/2016
1.0.1.810-rc 802 3/30/2016
1.0.1.808-rc 799 3/30/2016
1.0.1.807-rc 819 3/29/2016
1.0.1.806-rc 809 3/29/2016
1.0.1.805-rc 822 3/29/2016
1.0.1.796-rc 833 3/27/2016
1.0.1.793-rc 850 3/27/2016
1.0.1.788-rc 827 3/26/2016
1.0.1.785-rc 822 3/26/2016
1.0.1.778-rc 828 3/22/2016
1.0.1.777-rc 1,054 3/22/2016
1.0.1.776-rc 799 3/18/2016
1.0.1.775-rc 839 3/18/2016
1.0.1.774-rc 835 3/16/2016
1.0.1.773-rc 822 3/16/2016
1.0.1.771-rc 775 3/15/2016
1.0.1.769-rc 832 3/15/2016
1.0.1.765-rc 785 3/15/2016
1.0.1.764-rc 805 3/15/2016
1.0.1.759-rc 842 3/14/2016
1.0.1.758-rc 817 3/14/2016
1.0.1.757-rc 786 3/14/2016
1.0.1.752-rc 813 3/13/2016
1.0.1.748-rc 904 3/13/2016
1.0.1.747-rc 926 3/13/2016
1.0.1.746-rc 916 3/13/2016
1.0.1.743-rc 795 3/9/2016
1.0.1.742-rc 796 3/8/2016
1.0.1.741-rc 803 3/8/2016
1.0.1.740-rc 846 3/7/2016
1.0.1.736-rc 809 3/7/2016
1.0.1.735-rc 846 3/7/2016
1.0.1.729-rc 810 3/6/2016
1.0.1.728-rc 774 3/6/2016
1.0.1.726-rc 808 3/6/2016
1.0.1.724-rc 868 3/4/2016
1.0.1.723-rc 844 3/3/2016
1.0.1.722-rc 783 3/3/2016
1.0.1.721-rc 821 3/3/2016
1.0.1.719-rc 820 3/2/2016
1.0.1.717-rc 843 3/1/2016
1.0.1.716-rc 1,105 2/28/2016
1.0.1.711-rc 1,219 2/28/2016
1.0.1.709-rc 1,141 2/27/2016
1.0.1.708-rc 994 2/27/2016
1.0.1.707-rc 951 2/27/2016
1.0.1.706-rc 1,157 2/26/2016
1.0.1.705-rc 1,048 2/26/2016
1.0.1.701-rc 1,034 2/25/2016
1.0.1.699-rc 842 2/23/2016
1.0.1.696-rc 884 2/21/2016
1.0.1.693-rc 940 2/20/2016
1.0.1.691-rc 856 2/19/2016
1.0.1.689-rc 818 2/19/2016
1.0.1.684-rc 862 2/18/2016
1.0.1.683-rc 818 2/18/2016
1.0.1.676-rc 825 2/17/2016
1.0.1.673-rc 833 2/17/2016
1.0.1.670-rc 841 2/17/2016
1.0.1.665-rc 848 2/15/2016
1.0.1.663-rc 837 2/14/2016
1.0.1.659-rc 815 2/14/2016
1.0.1.657-rc 838 2/14/2016
1.0.1.654-rc 978 2/14/2016
1.0.1.648-rc 967 2/13/2016
1.0.1.647-rc 822 2/13/2016
1.0.1.632-rc 810 2/11/2016
1.0.1.631-rc 826 2/11/2016
1.0.1.626-rc 776 2/10/2016
1.0.1.625-rc 823 2/10/2016
1.0.1.609-rc 831 2/4/2016
1.0.1.605-rc 787 2/4/2016
1.0.1.604-rc 823 2/4/2016
1.0.1.600-rc 796 1/28/2016
1.0.1.597-rc 788 1/27/2016
1.0.1.596-rc 851 1/26/2016
1.0.1.595-rc 844 1/22/2016
1.0.1.593-rc 796 1/22/2016
1.0.1.590-rc 803 1/21/2016
1.0.1.588-rc 830 1/20/2016
1.0.1.583-rc 813 1/20/2016
1.0.1.582-rc 819 1/20/2016
1.0.1.574-rc 805 1/19/2016
1.0.1.571-rc 797 1/19/2016
1.0.1.570-rc 837 1/18/2016
1.0.1.569-rc 812 1/17/2016
1.0.1.568-rc 1,128 1/15/2016
1.0.1.565-rc 850 1/8/2016
1.0.1.564-rc 841 1/8/2016
1.0.1.561-rc 827 1/6/2016
1.0.1.557-rc 832 1/3/2016
1.0.1.554-rc 933 12/22/2015
1.0.1.553-rc 911 12/22/2015
1.0.1.552-rc 935 12/22/2015
1.0.1.551-rc 771 12/21/2015
1.0.1.550-rc 813 12/20/2015
1.0.1.545-rc 819 12/17/2015
1.0.1.543-rc 809 12/17/2015
1.0.1.542-rc 811 12/16/2015
1.0.1.539-rc 819 12/16/2015
1.0.1.525-rc 851 12/16/2015
1.0.1.521-rc 843 12/15/2015
1.0.1.512-rc 832 12/14/2015
1.0.1.508-rc 784 12/14/2015
1.0.1.505-rc 832 12/14/2015
1.0.0.492-rc 926 12/11/2015
1.0.0.491-rc 936 12/11/2015
1.0.0.488-rc 949 12/11/2015
1.0.0.487-rc 925 12/11/2015
1.0.0.485-rc 852 12/9/2015
1.0.0.481-rc 797 12/8/2015
1.0.0.479-rc 821 12/7/2015
1.0.0.473-rc 808 12/6/2015
1.0.0.472-rc 1,231 12/3/2015
1.0.0.469-rc 1,177 12/1/2015
1.0.0.465-rc 899 11/19/2015
1.0.0.464-rc 908 11/16/2015
1.0.0.458-rc 879 11/3/2015
1.0.0.448-rc 831 10/27/2015
1.0.0.447-rc 822 10/27/2015
1.0.0.446-rc 846 10/27/2015
1.0.0.443-rc 830 10/27/2015
1.0.0.441-rc 830 10/26/2015
1.0.0.436-rc 831 10/26/2015
1.0.0.434-rc 841 10/26/2015
1.0.0.433-rc 803 10/26/2015
0.9.1.426 1,359 10/8/2015
0.9.1.424 1,446 10/6/2015
0.9.1.418 1,244 9/29/2015
0.9.1.415 1,224 9/29/2015
0.9.1.411 1,214 9/28/2015
0.9.1.408 1,160 9/3/2015
0.9.1.407 1,120 8/18/2015
0.9.1.406 1,619 8/13/2015
0.9.1.405 1,222 8/13/2015
0.9.1.404 1,327 8/13/2015
0.9.1.401 1,410 7/21/2015
0.9.1.395 1,194 7/5/2015
0.9.1.394 1,122 7/4/2015
0.9.1.393 1,181 7/4/2015
0.9.1.390 1,114 6/13/2015
0.9.1.388 1,122 6/13/2015
0.9.1.386 1,102 6/13/2015
0.9.1.385 1,102 6/12/2015
0.9.1.382 1,105 6/12/2015
0.9.1.381 1,090 6/12/2015
0.9.1.380 1,108 6/12/2015
0.9.1.378 1,093 6/12/2015
0.9.1.375 1,390 2/27/2015
0.9.1.373 1,606 2/25/2015
0.9.1.370 1,302 2/25/2015
0.9.1.367 1,511 2/23/2015
0.9.1.365 1,567 2/21/2015
0.9.1.361 1,512 2/21/2015
0.9.1.358 1,434 2/16/2015
0.9.1.357 1,273 2/11/2015
0.9.0.355 1,211 2/10/2015
0.9.0.354 1,139 2/1/2015
0.9.0.353 1,096 1/30/2015

- Added TransactionScopeFactory
- Removed dependency on EF
- Support for ConnectionString rather than pure object or XML configuration
- Added Azure friendly DeleteDatabaseDropsTablesOnly option for SqlServer
- Added Azure friendly DisabledForeignKeyContext
Previous Versions
- Support OrderBy in sub-queries on SQL server
- Support for projecting IGrouping when aggregates are both used and not used.
- Added support for Queryable.Any
- Simplified ObjectState logic
- Fixed bug to do with OrderBy and GroupBy in the same query
- Fixed GroupBy aggregate bug
- Better support for booleans and decimals in SQL Server
- Fixed setting null on deflated object properties doesn't the commit update to the DB.
- Fixed some sometimes unnecessary UPDATE statements executed following INSERT.
- Fixed left/right joins using DefaultIfEmpty ignored/swallowed in Mono.
- Fixed implicit joins in selects sometimes not working when working with explicit Linq joins.
- Native TimeSpan (interval) support for Postgres providers.
- Fixed negate (-ve) operation not support in Sql92QueryFormatter
- Fixed nullable enums on Postgres
- Added DateTime.Add method support.
- Fixed comparing DAOs and DAO properties to null sometimes not working.
- Improved Include() support. Can now include off DAOs that are on projected anonymous types.
- Added base non-generic DataAccessObject class.
- Added ObjectAlreadyExistsException for more specific UniqueConstraintException cases.
- OrderBy and GroupBy now support properties that are are defined on related objects (joins are made automatically/implicitly)
- Better unified cross-provider exceptions for failed unique constraints and when setting related objects that are missing or undefined objects
- Fixed implicit join in Where lost when a Select follow.
- Sqlite provider now converts composite primary keys with more than one auto-increment to a single primary key with a unique constraint across all the composites.
- DataAccessObjects now has GetReference
- DataAccessObjects GetByPrimaryKey and GetManyByPrimaryKey now support composite and complex primary keys
- Support for Include() inside select and on IQueryable.
- Support for Include() when selecting related objects on objects.
- Improved composite GetByPrimaryKey support in DataAccessObjects collections.
- Support recursive Include()
- Support implicit (recursive) joins when predicating or selecting on related objects
- Composite primary keys made up of objects are now supported.
- Improved performance
- Fixed non-aggregate  count. Now uses EXISTS where possible