Shaolinq.SqlServer 1.9.5

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!

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

Release Notes

# 1.9.5
- Added Rollback data model hook.
- Fixed when some data model hooks were called.
# 1.9.4
- Fixed bug where comparing a nullable enum property to nullable enum variable can throw an exception if the variable is null.
# 1.9.3
- Added IDataAccessObjectAdvanced.DeflatedPredicate property.
# 1.9.2
- Added DataAccessModel.GetReference{T}(id)  where T : DataAccessObject method.
# 1.9.1
- Allow querying new objects while committing by disabling transaction-context object cache (DataAccessObjectDataContext).
This can occur if there are any computed properties that need to perform additional queries (including implicit N+1 queries from dereferencing child properties) in order to generate the property value.
# 1.9.0
- Fixed potential query caching problems when using queries that include predicated deflated references.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.9.5.1460-refs-pull-100-merge 55 4/1/2020
1.9.5 145 1/17/2020
1.9.4.1454-refs-pull-97-merge 92 9/18/2019
1.9.4.1453-refs-pull-97-head 81 9/18/2019
1.9.4.1452-refs-pull-96-merge 81 9/18/2019
1.9.4.1451-refs-pull-96-head 82 9/18/2019
1.9.4.1450-refs-pull-95-merge 81 9/18/2019
1.9.4.1449-refs-pull-95-head 81 9/18/2019
1.9.4 303 11/9/2018
1.9.3.1445-fix-null-enum-bug 164 11/9/2018
1.9.3 165 11/9/2018
1.9.1.1438-feature-allow-re... 176 10/23/2018
1.9.1 200 10/23/2018
1.9.0.1437-feature-model-ge... 187 10/21/2018
1.9.0.1435-fix-query-cachin... 189 10/18/2018
1.9.0 210 10/18/2018
1.8.15 200 10/17/2018
1.8.14.1433-fix-nested-quer... 165 10/17/2018
1.8.14 191 10/16/2018
1.8.13.1429-fix-fix-nested-... 184 10/15/2018
1.8.13 194 10/15/2018
1.8.12 224 10/2/2018
1.8.11.1420-feature-allow-i... 180 10/2/2018
1.8.11.1419-feature-allow-i... 185 10/1/2018
1.8.11.1418-feature-allow-i... 213 10/1/2018
1.8.11 214 9/25/2018
1.8.10.1416-fix-distinct-co... 191 9/25/2018
1.8.10 249 8/16/2018
1.8.9 214 8/16/2018
1.8.8.1409-feature-sqlserve... 221 8/13/2018
1.8.8 214 8/10/2018
1.8.7.1404-fix-sql-index-an... 199 8/10/2018
1.8.7 233 8/10/2018
1.8.6 223 8/8/2018
1.8.4.1394-feature-exclude-... 228 8/7/2018
1.8.4 237 8/7/2018
1.8.3.1391-feature-unique-i... 224 8/7/2018
1.8.3 246 8/6/2018
1.8.2.1387-fix-support-over... 225 8/6/2018
1.8.2 245 8/2/2018
1.8.1.1384-fix-computed-mem... 219 8/1/2018
1.8.1.1383-fix-computed-mem... 211 8/1/2018
1.8.1 268 7/29/2018
1.8.0 236 7/28/2018
1.7.2 229 7/23/2018
1.7.1 232 7/22/2018
1.7.0.1340-feature-support-... 245 7/22/2018
1.7.0.1338-feature-support-... 219 7/22/2018
1.7.0 229 7/22/2018
1.6.0.1329-feature-naming-t... 223 7/21/2018
1.5.0.1304 224 7/20/2018
1.5.0.1303-feature-class-le... 215 7/20/2018
1.5.0.1300 280 6/4/2018
1.5.0.1296-fix-datacontext-... 390 5/6/2018
1.5.0.1295 327 4/26/2018
1.5.0.1294 293 4/26/2018
1.5.0.1285 306 2/6/2018
1.5.0.1285-asynchooks-test 329 2/6/2018
1.5.0.1280-asynchooks-test 296 2/5/2018
1.3.1.1240 339 1/23/2018
1.3.1.1208 318 1/17/2018
1.3.1.1207 325 1/8/2018
1.3.1.1206 315 1/8/2018
1.3.1.1204 290 1/3/2018
1.3.1.1198 342 12/21/2017
1.3.1.1195 293 12/1/2017
1.3.1.1194 261 12/1/2017
1.3.1.1193 264 12/1/2017
1.3.1.1171 330 10/17/2017
1.3.1.1163 382 7/5/2017
1.3.1.1160 320 6/21/2017
1.3.1.1159 298 6/21/2017
1.3.1.1155 295 6/20/2017
1.3.1.1153 332 6/19/2017
1.3.1.1151 328 6/16/2017
1.3.1.1148 336 6/15/2017
1.3.0.1144 304 6/12/2017
1.3.0.1141 343 6/9/2017
1.3.0.1137 332 5/12/2017
1.3.0.1135 333 5/11/2017
1.3.0.1134 339 5/11/2017
1.3.0.1131 352 5/6/2017
1.3.0.1130 361 5/6/2017
1.3.0.1129 322 5/5/2017
1.3.0.1128 314 5/5/2017
1.2.0.1118 328 5/4/2017
1.2.0.1116 350 5/4/2017
1.2.0.1114 327 5/4/2017
1.2.0.1112 314 5/4/2017
1.2.0.1111 349 5/3/2017
1.2.0.1107 318 5/2/2017
1.2.0.1104 327 4/29/2017
1.2.0.1103 333 4/28/2017
1.2.0.1101 322 4/28/2017
1.2.0.1095 325 4/27/2017
1.2.0.1092 309 4/18/2017
1.2.0.1088 332 4/17/2017
1.2.0.1087 353 4/17/2017
1.2.0.1086 321 4/17/2017
1.2.0.1085 324 4/17/2017
1.2.0.1084 311 4/17/2017
1.2.0.1072-rc1 326 4/14/2017
1.2.0.1071-rc1 282 4/14/2017
1.2.0.1064-rc1 289 4/1/2017
1.2.0.1061-rc1 293 3/31/2017
1.2.0.1059-rc1 300 3/29/2017
1.2.0.1057-rc1 316 3/28/2017
1.2.0.1055-rc1 282 3/28/2017
1.1.1.1044 359 3/24/2017
1.1.1.1040 344 3/19/2017
1.1.1.1004 329 3/10/2017
1.1.1.1002 326 3/9/2017
1.1.1.1000 419 2/1/2017
1.1.1.998 356 1/31/2017
1.1.1.996 441 12/15/2016
1.1.1.991 392 11/28/2016
1.1.1.989 400 9/22/2016
1.1.1.987 378 9/22/2016
1.1.1.986 331 9/22/2016
1.1.1.985 386 9/22/2016
1.1.1.982 372 8/24/2016
1.1.1.980 377 8/24/2016
1.1.1.979 374 8/22/2016
1.1.0.975 343 8/22/2016
1.1.0.973 371 8/22/2016
1.1.0.972 354 8/22/2016
1.1.0.971 346 8/18/2016
1.1.0.970 351 8/16/2016
1.1.0.967 358 8/15/2016
1.1.0.966 381 8/15/2016
1.1.0.964 351 8/11/2016
1.1.0.963 388 8/9/2016
1.1.0.961 378 8/9/2016
1.1.0.960 369 8/9/2016
1.1.0.959 358 8/8/2016
1.1.0.957 374 8/7/2016
1.1.0.956 360 8/7/2016
1.1.0.947-rc 338 8/6/2016
1.1.0.946-rc 337 8/5/2016
1.1.0.945 355 8/5/2016
1.1.0.942 408 7/27/2016
1.1.0.941 393 7/27/2016
1.1.0.939 381 7/27/2016
1.1.0.938 404 7/27/2016
1.1.0.936 399 7/26/2016
1.1.0.935 393 7/26/2016
1.1.0.932 394 7/25/2016
1.1.0.930 368 7/23/2016
1.1.0.929 395 7/23/2016
1.1.0.928 390 7/22/2016
1.1.0.927 400 7/22/2016
1.1.0.924 458 7/22/2016
1.1.0.923 370 7/21/2016
1.1.0.918 343 7/20/2016
1.1.0.915 350 7/20/2016
1.1.0.912 378 7/20/2016
1.1.0.910 355 7/20/2016
1.1.0.904 373 7/19/2016
1.1.0.903 349 7/18/2016
1.1.0.902 351 7/18/2016
1.1.0.901 384 7/18/2016
1.1.0.887 385 7/16/2016
1.1.0.886 389 7/16/2016
1.1.0.883 489 7/14/2016
1.1.0.879 534 7/13/2016
1.1.0.877 505 7/12/2016
1.1.0.864 371 7/9/2016
1.1.0.863 360 7/9/2016
1.1.0.859 370 7/8/2016
1.1.0.858 352 7/8/2016
1.1.0.857 368 7/6/2016
1.1.0.856 357 6/29/2016
1.1.0.855 345 6/28/2016
1.1.0.854 376 6/25/2016
1.0.1.851-rc 316 6/17/2016
1.0.1.849-rc 325 6/17/2016
1.0.1.842-rc 348 6/9/2016
1.0.1.841-rc 344 6/9/2016
1.0.1.839-rc 350 6/9/2016
1.0.1.837-rc 417 5/31/2016
1.0.1.835-rc 355 5/26/2016
1.0.1.834-rc 336 5/24/2016
1.0.1.833-rc 349 5/20/2016
1.0.1.832-rc 343 5/20/2016
1.0.1.828-rc 342 5/9/2016
1.0.1.827-rc 350 5/7/2016
1.0.1.826-rc 354 5/2/2016
1.0.1.824-rc 371 5/1/2016
1.0.1.823-rc 347 4/21/2016
1.0.1.822-rc 320 4/20/2016
1.0.1.821-rc 350 4/11/2016
1.0.1.819-rc 394 4/11/2016
1.0.1.818-rc 331 4/8/2016
1.0.1.817-rc 334 4/7/2016
1.0.1.813-rc 338 4/7/2016
1.0.1.812-rc 381 3/30/2016
1.0.1.811-rc 349 3/30/2016
1.0.1.810-rc 329 3/30/2016
1.0.1.808-rc 332 3/30/2016
1.0.1.807-rc 364 3/29/2016
1.0.1.806-rc 341 3/29/2016
1.0.1.805-rc 343 3/29/2016
1.0.1.796-rc 336 3/27/2016
1.0.1.793-rc 366 3/27/2016
1.0.1.788-rc 355 3/26/2016
1.0.1.785-rc 371 3/26/2016
1.0.1.778-rc 363 3/22/2016
1.0.1.777-rc 369 3/22/2016
1.0.1.776-rc 329 3/18/2016
1.0.1.775-rc 353 3/18/2016
1.0.1.774-rc 355 3/16/2016
1.0.1.773-rc 346 3/16/2016
1.0.1.771-rc 319 3/15/2016
1.0.1.769-rc 359 3/15/2016
1.0.1.765-rc 316 3/15/2016
1.0.1.764-rc 333 3/15/2016
1.0.1.759-rc 380 3/14/2016
1.0.1.758-rc 320 3/14/2016
1.0.1.757-rc 324 3/14/2016
1.0.1.752-rc 358 3/13/2016
1.0.1.748-rc 384 3/13/2016
1.0.1.747-rc 382 3/13/2016
1.0.1.746-rc 378 3/13/2016
1.0.1.743-rc 329 3/9/2016
1.0.1.742-rc 341 3/8/2016
1.0.1.741-rc 325 3/8/2016
1.0.1.740-rc 355 3/7/2016
1.0.1.736-rc 330 3/7/2016
1.0.1.735-rc 358 3/7/2016
1.0.1.729-rc 333 3/6/2016
1.0.1.728-rc 340 3/6/2016
1.0.1.726-rc 343 3/6/2016
1.0.1.724-rc 390 3/4/2016
1.0.1.723-rc 363 3/3/2016
1.0.1.722-rc 324 3/3/2016
1.0.1.721-rc 357 3/3/2016
1.0.1.719-rc 350 3/2/2016
1.0.1.717-rc 360 3/1/2016
1.0.1.716-rc 387 2/28/2016
1.0.1.711-rc 396 2/28/2016
1.0.1.709-rc 398 2/27/2016
1.0.1.708-rc 423 2/27/2016
1.0.1.707-rc 407 2/27/2016
1.0.1.706-rc 388 2/26/2016
1.0.1.705-rc 438 2/26/2016
1.0.1.701-rc 364 2/25/2016
1.0.1.699-rc 342 2/23/2016
1.0.1.696-rc 373 2/21/2016
1.0.1.693-rc 328 2/20/2016
1.0.1.691-rc 361 2/19/2016
1.0.1.689-rc 331 2/19/2016
1.0.1.684-rc 338 2/18/2016
1.0.1.683-rc 327 2/18/2016
1.0.1.676-rc 334 2/17/2016
1.0.1.673-rc 349 2/17/2016
1.0.1.670-rc 339 2/17/2016
1.0.1.665-rc 367 2/15/2016
1.0.1.663-rc 357 2/14/2016
1.0.1.659-rc 320 2/14/2016
1.0.1.657-rc 336 2/14/2016
1.0.1.654-rc 421 2/14/2016
1.0.1.648-rc 405 2/13/2016
1.0.1.647-rc 333 2/13/2016
1.0.1.632-rc 337 2/11/2016
1.0.1.631-rc 361 2/11/2016
1.0.1.626-rc 323 2/10/2016
1.0.1.625-rc 342 2/10/2016
1.0.1.609-rc 353 2/4/2016
1.0.1.605-rc 327 2/4/2016
1.0.1.604-rc 350 2/4/2016
1.0.1.600-rc 332 1/28/2016
1.0.1.597-rc 343 1/27/2016
1.0.1.596-rc 405 1/26/2016
1.0.1.595-rc 359 1/22/2016
1.0.1.593-rc 337 1/22/2016
1.0.1.590-rc 353 1/21/2016
1.0.1.588-rc 386 1/20/2016
1.0.1.583-rc 341 1/20/2016
1.0.1.582-rc 364 1/20/2016
1.0.1.574-rc 361 1/19/2016
1.0.1.571-rc 345 1/19/2016
1.0.1.570-rc 362 1/18/2016
1.0.1.569-rc 315 1/17/2016
1.0.1.568-rc 347 1/15/2016
1.0.1.565-rc 353 1/8/2016
1.0.1.564-rc 366 1/8/2016
1.0.1.561-rc 365 1/6/2016
1.0.1.557-rc 357 1/3/2016
1.0.1.554-rc 403 12/22/2015
1.0.1.553-rc 381 12/22/2015
1.0.1.552-rc 397 12/22/2015
1.0.1.551-rc 332 12/21/2015
1.0.1.550-rc 350 12/20/2015
1.0.1.545-rc 351 12/17/2015
1.0.1.543-rc 332 12/17/2015
1.0.1.542-rc 340 12/16/2015
1.0.1.539-rc 360 12/16/2015
1.0.1.525-rc 381 12/16/2015
1.0.1.521-rc 358 12/15/2015
1.0.1.512-rc 360 12/14/2015
1.0.1.508-rc 335 12/14/2015
1.0.1.505-rc 373 12/14/2015
1.0.0.492-rc 407 12/11/2015
1.0.0.491-rc 417 12/11/2015
1.0.0.488-rc 424 12/11/2015
1.0.0.487-rc 393 12/11/2015
1.0.0.485-rc 341 12/9/2015
1.0.0.481-rc 352 12/8/2015
1.0.0.479-rc 350 12/7/2015
1.0.0.473-rc 349 12/6/2015
1.0.0.472-rc 351 12/3/2015
1.0.0.469-rc 398 12/1/2015
1.0.0.465-rc 354 11/19/2015
1.0.0.464-rc 362 11/16/2015
1.0.0.458-rc 395 11/3/2015
1.0.0.448-rc 357 10/27/2015
1.0.0.447-rc 358 10/27/2015
1.0.0.446-rc 378 10/27/2015
1.0.0.443-rc 340 10/27/2015
1.0.0.441-rc 364 10/26/2015
1.0.0.436-rc 344 10/26/2015
1.0.0.434-rc 372 10/26/2015
1.0.0.433-rc 342 10/26/2015
0.9.1.426 508 10/8/2015
0.9.1.424 425 10/6/2015
0.9.1.418 415 9/29/2015
0.9.1.415 409 9/29/2015
0.9.1.411 410 9/28/2015
0.9.1.408 425 9/3/2015
0.9.1.407 415 8/18/2015
0.9.1.406 433 8/13/2015
0.9.1.405 394 8/13/2015
0.9.1.404 434 8/13/2015
0.9.1.401 541 7/21/2015
0.9.1.395 490 7/5/2015
0.9.1.394 435 7/4/2015
0.9.1.393 446 7/4/2015
0.9.1.390 454 6/13/2015
0.9.1.388 393 6/13/2015
0.9.1.386 396 6/13/2015
0.9.1.385 398 6/12/2015
0.9.1.382 393 6/12/2015
0.9.1.381 368 6/12/2015
0.9.1.380 393 6/12/2015
0.9.1.378 383 6/12/2015
0.9.1.375 435 2/27/2015
0.9.1.373 545 2/25/2015
0.9.1.370 392 2/25/2015
0.9.1.367 470 2/23/2015
0.9.1.365 525 2/21/2015
0.9.1.361 432 2/21/2015
0.9.1.358 483 2/16/2015
0.9.1.357 403 2/11/2015
0.9.0.355 392 2/10/2015
0.9.0.354 416 2/1/2015
0.9.0.353 409 1/30/2015