Shaolinq.SqlServer 1.0.1.699-rc

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!

This is a prerelease version of Shaolinq.SqlServer.
There is a newer version of this package available.
See the version list below for details.
Install-Package Shaolinq.SqlServer -Version 1.0.1.699-rc
dotnet add package Shaolinq.SqlServer --version 1.0.1.699-rc
<PackageReference Include="Shaolinq.SqlServer" Version="1.0.1.699-rc" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Shaolinq.SqlServer --version 1.0.1.699-rc
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

- Support Delete and Delete(predicate) on all compatible Queryables (not just DataAccessObjects)
- Support GetReference on objects where primary key values are provided using related computed member values
- Added SumAsync, AverageAsync, MinAsync, MaxAsync methods
- Better async support when using DataAccessScope
- Better support for CompleteAsync
- Functional async support for Postgres
- Using AsyncRewriter to generate async methods
- Fixed some nested projection with GroupBy bugs
- Added DataAccessScope for async commit support
- Support Include on collections without TransactionScope
- Lots of Include collection fixes
- Support joins with multiple join conditions using anonymous types either side of join 'equals'
- Fixed memory leaks related to lambda projector cache
- Full support for using Include() on RelatedDataAccessObject properties (collections) including recursive Includes within the collection values.
-- Previous --
- Better/more-complete support for GroupJoins
- Support for SelectMany returning RelatedDataAccessObjects (Queryable) collections
- Much improved support/implementation for aggregates and DefaultIfEmpty
- Improved GroupBy and nested select/projection query support
- Support implicit joins in many more places that take selectors/predicates such as Queryable.First, Queryable.Single, Queryable.Min, Queryable.Max, Queryable.Count etc.
- Support join conditions that require implicit joins to resolve
- Support DataAccessObjects with custom primary keys (inherited from Shaolinq.DataAccessObject instead of Shaolinq.DataAccessObject{T})
- Support SelectForUpdate, WhereForUpdate on IQueryable
- Fixed deadlocks in some async calls
- Fixed inline call to a function returning IQueryable inside a query sometimes fails
- TransactionContext optimisations
- Fixed compiled projector lambda cache sometimes not caching due to a bug in SqlExpressionComparer
- Various async fixes
- Added NamingTransforms to DataAccessModelConfiguration
- Fix objects with DAO primary keys using references and anonymous types
- Better in-scope object caching performance
- DAO primary keys mostly working with tests

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.1460-refs-pull-100-merge 90 4/1/2020
1.9.5 217 1/17/2020
1.9.4.1454-refs-pull-97-merge 121 9/18/2019
1.9.4.1453-refs-pull-97-head 106 9/18/2019
1.9.4.1452-refs-pull-96-merge 106 9/18/2019
1.9.4.1451-refs-pull-96-head 108 9/18/2019
1.9.4.1450-refs-pull-95-merge 111 9/18/2019
1.9.4.1449-refs-pull-95-head 107 9/18/2019
1.9.4 337 11/9/2018
1.9.3.1445-fix-null-enum-bug 198 11/9/2018
1.9.3 200 11/9/2018
1.9.1.1438-feature-allow-re... 209 10/23/2018
1.9.1 236 10/23/2018
1.9.0.1437-feature-model-ge... 222 10/21/2018
1.9.0.1435-fix-query-cachin... 227 10/18/2018
1.9.0 248 10/18/2018
1.8.15 236 10/17/2018
1.8.14.1433-fix-nested-quer... 200 10/17/2018
1.8.14 232 10/16/2018
1.8.13.1429-fix-fix-nested-... 217 10/15/2018
1.8.13 231 10/15/2018
1.8.12 258 10/2/2018
1.8.11.1420-feature-allow-i... 216 10/2/2018
1.8.11.1419-feature-allow-i... 220 10/1/2018
1.8.11.1418-feature-allow-i... 245 10/1/2018
1.8.11 252 9/25/2018
1.8.10.1416-fix-distinct-co... 231 9/25/2018
1.8.10 287 8/16/2018
1.8.9 255 8/16/2018
1.8.8.1409-feature-sqlserve... 255 8/13/2018
1.8.8 254 8/10/2018
1.8.7.1404-fix-sql-index-an... 244 8/10/2018
1.8.7 269 8/10/2018
1.8.6 265 8/8/2018
1.8.4.1394-feature-exclude-... 268 8/7/2018
1.8.4 281 8/7/2018
1.8.3.1391-feature-unique-i... 264 8/7/2018
1.8.3 285 8/6/2018
1.8.2.1387-fix-support-over... 262 8/6/2018
1.8.2 292 8/2/2018
1.8.1.1384-fix-computed-mem... 258 8/1/2018
1.8.1.1383-fix-computed-mem... 255 8/1/2018
1.8.1 306 7/29/2018
1.8.0 281 7/28/2018
1.7.2 268 7/23/2018
1.7.1 275 7/22/2018
1.7.0.1340-feature-support-... 286 7/22/2018
1.7.0.1338-feature-support-... 260 7/22/2018
1.7.0 269 7/22/2018
1.6.0.1329-feature-naming-t... 267 7/21/2018
1.5.0.1304 270 7/20/2018
1.5.0.1303-feature-class-le... 249 7/20/2018
1.5.0.1300 319 6/4/2018
1.5.0.1296-fix-datacontext-... 433 5/6/2018
1.5.0.1295 369 4/26/2018
1.5.0.1294 337 4/26/2018
1.5.0.1285 343 2/6/2018
1.5.0.1285-asynchooks-test 373 2/6/2018
1.5.0.1280-asynchooks-test 343 2/5/2018
1.3.1.1240 388 1/23/2018
1.3.1.1208 361 1/17/2018
1.3.1.1207 370 1/8/2018
1.3.1.1206 363 1/8/2018
1.3.1.1204 331 1/3/2018
1.3.1.1198 385 12/21/2017
1.3.1.1195 331 12/1/2017
1.3.1.1194 304 12/1/2017
1.3.1.1193 305 12/1/2017
1.3.1.1171 376 10/17/2017
1.3.1.1163 421 7/5/2017
1.3.1.1160 361 6/21/2017
1.3.1.1159 335 6/21/2017
1.3.1.1155 334 6/20/2017
1.3.1.1153 368 6/19/2017
1.3.1.1151 367 6/16/2017
1.3.1.1148 376 6/15/2017
1.3.0.1144 346 6/12/2017
1.3.0.1141 382 6/9/2017
1.3.0.1137 369 5/12/2017
1.3.0.1135 376 5/11/2017
1.3.0.1134 381 5/11/2017
1.3.0.1131 392 5/6/2017
1.3.0.1130 407 5/6/2017
1.3.0.1129 361 5/5/2017
1.3.0.1128 354 5/5/2017
1.2.0.1118 368 5/4/2017
1.2.0.1116 387 5/4/2017
1.2.0.1114 368 5/4/2017
1.2.0.1112 351 5/4/2017
1.2.0.1111 391 5/3/2017
1.2.0.1107 356 5/2/2017
1.2.0.1104 368 4/29/2017
1.2.0.1103 373 4/28/2017
1.2.0.1101 368 4/28/2017
1.2.0.1095 364 4/27/2017
1.2.0.1092 354 4/18/2017
1.2.0.1088 369 4/17/2017
1.2.0.1087 391 4/17/2017
1.2.0.1086 360 4/17/2017
1.2.0.1085 367 4/17/2017
1.2.0.1084 348 4/17/2017
1.2.0.1072-rc1 367 4/14/2017
1.2.0.1071-rc1 322 4/14/2017
1.2.0.1064-rc1 329 4/1/2017
1.2.0.1061-rc1 332 3/31/2017
1.2.0.1059-rc1 341 3/29/2017
1.2.0.1057-rc1 363 3/28/2017
1.2.0.1055-rc1 319 3/28/2017
1.1.1.1044 394 3/24/2017
1.1.1.1040 385 3/19/2017
1.1.1.1004 380 3/10/2017
1.1.1.1002 364 3/9/2017
1.1.1.1000 460 2/1/2017
1.1.1.998 393 1/31/2017
1.1.1.996 481 12/15/2016
1.1.1.991 433 11/28/2016
1.1.1.989 438 9/22/2016
1.1.1.987 425 9/22/2016
1.1.1.986 374 9/22/2016
1.1.1.985 421 9/22/2016
1.1.1.982 416 8/24/2016
1.1.1.980 418 8/24/2016
1.1.1.979 414 8/22/2016
1.1.0.975 386 8/22/2016
1.1.0.973 408 8/22/2016
1.1.0.972 393 8/22/2016
1.1.0.971 384 8/18/2016
1.1.0.970 390 8/16/2016
1.1.0.967 398 8/15/2016
1.1.0.966 417 8/15/2016
1.1.0.964 392 8/11/2016
1.1.0.963 429 8/9/2016
1.1.0.961 419 8/9/2016
1.1.0.960 407 8/9/2016
1.1.0.959 397 8/8/2016
1.1.0.957 415 8/7/2016
1.1.0.956 401 8/7/2016
1.1.0.947-rc 379 8/6/2016
1.1.0.946-rc 379 8/5/2016
1.1.0.945 398 8/5/2016
1.1.0.942 447 7/27/2016
1.1.0.941 433 7/27/2016
1.1.0.939 419 7/27/2016
1.1.0.938 444 7/27/2016
1.1.0.936 440 7/26/2016
1.1.0.935 437 7/26/2016
1.1.0.932 435 7/25/2016
1.1.0.930 412 7/23/2016
1.1.0.929 432 7/23/2016
1.1.0.928 428 7/22/2016
1.1.0.927 440 7/22/2016
1.1.0.924 498 7/22/2016
1.1.0.923 413 7/21/2016
1.1.0.918 388 7/20/2016
1.1.0.915 389 7/20/2016
1.1.0.912 418 7/20/2016
1.1.0.910 400 7/20/2016
1.1.0.904 416 7/19/2016
1.1.0.903 390 7/18/2016
1.1.0.902 392 7/18/2016
1.1.0.901 424 7/18/2016
1.1.0.887 429 7/16/2016
1.1.0.886 430 7/16/2016
1.1.0.883 529 7/14/2016
1.1.0.879 574 7/13/2016
1.1.0.877 543 7/12/2016
1.1.0.864 414 7/9/2016
1.1.0.863 403 7/9/2016
1.1.0.859 412 7/8/2016
1.1.0.858 393 7/8/2016
1.1.0.857 413 7/6/2016
1.1.0.856 401 6/29/2016
1.1.0.855 388 6/28/2016
1.1.0.854 419 6/25/2016
1.0.1.851-rc 356 6/17/2016
1.0.1.849-rc 369 6/17/2016
1.0.1.842-rc 390 6/9/2016
1.0.1.841-rc 386 6/9/2016
1.0.1.839-rc 393 6/9/2016
1.0.1.837-rc 457 5/31/2016
1.0.1.835-rc 400 5/26/2016
1.0.1.834-rc 377 5/24/2016
1.0.1.833-rc 392 5/20/2016
1.0.1.832-rc 386 5/20/2016
1.0.1.828-rc 384 5/9/2016
1.0.1.827-rc 395 5/7/2016
1.0.1.826-rc 394 5/2/2016
1.0.1.824-rc 410 5/1/2016
1.0.1.823-rc 386 4/21/2016
1.0.1.822-rc 357 4/20/2016
1.0.1.821-rc 394 4/11/2016
1.0.1.819-rc 440 4/11/2016
1.0.1.818-rc 377 4/8/2016
1.0.1.817-rc 379 4/7/2016
1.0.1.813-rc 375 4/7/2016
1.0.1.812-rc 421 3/30/2016
1.0.1.811-rc 391 3/30/2016
1.0.1.810-rc 372 3/30/2016
1.0.1.808-rc 371 3/30/2016
1.0.1.807-rc 403 3/29/2016
1.0.1.806-rc 381 3/29/2016
1.0.1.805-rc 388 3/29/2016
1.0.1.796-rc 376 3/27/2016
1.0.1.793-rc 410 3/27/2016
1.0.1.788-rc 404 3/26/2016
1.0.1.785-rc 409 3/26/2016
1.0.1.778-rc 407 3/22/2016
1.0.1.777-rc 407 3/22/2016
1.0.1.776-rc 365 3/18/2016
1.0.1.775-rc 399 3/18/2016
1.0.1.774-rc 400 3/16/2016
1.0.1.773-rc 390 3/16/2016
1.0.1.771-rc 358 3/15/2016
1.0.1.769-rc 401 3/15/2016
1.0.1.765-rc 359 3/15/2016
1.0.1.764-rc 378 3/15/2016
1.0.1.759-rc 425 3/14/2016
1.0.1.758-rc 361 3/14/2016
1.0.1.757-rc 366 3/14/2016
1.0.1.752-rc 393 3/13/2016
1.0.1.748-rc 433 3/13/2016
1.0.1.747-rc 433 3/13/2016
1.0.1.746-rc 426 3/13/2016
1.0.1.743-rc 375 3/9/2016
1.0.1.742-rc 384 3/8/2016
1.0.1.741-rc 363 3/8/2016
1.0.1.740-rc 396 3/7/2016
1.0.1.736-rc 370 3/7/2016
1.0.1.735-rc 399 3/7/2016
1.0.1.729-rc 372 3/6/2016
1.0.1.728-rc 379 3/6/2016
1.0.1.726-rc 381 3/6/2016
1.0.1.724-rc 432 3/4/2016
1.0.1.723-rc 405 3/3/2016
1.0.1.722-rc 361 3/3/2016
1.0.1.721-rc 395 3/3/2016
1.0.1.719-rc 394 3/2/2016
1.0.1.717-rc 399 3/1/2016
1.0.1.716-rc 425 2/28/2016
1.0.1.711-rc 436 2/28/2016
1.0.1.709-rc 439 2/27/2016
1.0.1.708-rc 466 2/27/2016
1.0.1.707-rc 445 2/27/2016
1.0.1.706-rc 428 2/26/2016
1.0.1.705-rc 481 2/26/2016
1.0.1.701-rc 411 2/25/2016
1.0.1.699-rc 385 2/23/2016
1.0.1.696-rc 417 2/21/2016
1.0.1.693-rc 379 2/20/2016
1.0.1.691-rc 402 2/19/2016
1.0.1.689-rc 368 2/19/2016
1.0.1.684-rc 378 2/18/2016
1.0.1.683-rc 368 2/18/2016
1.0.1.676-rc 375 2/17/2016
1.0.1.673-rc 388 2/17/2016
1.0.1.670-rc 383 2/17/2016
1.0.1.665-rc 409 2/15/2016
1.0.1.663-rc 398 2/14/2016
1.0.1.659-rc 361 2/14/2016
1.0.1.657-rc 379 2/14/2016
1.0.1.654-rc 475 2/14/2016
1.0.1.648-rc 449 2/13/2016
1.0.1.647-rc 374 2/13/2016
1.0.1.632-rc 376 2/11/2016
1.0.1.631-rc 400 2/11/2016
1.0.1.626-rc 373 2/10/2016
1.0.1.625-rc 385 2/10/2016
1.0.1.609-rc 398 2/4/2016
1.0.1.605-rc 363 2/4/2016
1.0.1.604-rc 393 2/4/2016
1.0.1.600-rc 372 1/28/2016
1.0.1.597-rc 383 1/27/2016
1.0.1.596-rc 442 1/26/2016
1.0.1.595-rc 402 1/22/2016
1.0.1.593-rc 376 1/22/2016
1.0.1.590-rc 393 1/21/2016
1.0.1.588-rc 429 1/20/2016
1.0.1.583-rc 380 1/20/2016
1.0.1.582-rc 408 1/20/2016
1.0.1.574-rc 398 1/19/2016
1.0.1.571-rc 386 1/19/2016
1.0.1.570-rc 403 1/18/2016
1.0.1.569-rc 355 1/17/2016
1.0.1.568-rc 389 1/15/2016
1.0.1.565-rc 394 1/8/2016
1.0.1.564-rc 404 1/8/2016
1.0.1.561-rc 406 1/6/2016
1.0.1.557-rc 398 1/3/2016
1.0.1.554-rc 451 12/22/2015
1.0.1.553-rc 427 12/22/2015
1.0.1.552-rc 452 12/22/2015
1.0.1.551-rc 372 12/21/2015
1.0.1.550-rc 388 12/20/2015
1.0.1.545-rc 391 12/17/2015
1.0.1.543-rc 369 12/17/2015
1.0.1.542-rc 375 12/16/2015
1.0.1.539-rc 400 12/16/2015
1.0.1.525-rc 416 12/16/2015
1.0.1.521-rc 392 12/15/2015
1.0.1.512-rc 397 12/14/2015
1.0.1.508-rc 375 12/14/2015
1.0.1.505-rc 409 12/14/2015
1.0.0.492-rc 453 12/11/2015
1.0.0.491-rc 462 12/11/2015
1.0.0.488-rc 469 12/11/2015
1.0.0.487-rc 441 12/11/2015
1.0.0.485-rc 379 12/9/2015
1.0.0.481-rc 390 12/8/2015
1.0.0.479-rc 390 12/7/2015
1.0.0.473-rc 385 12/6/2015
1.0.0.472-rc 397 12/3/2015
1.0.0.469-rc 441 12/1/2015
1.0.0.465-rc 395 11/19/2015
1.0.0.464-rc 410 11/16/2015
1.0.0.458-rc 431 11/3/2015
1.0.0.448-rc 396 10/27/2015
1.0.0.447-rc 400 10/27/2015
1.0.0.446-rc 421 10/27/2015
1.0.0.443-rc 381 10/27/2015
1.0.0.441-rc 403 10/26/2015
1.0.0.436-rc 384 10/26/2015
1.0.0.434-rc 410 10/26/2015
1.0.0.433-rc 385 10/26/2015
0.9.1.426 553 10/8/2015
0.9.1.424 469 10/6/2015
0.9.1.418 459 9/29/2015
0.9.1.415 448 9/29/2015
0.9.1.411 446 9/28/2015
0.9.1.408 476 9/3/2015
0.9.1.407 456 8/18/2015
0.9.1.406 484 8/13/2015
0.9.1.405 438 8/13/2015
0.9.1.404 480 8/13/2015
0.9.1.401 590 7/21/2015
0.9.1.395 527 7/5/2015
0.9.1.394 476 7/4/2015
0.9.1.393 485 7/4/2015
0.9.1.390 490 6/13/2015
0.9.1.388 434 6/13/2015
0.9.1.386 433 6/13/2015
0.9.1.385 435 6/12/2015
0.9.1.382 429 6/12/2015
0.9.1.381 408 6/12/2015
0.9.1.380 438 6/12/2015
0.9.1.378 434 6/12/2015
0.9.1.375 474 2/27/2015
0.9.1.373 588 2/25/2015
0.9.1.370 436 2/25/2015
0.9.1.367 512 2/23/2015
0.9.1.365 560 2/21/2015
0.9.1.361 472 2/21/2015
0.9.1.358 526 2/16/2015
0.9.1.357 444 2/11/2015
0.9.0.355 432 2/10/2015
0.9.0.354 454 2/1/2015
0.9.0.353 448 1/30/2015
Show less