Shaolinq.SqlServer 1.9.3

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

Release Notes

# 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 108 1/17/2020
1.9.4.1454-refs-pull-97-merge 76 9/18/2019
1.9.4.1453-refs-pull-97-head 68 9/18/2019
1.9.4.1452-refs-pull-96-merge 67 9/18/2019
1.9.4.1451-refs-pull-96-head 68 9/18/2019
1.9.4.1450-refs-pull-95-merge 68 9/18/2019
1.9.4.1449-refs-pull-95-head 68 9/18/2019
1.9.4 283 11/9/2018
1.9.3.1445-fix-null-enum-bug 148 11/9/2018
1.9.3 152 11/9/2018
1.9.1.1438-feature-allow-re... 164 10/23/2018
1.9.1 184 10/23/2018
1.9.0.1437-feature-model-ge... 161 10/21/2018
1.9.0.1435-fix-query-cachin... 171 10/18/2018
1.9.0 193 10/18/2018
1.8.15 184 10/17/2018
1.8.14.1433-fix-nested-quer... 150 10/17/2018
1.8.14 172 10/16/2018
1.8.13.1429-fix-fix-nested-... 169 10/15/2018
1.8.13 179 10/15/2018
1.8.12 208 10/2/2018
1.8.11.1420-feature-allow-i... 160 10/2/2018
1.8.11.1419-feature-allow-i... 167 10/1/2018
1.8.11.1418-feature-allow-i... 199 10/1/2018
1.8.11 198 9/25/2018
1.8.10.1416-fix-distinct-co... 176 9/25/2018
1.8.10 231 8/16/2018
1.8.9 196 8/16/2018
1.8.8.1409-feature-sqlserve... 200 8/13/2018
1.8.8 197 8/10/2018
1.8.7.1404-fix-sql-index-an... 179 8/10/2018
1.8.7 214 8/10/2018
1.8.6 204 8/8/2018
1.8.4.1394-feature-exclude-... 208 8/7/2018
1.8.4 219 8/7/2018
1.8.3.1391-feature-unique-i... 208 8/7/2018
1.8.3 227 8/6/2018
1.8.2.1387-fix-support-over... 210 8/6/2018
1.8.2 214 8/2/2018
1.8.1.1384-fix-computed-mem... 203 8/1/2018
1.8.1.1383-fix-computed-mem... 195 8/1/2018
1.8.1 248 7/29/2018
1.8.0 213 7/28/2018
1.7.2 214 7/23/2018
1.7.1 214 7/22/2018
1.7.0.1340-feature-support-... 223 7/22/2018
1.7.0.1338-feature-support-... 201 7/22/2018
1.7.0 214 7/22/2018
1.6.0.1329-feature-naming-t... 206 7/21/2018
1.5.0.1304 205 7/20/2018
1.5.0.1303-feature-class-le... 200 7/20/2018
1.5.0.1300 264 6/4/2018
1.5.0.1296-fix-datacontext-... 372 5/6/2018
1.5.0.1295 307 4/26/2018
1.5.0.1294 273 4/26/2018
1.5.0.1285 287 2/6/2018
1.5.0.1285-asynchooks-test 308 2/6/2018
1.5.0.1280-asynchooks-test 279 2/5/2018
1.3.1.1240 322 1/23/2018
1.3.1.1208 292 1/17/2018
1.3.1.1207 305 1/8/2018
1.3.1.1206 295 1/8/2018
1.3.1.1204 266 1/3/2018
1.3.1.1198 321 12/21/2017
1.3.1.1195 270 12/1/2017
1.3.1.1194 245 12/1/2017
1.3.1.1193 248 12/1/2017
1.3.1.1171 312 10/17/2017
1.3.1.1163 359 7/5/2017
1.3.1.1160 304 6/21/2017
1.3.1.1159 283 6/21/2017
1.3.1.1155 270 6/20/2017
1.3.1.1153 313 6/19/2017
1.3.1.1151 306 6/16/2017
1.3.1.1148 316 6/15/2017
1.3.0.1144 281 6/12/2017
1.3.0.1141 324 6/9/2017
1.3.0.1137 315 5/12/2017
1.3.0.1135 315 5/11/2017
1.3.0.1134 319 5/11/2017
1.3.0.1131 333 5/6/2017
1.3.0.1130 335 5/6/2017
1.3.0.1129 305 5/5/2017
1.3.0.1128 294 5/5/2017
1.2.0.1118 310 5/4/2017
1.2.0.1116 327 5/4/2017
1.2.0.1114 310 5/4/2017
1.2.0.1112 298 5/4/2017
1.2.0.1111 325 5/3/2017
1.2.0.1107 294 5/2/2017
1.2.0.1104 303 4/29/2017
1.2.0.1103 311 4/28/2017
1.2.0.1101 297 4/28/2017
1.2.0.1095 308 4/27/2017
1.2.0.1092 291 4/18/2017
1.2.0.1088 316 4/17/2017
1.2.0.1087 335 4/17/2017
1.2.0.1086 301 4/17/2017
1.2.0.1085 306 4/17/2017
1.2.0.1084 294 4/17/2017
1.2.0.1072-rc1 310 4/14/2017
1.2.0.1071-rc1 269 4/14/2017
1.2.0.1064-rc1 270 4/1/2017
1.2.0.1061-rc1 269 3/31/2017
1.2.0.1059-rc1 280 3/29/2017
1.2.0.1057-rc1 283 3/28/2017
1.2.0.1055-rc1 265 3/28/2017
1.1.1.1044 340 3/24/2017
1.1.1.1040 317 3/19/2017
1.1.1.1004 308 3/10/2017
1.1.1.1002 305 3/9/2017
1.1.1.1000 401 2/1/2017
1.1.1.998 337 1/31/2017
1.1.1.996 423 12/15/2016
1.1.1.991 368 11/28/2016
1.1.1.989 380 9/22/2016
1.1.1.987 360 9/22/2016
1.1.1.986 314 9/22/2016
1.1.1.985 366 9/22/2016
1.1.1.982 350 8/24/2016
1.1.1.980 359 8/24/2016
1.1.1.979 354 8/22/2016
1.1.0.975 325 8/22/2016
1.1.0.973 350 8/22/2016
1.1.0.972 335 8/22/2016
1.1.0.971 328 8/18/2016
1.1.0.970 332 8/16/2016
1.1.0.967 341 8/15/2016
1.1.0.966 361 8/15/2016
1.1.0.964 333 8/11/2016
1.1.0.963 371 8/9/2016
1.1.0.961 359 8/9/2016
1.1.0.960 344 8/9/2016
1.1.0.959 340 8/8/2016
1.1.0.957 348 8/7/2016
1.1.0.956 341 8/7/2016
1.1.0.947-rc 316 8/6/2016
1.1.0.946-rc 317 8/5/2016
1.1.0.945 339 8/5/2016
1.1.0.942 390 7/27/2016
1.1.0.941 371 7/27/2016
1.1.0.939 364 7/27/2016
1.1.0.938 384 7/27/2016
1.1.0.936 380 7/26/2016
1.1.0.935 370 7/26/2016
1.1.0.932 368 7/25/2016
1.1.0.930 349 7/23/2016
1.1.0.929 376 7/23/2016
1.1.0.928 372 7/22/2016
1.1.0.927 379 7/22/2016
1.1.0.924 436 7/22/2016
1.1.0.923 352 7/21/2016
1.1.0.918 325 7/20/2016
1.1.0.915 333 7/20/2016
1.1.0.912 360 7/20/2016
1.1.0.910 335 7/20/2016
1.1.0.904 354 7/19/2016
1.1.0.903 332 7/18/2016
1.1.0.902 331 7/18/2016
1.1.0.901 365 7/18/2016
1.1.0.887 368 7/16/2016
1.1.0.886 371 7/16/2016
1.1.0.883 472 7/14/2016
1.1.0.879 505 7/13/2016
1.1.0.877 484 7/12/2016
1.1.0.864 353 7/9/2016
1.1.0.863 341 7/9/2016
1.1.0.859 352 7/8/2016
1.1.0.858 332 7/8/2016
1.1.0.857 349 7/6/2016
1.1.0.856 337 6/29/2016
1.1.0.855 329 6/28/2016
1.1.0.854 355 6/25/2016
1.0.1.851-rc 300 6/17/2016
1.0.1.849-rc 291 6/17/2016
1.0.1.842-rc 324 6/9/2016
1.0.1.841-rc 324 6/9/2016
1.0.1.839-rc 334 6/9/2016
1.0.1.837-rc 399 5/31/2016
1.0.1.835-rc 331 5/26/2016
1.0.1.834-rc 318 5/24/2016
1.0.1.833-rc 334 5/20/2016
1.0.1.832-rc 323 5/20/2016
1.0.1.828-rc 322 5/9/2016
1.0.1.827-rc 324 5/7/2016
1.0.1.826-rc 338 5/2/2016
1.0.1.824-rc 357 5/1/2016
1.0.1.823-rc 332 4/21/2016
1.0.1.822-rc 300 4/20/2016
1.0.1.821-rc 324 4/11/2016
1.0.1.819-rc 376 4/11/2016
1.0.1.818-rc 313 4/8/2016
1.0.1.817-rc 315 4/7/2016
1.0.1.813-rc 322 4/7/2016
1.0.1.812-rc 361 3/30/2016
1.0.1.811-rc 328 3/30/2016
1.0.1.810-rc 312 3/30/2016
1.0.1.808-rc 313 3/30/2016
1.0.1.807-rc 341 3/29/2016
1.0.1.806-rc 323 3/29/2016
1.0.1.805-rc 319 3/29/2016
1.0.1.796-rc 319 3/27/2016
1.0.1.793-rc 349 3/27/2016
1.0.1.788-rc 331 3/26/2016
1.0.1.785-rc 351 3/26/2016
1.0.1.778-rc 342 3/22/2016
1.0.1.777-rc 351 3/22/2016
1.0.1.776-rc 309 3/18/2016
1.0.1.775-rc 334 3/18/2016
1.0.1.774-rc 331 3/16/2016
1.0.1.773-rc 328 3/16/2016
1.0.1.771-rc 301 3/15/2016
1.0.1.769-rc 341 3/15/2016
1.0.1.765-rc 296 3/15/2016
1.0.1.764-rc 314 3/15/2016
1.0.1.759-rc 355 3/14/2016
1.0.1.758-rc 302 3/14/2016
1.0.1.757-rc 307 3/14/2016
1.0.1.752-rc 341 3/13/2016
1.0.1.748-rc 357 3/13/2016
1.0.1.747-rc 362 3/13/2016
1.0.1.746-rc 356 3/13/2016
1.0.1.743-rc 312 3/9/2016
1.0.1.742-rc 319 3/8/2016
1.0.1.741-rc 305 3/8/2016
1.0.1.740-rc 335 3/7/2016
1.0.1.736-rc 312 3/7/2016
1.0.1.735-rc 339 3/7/2016
1.0.1.729-rc 316 3/6/2016
1.0.1.728-rc 321 3/6/2016
1.0.1.726-rc 324 3/6/2016
1.0.1.724-rc 367 3/4/2016
1.0.1.723-rc 346 3/3/2016
1.0.1.722-rc 308 3/3/2016
1.0.1.721-rc 334 3/3/2016
1.0.1.719-rc 326 3/2/2016
1.0.1.717-rc 343 3/1/2016
1.0.1.716-rc 366 2/28/2016
1.0.1.711-rc 378 2/28/2016
1.0.1.709-rc 383 2/27/2016
1.0.1.708-rc 401 2/27/2016
1.0.1.707-rc 389 2/27/2016
1.0.1.706-rc 369 2/26/2016
1.0.1.705-rc 409 2/26/2016
1.0.1.701-rc 346 2/25/2016
1.0.1.699-rc 323 2/23/2016
1.0.1.696-rc 354 2/21/2016
1.0.1.693-rc 311 2/20/2016
1.0.1.691-rc 342 2/19/2016
1.0.1.689-rc 313 2/19/2016
1.0.1.684-rc 315 2/18/2016
1.0.1.683-rc 310 2/18/2016
1.0.1.676-rc 315 2/17/2016
1.0.1.673-rc 329 2/17/2016
1.0.1.670-rc 320 2/17/2016
1.0.1.665-rc 345 2/15/2016
1.0.1.663-rc 338 2/14/2016
1.0.1.659-rc 301 2/14/2016
1.0.1.657-rc 304 2/14/2016
1.0.1.654-rc 398 2/14/2016
1.0.1.648-rc 385 2/13/2016
1.0.1.647-rc 315 2/13/2016
1.0.1.632-rc 316 2/11/2016
1.0.1.631-rc 339 2/11/2016
1.0.1.626-rc 305 2/10/2016
1.0.1.625-rc 322 2/10/2016
1.0.1.609-rc 333 2/4/2016
1.0.1.605-rc 309 2/4/2016
1.0.1.604-rc 317 2/4/2016
1.0.1.600-rc 304 1/28/2016
1.0.1.597-rc 326 1/27/2016
1.0.1.596-rc 388 1/26/2016
1.0.1.595-rc 337 1/22/2016
1.0.1.593-rc 320 1/22/2016
1.0.1.590-rc 336 1/21/2016
1.0.1.588-rc 366 1/20/2016
1.0.1.583-rc 324 1/20/2016
1.0.1.582-rc 347 1/20/2016
1.0.1.574-rc 343 1/19/2016
1.0.1.571-rc 325 1/19/2016
1.0.1.570-rc 345 1/18/2016
1.0.1.569-rc 297 1/17/2016
1.0.1.568-rc 328 1/15/2016
1.0.1.565-rc 336 1/8/2016
1.0.1.564-rc 349 1/8/2016
1.0.1.561-rc 349 1/6/2016
1.0.1.557-rc 342 1/3/2016
1.0.1.554-rc 384 12/22/2015
1.0.1.553-rc 359 12/22/2015
1.0.1.552-rc 371 12/22/2015
1.0.1.551-rc 313 12/21/2015
1.0.1.550-rc 327 12/20/2015
1.0.1.545-rc 329 12/17/2015
1.0.1.543-rc 310 12/17/2015
1.0.1.542-rc 324 12/16/2015
1.0.1.539-rc 343 12/16/2015
1.0.1.525-rc 362 12/16/2015
1.0.1.521-rc 342 12/15/2015
1.0.1.512-rc 341 12/14/2015
1.0.1.508-rc 318 12/14/2015
1.0.1.505-rc 351 12/14/2015
1.0.0.492-rc 386 12/11/2015
1.0.0.491-rc 395 12/11/2015
1.0.0.488-rc 405 12/11/2015
1.0.0.487-rc 368 12/11/2015
1.0.0.485-rc 322 12/9/2015
1.0.0.481-rc 333 12/8/2015
1.0.0.479-rc 333 12/7/2015
1.0.0.473-rc 329 12/6/2015
1.0.0.472-rc 319 12/3/2015
1.0.0.469-rc 375 12/1/2015
1.0.0.465-rc 337 11/19/2015
1.0.0.464-rc 342 11/16/2015
1.0.0.458-rc 379 11/3/2015
1.0.0.448-rc 339 10/27/2015
1.0.0.447-rc 341 10/27/2015
1.0.0.446-rc 362 10/27/2015
1.0.0.443-rc 322 10/27/2015
1.0.0.441-rc 347 10/26/2015
1.0.0.436-rc 324 10/26/2015
1.0.0.434-rc 354 10/26/2015
1.0.0.433-rc 325 10/26/2015
0.9.1.426 488 10/8/2015
0.9.1.424 400 10/6/2015
0.9.1.418 395 9/29/2015
0.9.1.415 379 9/29/2015
0.9.1.411 390 9/28/2015
0.9.1.408 407 9/3/2015
0.9.1.407 397 8/18/2015
0.9.1.406 410 8/13/2015
0.9.1.405 377 8/13/2015
0.9.1.404 412 8/13/2015
0.9.1.401 518 7/21/2015
0.9.1.395 470 7/5/2015
0.9.1.394 417 7/4/2015
0.9.1.393 417 7/4/2015
0.9.1.390 433 6/13/2015
0.9.1.388 373 6/13/2015
0.9.1.386 378 6/13/2015
0.9.1.385 378 6/12/2015
0.9.1.382 374 6/12/2015
0.9.1.381 347 6/12/2015
0.9.1.380 371 6/12/2015
0.9.1.378 364 6/12/2015
0.9.1.375 418 2/27/2015
0.9.1.373 525 2/25/2015
0.9.1.370 376 2/25/2015
0.9.1.367 453 2/23/2015
0.9.1.365 507 2/21/2015
0.9.1.361 411 2/21/2015
0.9.1.358 466 2/16/2015
0.9.1.357 385 2/11/2015
0.9.0.355 368 2/10/2015
0.9.0.354 393 2/1/2015
0.9.0.353 389 1/30/2015
Show less