Shaolinq.SqlServer 1.8.7.1404-fix-sql-index-ansi-c

This is a prerelease version of Shaolinq.SqlServer.
There is a newer version of this package available.
See the version list below for details.
dotnet add package Shaolinq.SqlServer --version 1.8.7.1404-fix-sql-index-ansi-c
                    
NuGet\Install-Package Shaolinq.SqlServer -Version 1.8.7.1404-fix-sql-index-ansi-c
                    
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="1.8.7.1404-fix-sql-index-ansi-c" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Shaolinq.SqlServer" Version="1.8.7.1404-fix-sql-index-ansi-c" />
                    
Directory.Packages.props
<PackageReference Include="Shaolinq.SqlServer" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Shaolinq.SqlServer --version 1.8.7.1404-fix-sql-index-ansi-c
                    
#r "nuget: Shaolinq.SqlServer, 1.8.7.1404-fix-sql-index-ansi-c"
                    
#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.
#:package Shaolinq.SqlServer@1.8.7.1404-fix-sql-index-ansi-c
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Shaolinq.SqlServer&version=1.8.7.1404-fix-sql-index-ansi-c&prerelease
                    
Install as a Cake Addin
#tool nuget:?package=Shaolinq.SqlServer&version=1.8.7.1404-fix-sql-index-ansi-c&prerelease
                    
Install as a Cake Tool

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 net452 is compatible.  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.
    • Shaolinq (>= 1.8.7.1404-fix-sql-index-ansi-c)

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 559 10/1/2020
1.9.5.1476-refs-pull-109-head 464 10/1/2020
1.9.5.1475-refs-pull-100-merge 478 9/30/2020
1.9.5.1474-refs-pull-104-merge 494 9/30/2020
1.9.5.1471-refs-pull-108-merge 528 9/30/2020
1.9.5.1470-refs-pull-108-merge 543 9/30/2020
1.9.5.1469-refs-pull-108-head 522 9/30/2020
1.9.5.1468-refs-pull-107-merge 539 9/30/2020
1.9.5.1467-refs-pull-107-head 546 9/30/2020
1.9.5.1466-refs-pull-106-merge 534 9/30/2020
1.9.5.1465-refs-pull-106-head 521 9/30/2020
1.9.5.1464-refs-pull-105-merge 556 9/30/2020
1.9.5.1462-refs-pull-104-merge 581 9/30/2020
1.9.5.1460-refs-pull-100-merge 561 4/1/2020
1.9.5 1,394 1/17/2020
1.9.4.1454-refs-pull-97-merge 611 9/18/2019
1.9.4.1453-refs-pull-97-head 598 9/18/2019
1.9.4.1452-refs-pull-96-merge 572 9/18/2019
1.9.4.1451-refs-pull-96-head 589 9/18/2019
1.9.4.1450-refs-pull-95-merge 631 9/18/2019
1.9.4.1449-refs-pull-95-head 591 9/18/2019
1.9.4 1,164 11/9/2018
1.9.3.1445-fix-null-enum-bug 782 11/9/2018
1.9.3 981 11/9/2018
1.9.1.1438-feature-allow-re... 820 10/23/2018
1.9.1 1,060 10/23/2018
1.9.0.1437-feature-model-ge... 797 10/21/2018
1.9.0.1435-fix-query-cachin... 818 10/18/2018
1.9.0 1,069 10/18/2018
1.8.15 1,051 10/17/2018
1.8.14.1433-fix-nested-quer... 821 10/17/2018
1.8.14 1,069 10/16/2018
1.8.13.1429-fix-fix-nested-... 801 10/15/2018
1.8.13 1,057 10/15/2018
1.8.12 1,083 10/2/2018
1.8.11.1420-feature-allow-i... 837 10/2/2018
1.8.11.1419-feature-allow-i... 800 10/1/2018
1.8.11.1418-feature-allow-i... 836 10/1/2018
1.8.11 1,120 9/25/2018
1.8.10.1416-fix-distinct-co... 841 9/25/2018
1.8.10 1,244 8/16/2018
1.8.9 1,245 8/16/2018
1.8.8.1409-feature-sqlserve... 939 8/13/2018
1.8.8 1,172 8/10/2018
1.8.7.1404-fix-sql-index-an... 914 8/10/2018
1.8.7 1,151 8/10/2018
1.8.6 1,193 8/8/2018
1.8.4.1394-feature-exclude-... 1,010 8/7/2018
1.8.4 1,224 8/7/2018
1.8.3.1391-feature-unique-i... 971 8/7/2018
1.8.3 1,258 8/6/2018
1.8.2.1387-fix-support-over... 1,003 8/6/2018
1.8.2 1,264 8/2/2018
1.8.1.1384-fix-computed-mem... 984 8/1/2018
1.8.1.1383-fix-computed-mem... 990 8/1/2018
1.8.1 1,316 7/29/2018
1.8.0 1,214 7/28/2018
1.7.2 1,222 7/23/2018
1.7.1 1,195 7/22/2018
1.7.0.1340-feature-support-... 1,033 7/22/2018
1.7.0.1338-feature-support-... 1,022 7/22/2018
1.7.0 1,227 7/22/2018
1.6.0.1329-feature-naming-t... 1,034 7/21/2018
1.5.0.1304 1,272 7/20/2018
1.5.0.1303-feature-class-le... 971 7/20/2018
1.5.0.1300 1,291 6/4/2018
1.5.0.1296-fix-datacontext-... 1,392 5/6/2018
1.5.0.1295 1,541 4/26/2018
1.5.0.1294 1,517 4/26/2018
1.5.0.1285 1,306 2/6/2018
1.5.0.1285-asynchooks-test 1,310 2/6/2018
1.5.0.1280-asynchooks-test 1,275 2/5/2018
1.3.1.1240 1,588 1/23/2018
1.3.1.1208 1,560 1/17/2018
1.3.1.1207 1,571 1/8/2018
1.3.1.1206 1,546 1/8/2018
1.3.1.1204 1,341 1/3/2018
1.3.1.1198 1,545 12/21/2017
1.3.1.1195 1,331 12/1/2017
1.3.1.1194 1,287 12/1/2017
1.3.1.1193 1,206 12/1/2017
1.3.1.1171 1,344 10/17/2017
1.3.1.1163 1,393 7/5/2017
1.3.1.1160 1,334 6/21/2017
1.3.1.1159 1,330 6/21/2017
1.3.1.1155 1,332 6/20/2017
1.3.1.1153 1,319 6/19/2017
1.3.1.1151 1,334 6/16/2017
1.3.1.1148 1,345 6/15/2017
1.3.0.1144 1,327 6/12/2017
1.3.0.1141 1,375 6/9/2017
1.3.0.1137 1,373 5/12/2017
1.3.0.1135 1,382 5/11/2017
1.3.0.1134 1,400 5/11/2017
1.3.0.1131 1,387 5/6/2017
1.3.0.1130 1,401 5/6/2017
1.3.0.1129 1,367 5/5/2017
1.3.0.1128 1,314 5/5/2017
1.2.0.1118 1,339 5/4/2017
1.2.0.1116 1,393 5/4/2017
1.2.0.1114 1,340 5/4/2017
1.2.0.1112 1,333 5/4/2017
1.2.0.1111 1,382 5/3/2017
1.2.0.1107 1,324 5/2/2017
1.2.0.1104 1,368 4/29/2017
1.2.0.1103 1,388 4/28/2017
1.2.0.1101 1,332 4/28/2017
1.2.0.1095 1,360 4/27/2017
1.2.0.1092 1,337 4/18/2017
1.2.0.1088 1,342 4/17/2017
1.2.0.1087 1,386 4/17/2017
1.2.0.1086 1,332 4/17/2017
1.2.0.1085 1,312 4/17/2017
1.2.0.1084 1,324 4/17/2017
1.2.0.1072-rc1 1,129 4/14/2017
1.2.0.1071-rc1 1,103 4/14/2017
1.2.0.1064-rc1 1,097 4/1/2017
1.2.0.1061-rc1 1,108 3/31/2017
1.2.0.1059-rc1 1,096 3/29/2017
1.2.0.1057-rc1 1,144 3/28/2017
1.2.0.1055-rc1 1,070 3/28/2017
1.1.1.1044 1,379 3/24/2017
1.1.1.1040 1,340 3/19/2017
1.1.1.1004 1,371 3/10/2017
1.1.1.1002 1,356 3/9/2017
1.1.1.1000 1,439 2/1/2017
1.1.1.998 1,369 1/31/2017
1.1.1.996 1,506 12/15/2016
1.1.1.991 1,456 11/28/2016
1.1.1.989 1,549 9/22/2016
1.1.1.987 1,797 9/22/2016
1.1.1.986 1,750 9/22/2016
1.1.1.985 1,827 9/22/2016
1.1.1.982 1,439 8/24/2016
1.1.1.980 1,418 8/24/2016
1.1.1.979 1,385 8/22/2016
1.1.0.975 1,402 8/22/2016
1.1.0.973 1,385 8/22/2016
1.1.0.972 1,372 8/22/2016
1.1.0.971 1,350 8/18/2016
1.1.0.970 1,362 8/16/2016
1.1.0.967 1,390 8/15/2016
1.1.0.966 1,416 8/15/2016
1.1.0.964 1,392 8/11/2016
1.1.0.963 1,407 8/9/2016
1.1.0.961 1,420 8/9/2016
1.1.0.960 1,385 8/9/2016
1.1.0.959 1,392 8/8/2016
1.1.0.957 1,381 8/7/2016
1.1.0.956 1,414 8/7/2016
1.1.0.947-rc 1,149 8/6/2016
1.1.0.946-rc 1,178 8/5/2016
1.1.0.945 1,422 8/5/2016
1.1.0.942 1,573 7/27/2016
1.1.0.941 1,559 7/27/2016
1.1.0.939 1,551 7/27/2016
1.1.0.938 1,566 7/27/2016
1.1.0.936 1,723 7/26/2016
1.1.0.935 1,414 7/26/2016
1.1.0.932 1,391 7/25/2016
1.1.0.930 1,404 7/23/2016
1.1.0.929 1,429 7/23/2016
1.1.0.928 1,412 7/22/2016
1.1.0.927 1,425 7/22/2016
1.1.0.924 1,500 7/22/2016
1.1.0.923 1,393 7/21/2016
1.1.0.918 1,368 7/20/2016
1.1.0.915 1,382 7/20/2016
1.1.0.912 1,376 7/20/2016
1.1.0.910 1,419 7/20/2016
1.1.0.904 1,443 7/19/2016
1.1.0.903 1,369 7/18/2016
1.1.0.902 1,329 7/18/2016
1.1.0.901 1,392 7/18/2016
1.1.0.887 1,425 7/16/2016
1.1.0.886 1,428 7/16/2016
1.1.0.883 1,542 7/14/2016
1.1.0.879 1,545 7/13/2016
1.1.0.877 1,503 7/12/2016
1.1.0.864 1,440 7/9/2016
1.1.0.863 1,405 7/9/2016
1.1.0.859 1,441 7/8/2016
1.1.0.858 1,350 7/8/2016
1.1.0.857 1,407 7/6/2016
1.1.0.856 1,396 6/29/2016
1.1.0.855 1,357 6/28/2016
1.1.0.854 1,360 6/25/2016
1.0.1.851-rc 1,526 6/17/2016
1.0.1.849-rc 1,493 6/17/2016
1.0.1.842-rc 1,270 6/9/2016
1.0.1.841-rc 1,324 6/9/2016
1.0.1.839-rc 1,370 6/9/2016
1.0.1.837-rc 1,268 5/31/2016
1.0.1.835-rc 1,211 5/26/2016
1.0.1.834-rc 1,179 5/24/2016
1.0.1.833-rc 1,171 5/20/2016
1.0.1.832-rc 1,174 5/20/2016
1.0.1.828-rc 1,145 5/9/2016
1.0.1.827-rc 1,178 5/7/2016
1.0.1.826-rc 1,170 5/2/2016
1.0.1.824-rc 1,249 5/1/2016
1.0.1.823-rc 1,290 4/21/2016
1.0.1.822-rc 1,163 4/20/2016
1.0.1.821-rc 1,187 4/11/2016
1.0.1.819-rc 1,209 4/11/2016
1.0.1.818-rc 1,165 4/8/2016
1.0.1.817-rc 1,165 4/7/2016
1.0.1.813-rc 1,178 4/7/2016
1.0.1.812-rc 1,184 3/30/2016
1.0.1.811-rc 1,183 3/30/2016
1.0.1.810-rc 1,136 3/30/2016
1.0.1.808-rc 1,149 3/30/2016
1.0.1.807-rc 1,189 3/29/2016
1.0.1.806-rc 1,142 3/29/2016
1.0.1.805-rc 1,172 3/29/2016
1.0.1.796-rc 1,184 3/27/2016
1.0.1.793-rc 1,203 3/27/2016
1.0.1.788-rc 1,177 3/26/2016
1.0.1.785-rc 1,152 3/26/2016
1.0.1.778-rc 1,177 3/22/2016
1.0.1.777-rc 1,410 3/22/2016
1.0.1.776-rc 1,152 3/18/2016
1.0.1.775-rc 1,211 3/18/2016
1.0.1.774-rc 1,174 3/16/2016
1.0.1.773-rc 1,159 3/16/2016
1.0.1.771-rc 1,124 3/15/2016
1.0.1.769-rc 1,164 3/15/2016
1.0.1.765-rc 1,135 3/15/2016
1.0.1.764-rc 1,176 3/15/2016
1.0.1.759-rc 1,186 3/14/2016
1.0.1.758-rc 1,182 3/14/2016
1.0.1.757-rc 1,152 3/14/2016
1.0.1.752-rc 1,162 3/13/2016
1.0.1.748-rc 1,414 3/13/2016
1.0.1.747-rc 1,437 3/13/2016
1.0.1.746-rc 1,468 3/13/2016
1.0.1.743-rc 1,166 3/9/2016
1.0.1.742-rc 1,171 3/8/2016
1.0.1.741-rc 1,165 3/8/2016
1.0.1.740-rc 1,196 3/7/2016
1.0.1.736-rc 1,154 3/7/2016
1.0.1.735-rc 1,196 3/7/2016
1.0.1.729-rc 1,183 3/6/2016
1.0.1.728-rc 1,139 3/6/2016
1.0.1.726-rc 1,174 3/6/2016
1.0.1.724-rc 1,218 3/4/2016
1.0.1.723-rc 1,214 3/3/2016
1.0.1.722-rc 1,149 3/3/2016
1.0.1.721-rc 1,180 3/3/2016
1.0.1.719-rc 1,168 3/2/2016
1.0.1.717-rc 1,217 3/1/2016
1.0.1.716-rc 1,450 2/28/2016
1.0.1.711-rc 1,587 2/28/2016
1.0.1.709-rc 1,499 2/27/2016
1.0.1.708-rc 1,352 2/27/2016
1.0.1.707-rc 1,296 2/27/2016
1.0.1.706-rc 1,517 2/26/2016
1.0.1.705-rc 1,407 2/26/2016
1.0.1.701-rc 1,401 2/25/2016
1.0.1.699-rc 1,192 2/23/2016
1.0.1.696-rc 1,234 2/21/2016
1.0.1.693-rc 1,312 2/20/2016
1.0.1.691-rc 1,221 2/19/2016
1.0.1.689-rc 1,169 2/19/2016
1.0.1.684-rc 1,220 2/18/2016
1.0.1.683-rc 1,166 2/18/2016
1.0.1.676-rc 1,194 2/17/2016
1.0.1.673-rc 1,204 2/17/2016
1.0.1.670-rc 1,198 2/17/2016
1.0.1.665-rc 1,205 2/15/2016
1.0.1.663-rc 1,180 2/14/2016
1.0.1.659-rc 1,164 2/14/2016
1.0.1.657-rc 1,205 2/14/2016
1.0.1.654-rc 1,481 2/14/2016
1.0.1.648-rc 1,465 2/13/2016
1.0.1.647-rc 1,179 2/13/2016
1.0.1.632-rc 1,156 2/11/2016
1.0.1.631-rc 1,171 2/11/2016
1.0.1.626-rc 1,126 2/10/2016
1.0.1.625-rc 1,191 2/10/2016
1.0.1.609-rc 1,209 2/4/2016
1.0.1.605-rc 1,136 2/4/2016
1.0.1.604-rc 1,196 2/4/2016
1.0.1.600-rc 1,142 1/28/2016
1.0.1.597-rc 1,144 1/27/2016
1.0.1.596-rc 1,196 1/26/2016
1.0.1.595-rc 1,176 1/22/2016
1.0.1.593-rc 1,143 1/22/2016
1.0.1.590-rc 1,155 1/21/2016
1.0.1.588-rc 1,192 1/20/2016
1.0.1.583-rc 1,166 1/20/2016
1.0.1.582-rc 1,162 1/20/2016
1.0.1.574-rc 1,153 1/19/2016
1.0.1.571-rc 1,167 1/19/2016
1.0.1.570-rc 1,194 1/18/2016
1.0.1.569-rc 1,162 1/17/2016
1.0.1.568-rc 1,498 1/15/2016
1.0.1.565-rc 1,211 1/8/2016
1.0.1.564-rc 1,207 1/8/2016
1.0.1.561-rc 1,180 1/6/2016
1.0.1.557-rc 1,187 1/3/2016
1.0.1.554-rc 1,453 12/22/2015
1.0.1.553-rc 1,423 12/22/2015
1.0.1.552-rc 1,448 12/22/2015
1.0.1.551-rc 1,120 12/21/2015
1.0.1.550-rc 1,164 12/20/2015
1.0.1.545-rc 1,170 12/17/2015
1.0.1.543-rc 1,161 12/17/2015
1.0.1.542-rc 1,152 12/16/2015
1.0.1.539-rc 1,185 12/16/2015
1.0.1.525-rc 1,188 12/16/2015
1.0.1.521-rc 1,220 12/15/2015
1.0.1.512-rc 1,191 12/14/2015
1.0.1.508-rc 1,168 12/14/2015
1.0.1.505-rc 1,186 12/14/2015
1.0.0.492-rc 1,421 12/11/2015
1.0.0.491-rc 1,459 12/11/2015
1.0.0.488-rc 1,479 12/11/2015
1.0.0.487-rc 1,440 12/11/2015
1.0.0.485-rc 1,216 12/9/2015
1.0.0.481-rc 1,163 12/8/2015
1.0.0.479-rc 1,170 12/7/2015
1.0.0.473-rc 1,158 12/6/2015
1.0.0.472-rc 1,577 12/3/2015
1.0.0.469-rc 1,540 12/1/2015
1.0.0.465-rc 1,253 11/19/2015
1.0.0.464-rc 1,286 11/16/2015
1.0.0.458-rc 1,252 11/3/2015
1.0.0.448-rc 1,180 10/27/2015
1.0.0.447-rc 1,155 10/27/2015
1.0.0.446-rc 1,206 10/27/2015
1.0.0.443-rc 1,190 10/27/2015
1.0.0.441-rc 1,170 10/26/2015
1.0.0.436-rc 1,181 10/26/2015
1.0.0.434-rc 1,205 10/26/2015
1.0.0.433-rc 1,149 10/26/2015
0.9.1.426 1,719 10/8/2015
0.9.1.424 1,835 10/6/2015
0.9.1.418 1,622 9/29/2015
0.9.1.415 1,608 9/29/2015
0.9.1.411 1,569 9/28/2015
0.9.1.408 1,541 9/3/2015
0.9.1.407 1,506 8/18/2015
0.9.1.406 2,148 8/13/2015
0.9.1.405 1,613 8/13/2015
0.9.1.404 1,854 8/13/2015
0.9.1.401 1,963 7/21/2015
0.9.1.395 1,552 7/5/2015
0.9.1.394 1,484 7/4/2015
0.9.1.393 1,546 7/4/2015
0.9.1.390 1,470 6/13/2015
0.9.1.388 1,475 6/13/2015
0.9.1.386 1,450 6/13/2015
0.9.1.385 1,467 6/12/2015
0.9.1.382 1,467 6/12/2015
0.9.1.381 1,452 6/12/2015
0.9.1.380 1,468 6/12/2015
0.9.1.378 1,451 6/12/2015
0.9.1.375 1,756 2/27/2015
0.9.1.373 1,992 2/25/2015
0.9.1.370 1,690 2/25/2015
0.9.1.367 1,882 2/23/2015
0.9.1.365 1,930 2/21/2015
0.9.1.361 1,880 2/21/2015
0.9.1.358 1,802 2/16/2015
0.9.1.357 1,639 2/11/2015
0.9.0.355 1,570 2/10/2015
0.9.0.354 1,488 2/1/2015
0.9.0.353 1,461 1/30/2015

# 1.8.8
- Fixed bool properties not being handled like other types when excluding a property from an index to support null-ansi-compliance.
- Ignore non-nullable columns when injecting conditions to exclude null values from a unique index in SQL server (for null-ansi-compliance).
# 1.8.7
- SQL Server provider null-ansi-compliance support whereby null values are excluded from unique indexes by means of a check for not null now excludes this check for properties that are explicitly referenced within the user-defined index condition (if a user-defined index condition is specified).
# 1.8.6
- Fixed SizeConstraintAttribute placed direectly on an enum type doesn't get inherited
by properties of that enum type if the property is nullable.
# 1.8.5
- Fixed NamingTransformsConfiguration.UniqueIndexConstraintName should default to using NamingTransformsConfiguration.IndexConstraintName before falling to default.
# 1.8.4
- Support defining naming transform for unique indexes (NamingTransformsConfiguration.UniqueIndexConstraintName).
- Added IndexNamesShouldIncludeIncludedProperties option to allow including the names of IncludeOnly properties in the name of indexes.
# 1.8.3
- Fix expressions (IndexAttribute.Condition, ComputedMember.GetExpression, ComputedMember.SetExpression) throwing exception when trying to call methods with overloads.
# 1.8.2
- Better support for parsing IndexAttribute.Condition, ComputedMemberAttribute.GetExpression, ComputedMemberAttribute.SetExpression
- Fix IndexAttribute.Condition not included in schema if index is applied at the class level
# 1.8.1
- Fix GetReference sometimes not working between different types that use the same primary key type.
# 1.8.0
- Major bug fix release
- Better support for conditions and and selects involving aggregate calls on recursively related objects projected off recursively related object collections
- Fixed some object sometimes returned multiple times if using Include() with related object collections
- Fixed sometimes less objects than expected are returned when Skip/Take is used in combination with Include() with related object collections
- General improvements to Include() support
- Added overloads to RelatedDataAccessObjects.Items() method - support loading from a new query if eager loaded items aren't available