Shaolinq.SqlServer 0.9.1.405

.NET Framework 4.0 This package targets .NET Framework 4.0. The package is compatible with this framework or higher.
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.405                

                    
                

            
NuGet\Install-Package Shaolinq.SqlServer -Version 0.9.1.405
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.405" />
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.405                

                    
                

            
#r "nuget: Shaolinq.SqlServer, 0.9.1.405"
#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.405

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

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 366 10/1/2020
1.9.5.1476-refs-pull-109-head 311 10/1/2020
1.9.5.1475-refs-pull-100-merge 333 9/30/2020
1.9.5.1474-refs-pull-104-merge 333 9/30/2020
1.9.5.1471-refs-pull-108-merge 357 9/30/2020
1.9.5.1470-refs-pull-108-merge 381 9/30/2020
1.9.5.1469-refs-pull-108-head 376 9/30/2020
1.9.5.1468-refs-pull-107-merge 391 9/30/2020
1.9.5.1467-refs-pull-107-head 398 9/30/2020
1.9.5.1466-refs-pull-106-merge 386 9/30/2020
1.9.5.1465-refs-pull-106-head 374 9/30/2020
1.9.5.1464-refs-pull-105-merge 421 9/30/2020
1.9.5.1462-refs-pull-104-merge 445 9/30/2020
1.9.5.1460-refs-pull-100-merge 393 4/1/2020
1.9.5 1,171 1/17/2020
1.9.4.1454-refs-pull-97-merge 451 9/18/2019
1.9.4.1453-refs-pull-97-head 440 9/18/2019
1.9.4.1452-refs-pull-96-merge 424 9/18/2019
1.9.4.1451-refs-pull-96-head 431 9/18/2019
1.9.4.1450-refs-pull-95-merge 457 9/18/2019
1.9.4.1449-refs-pull-95-head 434 9/18/2019
1.9.4 975 11/9/2018
1.9.3.1445-fix-null-enum-bug 601 11/9/2018
1.9.3 793 11/9/2018
1.9.1.1438-feature-allow-re... 613 10/23/2018
1.9.1 869 10/23/2018
1.9.0.1437-feature-model-ge... 612 10/21/2018
1.9.0.1435-fix-query-cachin... 637 10/18/2018
1.9.0 880 10/18/2018
1.8.15 860 10/17/2018
1.8.14.1433-fix-nested-quer... 608 10/17/2018
1.8.14 858 10/16/2018
1.8.13.1429-fix-fix-nested-... 620 10/15/2018
1.8.13 869 10/15/2018
1.8.12 891 10/2/2018
1.8.11.1420-feature-allow-i... 649 10/2/2018
1.8.11.1419-feature-allow-i... 614 10/1/2018
1.8.11.1418-feature-allow-i... 649 10/1/2018
1.8.11 905 9/25/2018
1.8.10.1416-fix-distinct-co... 653 9/25/2018
1.8.10 1,025 8/16/2018
1.8.9 1,013 8/16/2018
1.8.8.1409-feature-sqlserve... 720 8/13/2018
1.8.8 953 8/10/2018
1.8.7.1404-fix-sql-index-an... 724 8/10/2018
1.8.7 951 8/10/2018
1.8.6 994 8/8/2018
1.8.4.1394-feature-exclude-... 696 8/7/2018
1.8.4 912 8/7/2018
1.8.3.1391-feature-unique-i... 673 8/7/2018
1.8.3 931 8/6/2018
1.8.2.1387-fix-support-over... 684 8/6/2018
1.8.2 951 8/2/2018
1.8.1.1384-fix-computed-mem... 678 8/1/2018
1.8.1.1383-fix-computed-mem... 692 8/1/2018
1.8.1 989 7/29/2018
1.8.0 910 7/28/2018
1.7.2 895 7/23/2018
1.7.1 889 7/22/2018
1.7.0.1340-feature-support-... 723 7/22/2018
1.7.0.1338-feature-support-... 702 7/22/2018
1.7.0 921 7/22/2018
1.6.0.1329-feature-naming-t... 711 7/21/2018
1.5.0.1304 942 7/20/2018
1.5.0.1303-feature-class-le... 673 7/20/2018
1.5.0.1300 967 6/4/2018
1.5.0.1296-fix-datacontext-... 921 5/6/2018
1.5.0.1295 1,085 4/26/2018
1.5.0.1294 1,055 4/26/2018
1.5.0.1285 990 2/6/2018
1.5.0.1285-asynchooks-test 841 2/6/2018
1.5.0.1280-asynchooks-test 822 2/5/2018
1.3.1.1240 1,112 1/23/2018
1.3.1.1208 1,095 1/17/2018
1.3.1.1207 1,080 1/8/2018
1.3.1.1206 1,083 1/8/2018
1.3.1.1204 1,006 1/3/2018
1.3.1.1198 1,079 12/21/2017
1.3.1.1195 1,013 12/1/2017
1.3.1.1194 959 12/1/2017
1.3.1.1193 887 12/1/2017
1.3.1.1171 1,026 10/17/2017
1.3.1.1163 1,070 7/5/2017
1.3.1.1160 1,010 6/21/2017
1.3.1.1159 997 6/21/2017
1.3.1.1155 1,001 6/20/2017
1.3.1.1153 1,000 6/19/2017
1.3.1.1151 1,015 6/16/2017
1.3.1.1148 1,006 6/15/2017
1.3.0.1144 1,008 6/12/2017
1.3.0.1141 1,037 6/9/2017
1.3.0.1137 1,050 5/12/2017
1.3.0.1135 1,041 5/11/2017
1.3.0.1134 1,077 5/11/2017
1.3.0.1131 1,066 5/6/2017
1.3.0.1130 1,066 5/6/2017
1.3.0.1129 1,027 5/5/2017
1.3.0.1128 995 5/5/2017
1.2.0.1118 1,002 5/4/2017
1.2.0.1116 1,071 5/4/2017
1.2.0.1114 1,018 5/4/2017
1.2.0.1112 1,013 5/4/2017
1.2.0.1111 1,063 5/3/2017
1.2.0.1107 1,017 5/2/2017
1.2.0.1104 1,047 4/29/2017
1.2.0.1103 1,044 4/28/2017
1.2.0.1101 996 4/28/2017
1.2.0.1095 1,024 4/27/2017
1.2.0.1092 1,016 4/18/2017
1.2.0.1088 1,006 4/17/2017
1.2.0.1087 1,042 4/17/2017
1.2.0.1086 1,009 4/17/2017
1.2.0.1085 1,002 4/17/2017
1.2.0.1084 1,004 4/17/2017
1.2.0.1072-rc1 815 4/14/2017
1.2.0.1071-rc1 779 4/14/2017
1.2.0.1064-rc1 781 4/1/2017
1.2.0.1061-rc1 769 3/31/2017
1.2.0.1059-rc1 793 3/29/2017
1.2.0.1057-rc1 823 3/28/2017
1.2.0.1055-rc1 763 3/28/2017
1.1.1.1044 1,057 3/24/2017
1.1.1.1040 1,025 3/19/2017
1.1.1.1004 1,048 3/10/2017
1.1.1.1002 1,011 3/9/2017
1.1.1.1000 1,120 2/1/2017
1.1.1.998 1,044 1/31/2017
1.1.1.996 1,175 12/15/2016
1.1.1.991 1,106 11/28/2016
1.1.1.989 1,223 9/22/2016
1.1.1.987 1,474 9/22/2016
1.1.1.986 1,438 9/22/2016
1.1.1.985 1,486 9/22/2016
1.1.1.982 1,095 8/24/2016
1.1.1.980 1,063 8/24/2016
1.1.1.979 1,048 8/22/2016
1.1.0.975 1,045 8/22/2016
1.1.0.973 1,029 8/22/2016
1.1.0.972 1,041 8/22/2016
1.1.0.971 1,025 8/18/2016
1.1.0.970 1,029 8/16/2016
1.1.0.967 1,060 8/15/2016
1.1.0.966 1,079 8/15/2016
1.1.0.964 1,037 8/11/2016
1.1.0.963 1,079 8/9/2016
1.1.0.961 1,088 8/9/2016
1.1.0.960 1,057 8/9/2016
1.1.0.959 1,040 8/8/2016
1.1.0.957 1,054 8/7/2016
1.1.0.956 1,074 8/7/2016
1.1.0.947-rc 827 8/6/2016
1.1.0.946-rc 836 8/5/2016
1.1.0.945 1,095 8/5/2016
1.1.0.942 1,243 7/27/2016
1.1.0.941 1,233 7/27/2016
1.1.0.939 1,194 7/27/2016
1.1.0.938 1,226 7/27/2016
1.1.0.936 1,377 7/26/2016
1.1.0.935 1,081 7/26/2016
1.1.0.932 1,063 7/25/2016
1.1.0.930 1,054 7/23/2016
1.1.0.929 1,081 7/23/2016
1.1.0.928 1,082 7/22/2016
1.1.0.927 1,089 7/22/2016
1.1.0.924 1,171 7/22/2016
1.1.0.923 1,064 7/21/2016
1.1.0.918 1,026 7/20/2016
1.1.0.915 1,031 7/20/2016
1.1.0.912 1,049 7/20/2016
1.1.0.910 1,071 7/20/2016
1.1.0.904 1,108 7/19/2016
1.1.0.903 1,023 7/18/2016
1.1.0.902 996 7/18/2016
1.1.0.901 1,064 7/18/2016
1.1.0.887 1,099 7/16/2016
1.1.0.886 1,100 7/16/2016
1.1.0.883 1,196 7/14/2016
1.1.0.879 1,221 7/13/2016
1.1.0.877 1,172 7/12/2016
1.1.0.864 1,100 7/9/2016
1.1.0.863 1,073 7/9/2016
1.1.0.859 1,115 7/8/2016
1.1.0.858 1,022 7/8/2016
1.1.0.857 1,083 7/6/2016
1.1.0.856 1,044 6/29/2016
1.1.0.855 1,027 6/28/2016
1.1.0.854 1,030 6/25/2016
1.0.1.851-rc 1,199 6/17/2016
1.0.1.849-rc 1,165 6/17/2016
1.0.1.842-rc 946 6/9/2016
1.0.1.841-rc 999 6/9/2016
1.0.1.839-rc 1,048 6/9/2016
1.0.1.837-rc 942 5/31/2016
1.0.1.835-rc 871 5/26/2016
1.0.1.834-rc 849 5/24/2016
1.0.1.833-rc 843 5/20/2016
1.0.1.832-rc 850 5/20/2016
1.0.1.828-rc 823 5/9/2016
1.0.1.827-rc 852 5/7/2016
1.0.1.826-rc 843 5/2/2016
1.0.1.824-rc 902 5/1/2016
1.0.1.823-rc 969 4/21/2016
1.0.1.822-rc 825 4/20/2016
1.0.1.821-rc 839 4/11/2016
1.0.1.819-rc 885 4/11/2016
1.0.1.818-rc 836 4/8/2016
1.0.1.817-rc 843 4/7/2016
1.0.1.813-rc 830 4/7/2016
1.0.1.812-rc 856 3/30/2016
1.0.1.811-rc 856 3/30/2016
1.0.1.810-rc 809 3/30/2016
1.0.1.808-rc 823 3/30/2016
1.0.1.807-rc 839 3/29/2016
1.0.1.806-rc 816 3/29/2016
1.0.1.805-rc 847 3/29/2016
1.0.1.796-rc 852 3/27/2016
1.0.1.793-rc 870 3/27/2016
1.0.1.788-rc 848 3/26/2016
1.0.1.785-rc 829 3/26/2016
1.0.1.778-rc 847 3/22/2016
1.0.1.777-rc 1,078 3/22/2016
1.0.1.776-rc 826 3/18/2016
1.0.1.775-rc 862 3/18/2016
1.0.1.774-rc 842 3/16/2016
1.0.1.773-rc 844 3/16/2016
1.0.1.771-rc 799 3/15/2016
1.0.1.769-rc 839 3/15/2016
1.0.1.765-rc 806 3/15/2016
1.0.1.764-rc 825 3/15/2016
1.0.1.759-rc 861 3/14/2016
1.0.1.758-rc 838 3/14/2016
1.0.1.757-rc 806 3/14/2016
1.0.1.752-rc 837 3/13/2016
1.0.1.748-rc 929 3/13/2016
1.0.1.747-rc 935 3/13/2016
1.0.1.746-rc 943 3/13/2016
1.0.1.743-rc 815 3/9/2016
1.0.1.742-rc 819 3/8/2016
1.0.1.741-rc 825 3/8/2016
1.0.1.740-rc 868 3/7/2016
1.0.1.736-rc 833 3/7/2016
1.0.1.735-rc 866 3/7/2016
1.0.1.729-rc 832 3/6/2016
1.0.1.728-rc 795 3/6/2016
1.0.1.726-rc 829 3/6/2016
1.0.1.724-rc 888 3/4/2016
1.0.1.723-rc 865 3/3/2016
1.0.1.722-rc 808 3/3/2016
1.0.1.721-rc 843 3/3/2016
1.0.1.719-rc 843 3/2/2016
1.0.1.717-rc 869 3/1/2016
1.0.1.716-rc 1,128 2/28/2016
1.0.1.711-rc 1,241 2/28/2016
1.0.1.709-rc 1,160 2/27/2016
1.0.1.708-rc 1,016 2/27/2016
1.0.1.707-rc 972 2/27/2016
1.0.1.706-rc 1,176 2/26/2016
1.0.1.705-rc 1,072 2/26/2016
1.0.1.701-rc 1,060 2/25/2016
1.0.1.699-rc 867 2/23/2016
1.0.1.696-rc 904 2/21/2016
1.0.1.693-rc 961 2/20/2016
1.0.1.691-rc 879 2/19/2016
1.0.1.689-rc 844 2/19/2016
1.0.1.684-rc 894 2/18/2016
1.0.1.683-rc 837 2/18/2016
1.0.1.676-rc 846 2/17/2016
1.0.1.673-rc 854 2/17/2016
1.0.1.670-rc 867 2/17/2016
1.0.1.665-rc 878 2/15/2016
1.0.1.663-rc 857 2/14/2016
1.0.1.659-rc 837 2/14/2016
1.0.1.657-rc 858 2/14/2016
1.0.1.654-rc 1,004 2/14/2016
1.0.1.648-rc 990 2/13/2016
1.0.1.647-rc 845 2/13/2016
1.0.1.632-rc 832 2/11/2016
1.0.1.631-rc 835 2/11/2016
1.0.1.626-rc 802 2/10/2016
1.0.1.625-rc 847 2/10/2016
1.0.1.609-rc 854 2/4/2016
1.0.1.605-rc 809 2/4/2016
1.0.1.604-rc 851 2/4/2016
1.0.1.600-rc 815 1/28/2016
1.0.1.597-rc 810 1/27/2016
1.0.1.596-rc 872 1/26/2016
1.0.1.595-rc 866 1/22/2016
1.0.1.593-rc 816 1/22/2016
1.0.1.590-rc 827 1/21/2016
1.0.1.588-rc 852 1/20/2016
1.0.1.583-rc 832 1/20/2016
1.0.1.582-rc 838 1/20/2016
1.0.1.574-rc 826 1/19/2016
1.0.1.571-rc 846 1/19/2016
1.0.1.570-rc 858 1/18/2016
1.0.1.569-rc 836 1/17/2016
1.0.1.568-rc 1,153 1/15/2016
1.0.1.565-rc 869 1/8/2016
1.0.1.564-rc 861 1/8/2016
1.0.1.561-rc 852 1/6/2016
1.0.1.557-rc 855 1/3/2016
1.0.1.554-rc 957 12/22/2015
1.0.1.553-rc 934 12/22/2015
1.0.1.552-rc 961 12/22/2015
1.0.1.551-rc 791 12/21/2015
1.0.1.550-rc 833 12/20/2015
1.0.1.545-rc 841 12/17/2015
1.0.1.543-rc 828 12/17/2015
1.0.1.542-rc 833 12/16/2015
1.0.1.539-rc 841 12/16/2015
1.0.1.525-rc 876 12/16/2015
1.0.1.521-rc 867 12/15/2015
1.0.1.512-rc 852 12/14/2015
1.0.1.508-rc 807 12/14/2015
1.0.1.505-rc 855 12/14/2015
1.0.0.492-rc 949 12/11/2015
1.0.0.491-rc 957 12/11/2015
1.0.0.488-rc 971 12/11/2015
1.0.0.487-rc 950 12/11/2015
1.0.0.485-rc 877 12/9/2015
1.0.0.481-rc 821 12/8/2015
1.0.0.479-rc 844 12/7/2015
1.0.0.473-rc 834 12/6/2015
1.0.0.472-rc 1,254 12/3/2015
1.0.0.469-rc 1,203 12/1/2015
1.0.0.465-rc 923 11/19/2015
1.0.0.464-rc 929 11/16/2015
1.0.0.458-rc 906 11/3/2015
1.0.0.448-rc 859 10/27/2015
1.0.0.447-rc 844 10/27/2015
1.0.0.446-rc 868 10/27/2015
1.0.0.443-rc 853 10/27/2015
1.0.0.441-rc 856 10/26/2015
1.0.0.436-rc 854 10/26/2015
1.0.0.434-rc 865 10/26/2015
1.0.0.433-rc 829 10/26/2015
0.9.1.426 1,386 10/8/2015
0.9.1.424 1,472 10/6/2015
0.9.1.418 1,274 9/29/2015
0.9.1.415 1,256 9/29/2015
0.9.1.411 1,240 9/28/2015
0.9.1.408 1,186 9/3/2015
0.9.1.407 1,148 8/18/2015
0.9.1.406 1,656 8/13/2015
0.9.1.405 1,253 8/13/2015
0.9.1.404 1,359 8/13/2015
0.9.1.401 1,437 7/21/2015
0.9.1.395 1,222 7/5/2015
0.9.1.394 1,149 7/4/2015
0.9.1.393 1,210 7/4/2015
0.9.1.390 1,143 6/13/2015
0.9.1.388 1,156 6/13/2015
0.9.1.386 1,127 6/13/2015
0.9.1.385 1,131 6/12/2015
0.9.1.382 1,134 6/12/2015
0.9.1.381 1,119 6/12/2015
0.9.1.380 1,136 6/12/2015
0.9.1.378 1,119 6/12/2015
0.9.1.375 1,421 2/27/2015
0.9.1.373 1,638 2/25/2015
0.9.1.370 1,334 2/25/2015
0.9.1.367 1,545 2/23/2015
0.9.1.365 1,599 2/21/2015
0.9.1.361 1,547 2/21/2015
0.9.1.358 1,464 2/16/2015
0.9.1.357 1,305 2/11/2015
0.9.0.355 1,228 2/10/2015
0.9.0.354 1,166 2/1/2015
0.9.0.353 1,125 1/30/2015

- Allow direct configuration with connection strings
Previous Versions:
- Fixed sometimes queries failing if referencing a primary key on a DAO property
- Fixed Any function sometimes not working
- Allow DAO types to be defined in other assemblies
- SQL server provider now always disables enlistment
- Switch to using ConfigurationManager for configs
- 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
- 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