Shaolinq.SqlServer 0.9.1.361

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.361
NuGet\Install-Package Shaolinq.SqlServer -Version 0.9.1.361
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.361" />
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.361
#r "nuget: Shaolinq.SqlServer, 0.9.1.361"
#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.361

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

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 341 10/1/2020
1.9.5.1476-refs-pull-109-head 288 10/1/2020
1.9.5.1475-refs-pull-100-merge 309 9/30/2020
1.9.5.1474-refs-pull-104-merge 309 9/30/2020
1.9.5.1471-refs-pull-108-merge 332 9/30/2020
1.9.5.1470-refs-pull-108-merge 356 9/30/2020
1.9.5.1469-refs-pull-108-head 355 9/30/2020
1.9.5.1468-refs-pull-107-merge 371 9/30/2020
1.9.5.1467-refs-pull-107-head 373 9/30/2020
1.9.5.1466-refs-pull-106-merge 366 9/30/2020
1.9.5.1465-refs-pull-106-head 350 9/30/2020
1.9.5.1464-refs-pull-105-merge 401 9/30/2020
1.9.5.1462-refs-pull-104-merge 424 9/30/2020
1.9.5.1460-refs-pull-100-merge 370 4/1/2020
1.9.5 1,131 1/17/2020
1.9.4.1454-refs-pull-97-merge 427 9/18/2019
1.9.4.1453-refs-pull-97-head 414 9/18/2019
1.9.4.1452-refs-pull-96-merge 406 9/18/2019
1.9.4.1451-refs-pull-96-head 412 9/18/2019
1.9.4.1450-refs-pull-95-merge 412 9/18/2019
1.9.4.1449-refs-pull-95-head 412 9/18/2019
1.9.4 952 11/9/2018
1.9.3.1445-fix-null-enum-bug 579 11/9/2018
1.9.3 769 11/9/2018
1.9.1.1438-feature-allow-re... 592 10/23/2018
1.9.1 822 10/23/2018
1.9.0.1437-feature-model-ge... 585 10/21/2018
1.9.0.1435-fix-query-cachin... 609 10/18/2018
1.9.0 858 10/18/2018
1.8.15 837 10/17/2018
1.8.14.1433-fix-nested-quer... 587 10/17/2018
1.8.14 832 10/16/2018
1.8.13.1429-fix-fix-nested-... 594 10/15/2018
1.8.13 843 10/15/2018
1.8.12 867 10/2/2018
1.8.11.1420-feature-allow-i... 623 10/2/2018
1.8.11.1419-feature-allow-i... 588 10/1/2018
1.8.11.1418-feature-allow-i... 618 10/1/2018
1.8.11 873 9/25/2018
1.8.10.1416-fix-distinct-co... 630 9/25/2018
1.8.10 1,001 8/16/2018
1.8.9 987 8/16/2018
1.8.8.1409-feature-sqlserve... 698 8/13/2018
1.8.8 924 8/10/2018
1.8.7.1404-fix-sql-index-an... 702 8/10/2018
1.8.7 923 8/10/2018
1.8.6 971 8/8/2018
1.8.4.1394-feature-exclude-... 675 8/7/2018
1.8.4 889 8/7/2018
1.8.3.1391-feature-unique-i... 653 8/7/2018
1.8.3 909 8/6/2018
1.8.2.1387-fix-support-over... 662 8/6/2018
1.8.2 926 8/2/2018
1.8.1.1384-fix-computed-mem... 660 8/1/2018
1.8.1.1383-fix-computed-mem... 673 8/1/2018
1.8.1 965 7/29/2018
1.8.0 902 7/28/2018
1.7.2 875 7/23/2018
1.7.1 863 7/22/2018
1.7.0.1340-feature-support-... 704 7/22/2018
1.7.0.1338-feature-support-... 668 7/22/2018
1.7.0 899 7/22/2018
1.6.0.1329-feature-naming-t... 688 7/21/2018
1.5.0.1304 917 7/20/2018
1.5.0.1303-feature-class-le... 654 7/20/2018
1.5.0.1300 942 6/4/2018
1.5.0.1296-fix-datacontext-... 898 5/6/2018
1.5.0.1295 1,059 4/26/2018
1.5.0.1294 1,046 4/26/2018
1.5.0.1285 968 2/6/2018
1.5.0.1285-asynchooks-test 821 2/6/2018
1.5.0.1280-asynchooks-test 797 2/5/2018
1.3.1.1240 1,088 1/23/2018
1.3.1.1208 1,072 1/17/2018
1.3.1.1207 1,057 1/8/2018
1.3.1.1206 1,062 1/8/2018
1.3.1.1204 985 1/3/2018
1.3.1.1198 1,049 12/21/2017
1.3.1.1195 989 12/1/2017
1.3.1.1194 937 12/1/2017
1.3.1.1193 879 12/1/2017
1.3.1.1171 997 10/17/2017
1.3.1.1163 1,049 7/5/2017
1.3.1.1160 987 6/21/2017
1.3.1.1159 974 6/21/2017
1.3.1.1155 981 6/20/2017
1.3.1.1153 982 6/19/2017
1.3.1.1151 996 6/16/2017
1.3.1.1148 983 6/15/2017
1.3.0.1144 982 6/12/2017
1.3.0.1141 1,018 6/9/2017
1.3.0.1137 1,026 5/12/2017
1.3.0.1135 1,019 5/11/2017
1.3.0.1134 1,057 5/11/2017
1.3.0.1131 1,040 5/6/2017
1.3.0.1130 1,044 5/6/2017
1.3.0.1129 1,005 5/5/2017
1.3.0.1128 973 5/5/2017
1.2.0.1118 981 5/4/2017
1.2.0.1116 1,048 5/4/2017
1.2.0.1114 999 5/4/2017
1.2.0.1112 984 5/4/2017
1.2.0.1111 1,042 5/3/2017
1.2.0.1107 991 5/2/2017
1.2.0.1104 1,028 4/29/2017
1.2.0.1103 1,019 4/28/2017
1.2.0.1101 975 4/28/2017
1.2.0.1095 997 4/27/2017
1.2.0.1092 996 4/18/2017
1.2.0.1088 987 4/17/2017
1.2.0.1087 1,034 4/17/2017
1.2.0.1086 985 4/17/2017
1.2.0.1085 982 4/17/2017
1.2.0.1084 982 4/17/2017
1.2.0.1072-rc1 797 4/14/2017
1.2.0.1071-rc1 762 4/14/2017
1.2.0.1064-rc1 763 4/1/2017
1.2.0.1061-rc1 750 3/31/2017
1.2.0.1059-rc1 770 3/29/2017
1.2.0.1057-rc1 802 3/28/2017
1.2.0.1055-rc1 737 3/28/2017
1.1.1.1044 1,036 3/24/2017
1.1.1.1040 1,018 3/19/2017
1.1.1.1004 1,023 3/10/2017
1.1.1.1002 992 3/9/2017
1.1.1.1000 1,100 2/1/2017
1.1.1.998 1,019 1/31/2017
1.1.1.996 1,152 12/15/2016
1.1.1.991 1,098 11/28/2016
1.1.1.989 1,203 9/22/2016
1.1.1.987 1,454 9/22/2016
1.1.1.986 1,418 9/22/2016
1.1.1.985 1,465 9/22/2016
1.1.1.982 1,060 8/24/2016
1.1.1.980 1,040 8/24/2016
1.1.1.979 1,028 8/22/2016
1.1.0.975 1,020 8/22/2016
1.1.0.973 1,022 8/22/2016
1.1.0.972 1,034 8/22/2016
1.1.0.971 1,004 8/18/2016
1.1.0.970 1,009 8/16/2016
1.1.0.967 1,053 8/15/2016
1.1.0.966 1,059 8/15/2016
1.1.0.964 1,016 8/11/2016
1.1.0.963 1,059 8/9/2016
1.1.0.961 1,066 8/9/2016
1.1.0.960 1,036 8/9/2016
1.1.0.959 1,014 8/8/2016
1.1.0.957 1,032 8/7/2016
1.1.0.956 1,067 8/7/2016
1.1.0.947-rc 809 8/6/2016
1.1.0.946-rc 814 8/5/2016
1.1.0.945 1,070 8/5/2016
1.1.0.942 1,222 7/27/2016
1.1.0.941 1,225 7/27/2016
1.1.0.939 1,172 7/27/2016
1.1.0.938 1,218 7/27/2016
1.1.0.936 1,354 7/26/2016
1.1.0.935 1,063 7/26/2016
1.1.0.932 1,044 7/25/2016
1.1.0.930 1,034 7/23/2016
1.1.0.929 1,061 7/23/2016
1.1.0.928 1,063 7/22/2016
1.1.0.927 1,066 7/22/2016
1.1.0.924 1,163 7/22/2016
1.1.0.923 1,043 7/21/2016
1.1.0.918 1,000 7/20/2016
1.1.0.915 1,010 7/20/2016
1.1.0.912 1,041 7/20/2016
1.1.0.910 1,052 7/20/2016
1.1.0.904 1,084 7/19/2016
1.1.0.903 1,016 7/18/2016
1.1.0.902 974 7/18/2016
1.1.0.901 1,056 7/18/2016
1.1.0.887 1,078 7/16/2016
1.1.0.886 1,080 7/16/2016
1.1.0.883 1,175 7/14/2016
1.1.0.879 1,203 7/13/2016
1.1.0.877 1,151 7/12/2016
1.1.0.864 1,077 7/9/2016
1.1.0.863 1,052 7/9/2016
1.1.0.859 1,065 7/8/2016
1.1.0.858 998 7/8/2016
1.1.0.857 1,060 7/6/2016
1.1.0.856 1,019 6/29/2016
1.1.0.855 1,020 6/28/2016
1.1.0.854 1,009 6/25/2016
1.0.1.851-rc 1,157 6/17/2016
1.0.1.849-rc 1,145 6/17/2016
1.0.1.842-rc 941 6/9/2016
1.0.1.841-rc 982 6/9/2016
1.0.1.839-rc 1,027 6/9/2016
1.0.1.837-rc 923 5/31/2016
1.0.1.835-rc 853 5/26/2016
1.0.1.834-rc 844 5/24/2016
1.0.1.833-rc 838 5/20/2016
1.0.1.832-rc 845 5/20/2016
1.0.1.828-rc 804 5/9/2016
1.0.1.827-rc 829 5/7/2016
1.0.1.826-rc 838 5/2/2016
1.0.1.824-rc 882 5/1/2016
1.0.1.823-rc 951 4/21/2016
1.0.1.822-rc 804 4/20/2016
1.0.1.821-rc 819 4/11/2016
1.0.1.819-rc 868 4/11/2016
1.0.1.818-rc 817 4/8/2016
1.0.1.817-rc 819 4/7/2016
1.0.1.813-rc 810 4/7/2016
1.0.1.812-rc 836 3/30/2016
1.0.1.811-rc 833 3/30/2016
1.0.1.810-rc 804 3/30/2016
1.0.1.808-rc 801 3/30/2016
1.0.1.807-rc 821 3/29/2016
1.0.1.806-rc 811 3/29/2016
1.0.1.805-rc 824 3/29/2016
1.0.1.796-rc 835 3/27/2016
1.0.1.793-rc 852 3/27/2016
1.0.1.788-rc 829 3/26/2016
1.0.1.785-rc 824 3/26/2016
1.0.1.778-rc 830 3/22/2016
1.0.1.777-rc 1,056 3/22/2016
1.0.1.776-rc 801 3/18/2016
1.0.1.775-rc 841 3/18/2016
1.0.1.774-rc 837 3/16/2016
1.0.1.773-rc 824 3/16/2016
1.0.1.771-rc 777 3/15/2016
1.0.1.769-rc 834 3/15/2016
1.0.1.765-rc 787 3/15/2016
1.0.1.764-rc 807 3/15/2016
1.0.1.759-rc 844 3/14/2016
1.0.1.758-rc 819 3/14/2016
1.0.1.757-rc 788 3/14/2016
1.0.1.752-rc 815 3/13/2016
1.0.1.748-rc 906 3/13/2016
1.0.1.747-rc 928 3/13/2016
1.0.1.746-rc 918 3/13/2016
1.0.1.743-rc 797 3/9/2016
1.0.1.742-rc 798 3/8/2016
1.0.1.741-rc 805 3/8/2016
1.0.1.740-rc 848 3/7/2016
1.0.1.736-rc 811 3/7/2016
1.0.1.735-rc 848 3/7/2016
1.0.1.729-rc 812 3/6/2016
1.0.1.728-rc 776 3/6/2016
1.0.1.726-rc 810 3/6/2016
1.0.1.724-rc 870 3/4/2016
1.0.1.723-rc 846 3/3/2016
1.0.1.722-rc 785 3/3/2016
1.0.1.721-rc 823 3/3/2016
1.0.1.719-rc 822 3/2/2016
1.0.1.717-rc 845 3/1/2016
1.0.1.716-rc 1,107 2/28/2016
1.0.1.711-rc 1,221 2/28/2016
1.0.1.709-rc 1,143 2/27/2016
1.0.1.708-rc 996 2/27/2016
1.0.1.707-rc 953 2/27/2016
1.0.1.706-rc 1,159 2/26/2016
1.0.1.705-rc 1,050 2/26/2016
1.0.1.701-rc 1,036 2/25/2016
1.0.1.699-rc 844 2/23/2016
1.0.1.696-rc 886 2/21/2016
1.0.1.693-rc 942 2/20/2016
1.0.1.691-rc 858 2/19/2016
1.0.1.689-rc 820 2/19/2016
1.0.1.684-rc 864 2/18/2016
1.0.1.683-rc 820 2/18/2016
1.0.1.676-rc 827 2/17/2016
1.0.1.673-rc 835 2/17/2016
1.0.1.670-rc 843 2/17/2016
1.0.1.665-rc 850 2/15/2016
1.0.1.663-rc 839 2/14/2016
1.0.1.659-rc 817 2/14/2016
1.0.1.657-rc 840 2/14/2016
1.0.1.654-rc 980 2/14/2016
1.0.1.648-rc 969 2/13/2016
1.0.1.647-rc 824 2/13/2016
1.0.1.632-rc 812 2/11/2016
1.0.1.631-rc 828 2/11/2016
1.0.1.626-rc 778 2/10/2016
1.0.1.625-rc 825 2/10/2016
1.0.1.609-rc 833 2/4/2016
1.0.1.605-rc 789 2/4/2016
1.0.1.604-rc 825 2/4/2016
1.0.1.600-rc 798 1/28/2016
1.0.1.597-rc 790 1/27/2016
1.0.1.596-rc 853 1/26/2016
1.0.1.595-rc 846 1/22/2016
1.0.1.593-rc 798 1/22/2016
1.0.1.590-rc 805 1/21/2016
1.0.1.588-rc 832 1/20/2016
1.0.1.583-rc 815 1/20/2016
1.0.1.582-rc 821 1/20/2016
1.0.1.574-rc 807 1/19/2016
1.0.1.571-rc 799 1/19/2016
1.0.1.570-rc 839 1/18/2016
1.0.1.569-rc 814 1/17/2016
1.0.1.568-rc 1,130 1/15/2016
1.0.1.565-rc 852 1/8/2016
1.0.1.564-rc 843 1/8/2016
1.0.1.561-rc 829 1/6/2016
1.0.1.557-rc 834 1/3/2016
1.0.1.554-rc 935 12/22/2015
1.0.1.553-rc 913 12/22/2015
1.0.1.552-rc 937 12/22/2015
1.0.1.551-rc 773 12/21/2015
1.0.1.550-rc 815 12/20/2015
1.0.1.545-rc 821 12/17/2015
1.0.1.543-rc 811 12/17/2015
1.0.1.542-rc 813 12/16/2015
1.0.1.539-rc 821 12/16/2015
1.0.1.525-rc 853 12/16/2015
1.0.1.521-rc 845 12/15/2015
1.0.1.512-rc 834 12/14/2015
1.0.1.508-rc 786 12/14/2015
1.0.1.505-rc 834 12/14/2015
1.0.0.492-rc 928 12/11/2015
1.0.0.491-rc 938 12/11/2015
1.0.0.488-rc 951 12/11/2015
1.0.0.487-rc 927 12/11/2015
1.0.0.485-rc 854 12/9/2015
1.0.0.481-rc 799 12/8/2015
1.0.0.479-rc 823 12/7/2015
1.0.0.473-rc 810 12/6/2015
1.0.0.472-rc 1,233 12/3/2015
1.0.0.469-rc 1,179 12/1/2015
1.0.0.465-rc 901 11/19/2015
1.0.0.464-rc 910 11/16/2015
1.0.0.458-rc 881 11/3/2015
1.0.0.448-rc 833 10/27/2015
1.0.0.447-rc 824 10/27/2015
1.0.0.446-rc 848 10/27/2015
1.0.0.443-rc 832 10/27/2015
1.0.0.441-rc 832 10/26/2015
1.0.0.436-rc 833 10/26/2015
1.0.0.434-rc 843 10/26/2015
1.0.0.433-rc 805 10/26/2015
0.9.1.426 1,364 10/8/2015
0.9.1.424 1,450 10/6/2015
0.9.1.418 1,250 9/29/2015
0.9.1.415 1,229 9/29/2015
0.9.1.411 1,218 9/28/2015
0.9.1.408 1,165 9/3/2015
0.9.1.407 1,125 8/18/2015
0.9.1.406 1,627 8/13/2015
0.9.1.405 1,227 8/13/2015
0.9.1.404 1,332 8/13/2015
0.9.1.401 1,416 7/21/2015
0.9.1.395 1,199 7/5/2015
0.9.1.394 1,127 7/4/2015
0.9.1.393 1,186 7/4/2015
0.9.1.390 1,120 6/13/2015
0.9.1.388 1,127 6/13/2015
0.9.1.386 1,107 6/13/2015
0.9.1.385 1,107 6/12/2015
0.9.1.382 1,110 6/12/2015
0.9.1.381 1,095 6/12/2015
0.9.1.380 1,112 6/12/2015
0.9.1.378 1,098 6/12/2015
0.9.1.375 1,400 2/27/2015
0.9.1.373 1,615 2/25/2015
0.9.1.370 1,310 2/25/2015
0.9.1.367 1,520 2/23/2015
0.9.1.365 1,575 2/21/2015
0.9.1.361 1,521 2/21/2015
0.9.1.358 1,442 2/16/2015
0.9.1.357 1,282 2/11/2015
0.9.0.355 1,220 2/10/2015
0.9.0.354 1,143 2/1/2015
0.9.0.353 1,101 1/30/2015

- 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