Shaolinq.Postgres.DotConnect 0.9.1.367

Shaolinq is a thoughtfully designed ORM and Linq provider for .NET
   
Use this package to add Shaolinq and out-of-the-box Postgres support (via the DotConnect ADO.NET Postgres provider).
   
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 and Postgres.
- 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.Postgres.DotConnect -Version 0.9.1.367
dotnet add package Shaolinq.Postgres.DotConnect --version 0.9.1.367
<PackageReference Include="Shaolinq.Postgres.DotConnect" Version="0.9.1.367" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Shaolinq.Postgres.DotConnect --version 0.9.1.367
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

- 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

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.1477-refs-pull-109-merge 39 10/1/2020
1.9.5.1476-refs-pull-109-head 40 10/1/2020
1.9.5.1475-refs-pull-100-merge 51 9/30/2020
1.9.5.1474-refs-pull-104-merge 50 9/30/2020
1.9.5.1471-refs-pull-108-merge 62 9/30/2020
1.9.5.1470-refs-pull-108-merge 98 9/30/2020
1.9.5.1469-refs-pull-108-head 98 9/30/2020
1.9.5.1468-refs-pull-107-merge 97 9/30/2020
1.9.5.1467-refs-pull-107-head 98 9/30/2020
1.9.5.1466-refs-pull-106-merge 101 9/30/2020
1.9.5.1465-refs-pull-106-head 101 9/30/2020
1.9.5.1464-refs-pull-105-merge 134 9/30/2020
1.9.5.1462-refs-pull-104-merge 145 9/30/2020
1.9.5.1460-refs-pull-100-merge 111 4/1/2020
1.9.5 221 1/17/2020
1.9.4.1454-refs-pull-97-merge 139 9/18/2019
1.9.4.1453-refs-pull-97-head 131 9/18/2019
1.9.4.1452-refs-pull-96-merge 130 9/18/2019
1.9.4.1451-refs-pull-96-head 133 9/18/2019
1.9.4.1450-refs-pull-95-merge 135 9/18/2019
1.9.4.1449-refs-pull-95-head 130 9/18/2019
1.9.4 329 11/9/2018
1.9.3.1445-fix-null-enum-bug 216 11/9/2018
1.9.3 231 11/9/2018
1.9.1.1438-feature-allow-re... 245 10/23/2018
1.9.1 254 10/23/2018
1.9.0.1437-feature-model-ge... 232 10/21/2018
1.9.0.1435-fix-query-cachin... 228 10/18/2018
1.9.0 243 10/18/2018
1.8.15 248 10/17/2018
1.8.14.1433-fix-nested-quer... 233 10/17/2018
1.8.14 252 10/16/2018
1.8.13.1429-fix-fix-nested-... 233 10/15/2018
1.8.13 265 10/15/2018
1.8.12 268 10/2/2018
1.8.11.1420-feature-allow-i... 241 10/2/2018
1.8.11.1419-feature-allow-i... 280 10/1/2018
1.8.11.1418-feature-allow-i... 242 10/1/2018
1.8.11 289 9/25/2018
1.8.10.1416-fix-distinct-co... 300 9/25/2018
1.8.10 288 8/16/2018
1.8.9 292 8/16/2018
1.8.8.1409-feature-sqlserve... 290 8/13/2018
1.8.8 300 8/10/2018
1.8.7.1404-fix-sql-index-an... 272 8/10/2018
1.8.7 285 8/10/2018
1.8.6 349 8/8/2018
1.8.4.1394-feature-exclude-... 329 8/7/2018
1.8.4 292 8/7/2018
1.8.3.1391-feature-unique-i... 298 8/7/2018
1.8.3 314 8/6/2018
1.8.2.1387-fix-support-over... 313 8/6/2018
1.8.2 287 8/2/2018
1.8.1.1384-fix-computed-mem... 294 8/1/2018
1.8.1.1383-fix-computed-mem... 298 8/1/2018
1.8.1 317 7/29/2018
1.8.0 349 7/28/2018
1.7.2 298 7/23/2018
1.7.1 300 7/22/2018
1.7.0.1340-feature-support-... 280 7/22/2018
1.7.0.1338-feature-support-... 290 7/22/2018
1.7.0 297 7/22/2018
1.6.0.1329-feature-naming-t... 303 7/21/2018
1.5.0.1304 284 7/20/2018
1.5.0.1303-feature-class-le... 288 7/20/2018
1.5.0.1300 393 6/4/2018
1.5.0.1296-fix-datacontext-... 434 5/6/2018
1.5.0.1295 384 4/26/2018
1.5.0.1294 351 4/26/2018
1.5.0.1285 395 2/6/2018
1.5.0.1285-asynchooks-test 371 2/6/2018
1.5.0.1280-asynchooks-test 354 2/5/2018
1.3.1.1240 420 1/23/2018
1.3.1.1208 400 1/17/2018
1.3.1.1207 399 1/8/2018
1.3.1.1206 381 1/8/2018
1.3.1.1204 378 1/3/2018
1.3.1.1198 392 12/21/2017
1.3.1.1195 336 12/1/2017
1.3.1.1194 328 12/1/2017
1.3.1.1193 331 12/1/2017
1.3.1.1171 366 10/17/2017
1.3.1.1163 414 7/5/2017
1.3.1.1160 413 6/21/2017
1.3.1.1159 368 6/21/2017
1.3.1.1155 377 6/20/2017
1.3.1.1153 372 6/19/2017
1.3.1.1151 380 6/16/2017
1.3.1.1148 392 6/15/2017
1.3.0.1144 397 6/12/2017
1.3.0.1141 393 6/9/2017
1.3.0.1137 395 5/12/2017
1.3.0.1135 383 5/11/2017
1.3.0.1134 401 5/11/2017
1.3.0.1131 404 5/6/2017
1.3.0.1130 383 5/6/2017
1.3.0.1129 377 5/5/2017
1.3.0.1128 405 5/5/2017
1.2.0.1118 388 5/4/2017
1.2.0.1116 390 5/4/2017
1.2.0.1114 389 5/4/2017
1.2.0.1112 384 5/4/2017
1.2.0.1111 422 5/3/2017
1.2.0.1107 371 5/2/2017
1.2.0.1104 382 4/29/2017
1.2.0.1103 407 4/28/2017
1.2.0.1101 370 4/28/2017
1.2.0.1095 387 4/27/2017
1.2.0.1092 401 4/18/2017
1.2.0.1088 404 4/17/2017
1.2.0.1087 403 4/17/2017
1.2.0.1086 380 4/17/2017
1.2.0.1085 384 4/17/2017
1.2.0.1084 388 4/17/2017
1.2.0.1064-rc1 368 4/1/2017
1.2.0.1061-rc1 362 3/31/2017
1.2.0.1059-rc1 356 3/29/2017
1.2.0.1057-rc1 369 3/28/2017
1.2.0.1055-rc1 368 3/28/2017
1.1.1.1044 423 3/24/2017
1.1.1.1040 370 3/19/2017
1.1.1.1004 381 3/10/2017
1.1.1.1002 395 3/9/2017
1.1.1.1000 414 2/1/2017
1.1.1.998 402 1/31/2017
1.1.1.996 462 12/15/2016
1.1.1.991 424 11/28/2016
1.1.1.989 468 9/22/2016
1.1.1.987 402 9/22/2016
1.1.1.986 417 9/22/2016
1.1.1.985 415 9/22/2016
1.1.1.982 448 8/24/2016
1.1.1.980 438 8/24/2016
1.1.1.979 421 8/22/2016
1.1.0.975 437 8/22/2016
1.1.0.973 453 8/22/2016
1.1.0.972 413 8/22/2016
1.1.0.971 491 8/18/2016
1.1.0.970 427 8/16/2016
1.1.0.967 417 8/15/2016
1.1.0.966 421 8/15/2016
1.1.0.964 392 8/11/2016
1.1.0.963 419 8/9/2016
1.1.0.961 422 8/9/2016
1.1.0.960 448 8/9/2016
1.1.0.959 423 8/8/2016
1.1.0.957 447 8/7/2016
1.1.0.956 422 8/7/2016
1.1.0.947-rc 385 8/6/2016
1.1.0.946-rc 385 8/5/2016
1.1.0.945 416 8/5/2016
1.1.0.942 526 7/27/2016
1.1.0.941 501 7/27/2016
1.1.0.939 457 7/27/2016
1.1.0.938 495 7/27/2016
1.1.0.936 465 7/26/2016
1.1.0.935 425 7/26/2016
1.1.0.932 422 7/25/2016
1.1.0.930 441 7/23/2016
1.1.0.929 447 7/23/2016
1.1.0.928 421 7/22/2016
1.1.0.927 464 7/22/2016
1.1.0.924 452 7/22/2016
1.1.0.923 442 7/21/2016
1.1.0.918 429 7/20/2016
1.1.0.915 424 7/20/2016
1.1.0.912 431 7/20/2016
1.1.0.910 447 7/20/2016
1.1.0.904 451 7/19/2016
1.1.0.903 416 7/18/2016
1.1.0.902 407 7/18/2016
1.1.0.901 428 7/18/2016
1.1.0.887 415 7/16/2016
1.1.0.886 418 7/16/2016
1.1.0.883 570 7/14/2016
1.1.0.879 568 7/13/2016
1.1.0.877 557 7/12/2016
1.1.0.864 431 7/9/2016
1.1.0.863 456 7/9/2016
1.1.0.859 426 7/8/2016
1.1.0.858 447 7/8/2016
1.1.0.857 428 7/6/2016
1.1.0.856 446 6/29/2016
1.1.0.855 440 6/28/2016
1.1.0.854 440 6/25/2016
1.0.1.851-rc 398 6/17/2016
1.0.1.849-rc 387 6/17/2016
1.0.1.842-rc 402 6/9/2016
1.0.1.841-rc 392 6/9/2016
1.0.1.839-rc 402 6/9/2016
1.0.1.837-rc 401 5/31/2016
1.0.1.835-rc 394 5/26/2016
1.0.1.834-rc 402 5/24/2016
1.0.1.833-rc 443 5/20/2016
1.0.1.832-rc 418 5/20/2016
1.0.1.828-rc 394 5/9/2016
1.0.1.827-rc 382 5/7/2016
1.0.1.826-rc 386 5/2/2016
1.0.1.824-rc 408 5/1/2016
1.0.1.823-rc 409 4/21/2016
1.0.1.822-rc 392 4/20/2016
1.0.1.821-rc 395 4/11/2016
1.0.1.819-rc 435 4/11/2016
1.0.1.818-rc 427 4/8/2016
1.0.1.817-rc 414 4/7/2016
1.0.1.813-rc 390 4/7/2016
1.0.1.812-rc 389 3/30/2016
1.0.1.811-rc 428 3/30/2016
1.0.1.810-rc 405 3/30/2016
1.0.1.808-rc 393 3/30/2016
1.0.1.807-rc 438 3/29/2016
1.0.1.806-rc 399 3/29/2016
1.0.1.805-rc 399 3/29/2016
1.0.1.796-rc 410 3/27/2016
1.0.1.793-rc 393 3/27/2016
1.0.1.788-rc 437 3/26/2016
1.0.1.785-rc 391 3/26/2016
1.0.1.778-rc 436 3/22/2016
1.0.1.777-rc 393 3/22/2016
1.0.1.776-rc 459 3/18/2016
1.0.1.775-rc 383 3/18/2016
1.0.1.774-rc 403 3/16/2016
1.0.1.773-rc 386 3/16/2016
1.0.1.771-rc 409 3/15/2016
1.0.1.769-rc 407 3/15/2016
1.0.1.765-rc 377 3/15/2016
1.0.1.764-rc 381 3/15/2016
1.0.1.759-rc 450 3/14/2016
1.0.1.758-rc 396 3/14/2016
1.0.1.757-rc 397 3/14/2016
1.0.1.752-rc 395 3/13/2016
1.0.1.748-rc 443 3/13/2016
1.0.1.747-rc 450 3/13/2016
1.0.1.746-rc 395 3/13/2016
1.0.1.743-rc 389 3/9/2016
1.0.1.742-rc 424 3/8/2016
1.0.1.741-rc 389 3/8/2016
1.0.1.740-rc 403 3/7/2016
1.0.1.736-rc 431 3/7/2016
1.0.1.735-rc 400 3/7/2016
1.0.1.729-rc 391 3/6/2016
1.0.1.728-rc 383 3/6/2016
1.0.1.726-rc 382 3/6/2016
1.0.1.724-rc 392 3/4/2016
1.0.1.723-rc 426 3/3/2016
1.0.1.722-rc 419 3/3/2016
1.0.1.721-rc 396 3/3/2016
1.0.1.719-rc 534 3/2/2016
1.0.1.717-rc 425 3/1/2016
1.0.1.716-rc 398 2/28/2016
1.0.1.711-rc 388 2/28/2016
1.0.1.709-rc 392 2/27/2016
1.0.1.708-rc 438 2/27/2016
1.0.1.707-rc 405 2/27/2016
1.0.1.706-rc 398 2/26/2016
1.0.1.705-rc 395 2/26/2016
1.0.1.701-rc 397 2/25/2016
1.0.1.699-rc 388 2/23/2016
1.0.1.696-rc 391 2/21/2016
1.0.1.693-rc 418 2/20/2016
1.0.1.691-rc 385 2/19/2016
1.0.1.689-rc 405 2/19/2016
1.0.1.684-rc 394 2/18/2016
1.0.1.683-rc 397 2/18/2016
1.0.1.676-rc 386 2/17/2016
1.0.1.673-rc 405 2/17/2016
1.0.1.670-rc 412 2/17/2016
1.0.1.665-rc 397 2/15/2016
1.0.1.663-rc 406 2/14/2016
1.0.1.659-rc 413 2/14/2016
1.0.1.657-rc 416 2/14/2016
1.0.1.654-rc 392 2/14/2016
1.0.1.648-rc 402 2/13/2016
1.0.1.647-rc 456 2/13/2016
1.0.1.632-rc 399 2/11/2016
1.0.1.631-rc 394 2/11/2016
1.0.1.626-rc 397 2/10/2016
1.0.1.625-rc 389 2/10/2016
1.0.1.609-rc 403 2/4/2016
1.0.1.605-rc 431 2/4/2016
1.0.1.604-rc 390 2/4/2016
1.0.1.600-rc 395 1/28/2016
1.0.1.597-rc 408 1/27/2016
1.0.1.596-rc 383 1/26/2016
1.0.1.595-rc 418 1/22/2016
1.0.1.593-rc 444 1/22/2016
1.0.1.590-rc 405 1/21/2016
1.0.1.588-rc 388 1/20/2016
1.0.1.583-rc 395 1/20/2016
1.0.1.582-rc 402 1/20/2016
1.0.1.574-rc 396 1/19/2016
1.0.1.571-rc 405 1/19/2016
1.0.1.570-rc 397 1/18/2016
1.0.1.569-rc 388 1/17/2016
1.0.1.568-rc 379 1/15/2016
1.0.1.565-rc 404 1/8/2016
1.0.1.564-rc 415 1/8/2016
1.0.1.561-rc 396 1/6/2016
1.0.1.557-rc 403 1/3/2016
1.0.1.554-rc 465 12/22/2015
1.0.1.553-rc 526 12/22/2015
1.0.1.552-rc 451 12/22/2015
1.0.1.551-rc 402 12/21/2015
1.0.1.550-rc 449 12/20/2015
1.0.1.545-rc 393 12/17/2015
1.0.1.543-rc 424 12/17/2015
1.0.1.542-rc 402 12/16/2015
1.0.1.539-rc 409 12/16/2015
1.0.1.525-rc 400 12/16/2015
1.0.1.521-rc 412 12/15/2015
1.0.1.512-rc 411 12/14/2015
1.0.1.508-rc 404 12/14/2015
1.0.1.505-rc 385 12/14/2015
1.0.0.492-rc 393 12/11/2015
1.0.0.491-rc 414 12/11/2015
1.0.0.488-rc 472 12/11/2015
1.0.0.487-rc 436 12/11/2015
1.0.0.485-rc 504 12/9/2015
1.0.0.481-rc 410 12/8/2015
1.0.0.479-rc 406 12/7/2015
1.0.0.473-rc 407 12/6/2015
1.0.0.472-rc 435 12/3/2015
1.0.0.469-rc 413 12/1/2015
1.0.0.465-rc 415 11/19/2015
1.0.0.464-rc 400 11/16/2015
1.0.0.458-rc 419 11/3/2015
1.0.0.448-rc 426 10/27/2015
1.0.0.447-rc 413 10/27/2015
1.0.0.446-rc 406 10/27/2015
1.0.0.443-rc 422 10/27/2015
1.0.0.441-rc 438 10/26/2015
1.0.0.436-rc 444 10/26/2015
1.0.0.434-rc 409 10/26/2015
0.9.1.426 642 10/8/2015
0.9.1.424 489 10/6/2015
0.9.1.418 489 9/29/2015
0.9.1.415 441 9/29/2015
0.9.1.411 452 9/28/2015
0.9.1.408 499 9/3/2015
0.9.1.407 451 8/18/2015
0.9.1.406 527 8/13/2015
0.9.1.405 453 8/13/2015
0.9.1.404 531 8/13/2015
0.9.1.401 558 7/21/2015
0.9.1.395 544 7/5/2015
0.9.1.394 470 7/4/2015
0.9.1.393 460 7/4/2015
0.9.1.390 488 6/13/2015
0.9.1.388 472 6/13/2015
0.9.1.386 461 6/13/2015
0.9.1.385 511 6/12/2015
0.9.1.382 473 6/12/2015
0.9.1.381 505 6/12/2015
0.9.1.380 458 6/12/2015
0.9.1.378 509 6/12/2015
0.9.1.375 661 2/27/2015
0.9.1.373 473 2/25/2015
0.9.1.370 450 2/25/2015
0.9.1.367 504 2/23/2015
0.9.1.365 534 2/21/2015
0.9.1.361 539 2/21/2015
0.9.1.358 485 2/16/2015
0.9.1.357 489 2/11/2015
0.9.0.355 471 2/10/2015
0.9.0.354 507 2/1/2015
0.9.0.353 530 1/30/2015
0.9.0.350 534 1/29/2015
0.9.0.338 535 1/12/2015
0.9.0.328 519 11/25/2014
0.9.0.326 488 11/24/2014
0.9.0.325 484 11/24/2014
0.9.0.323 490 11/23/2014
0.9.0.313 519 11/22/2014
0.9.0.299 630 11/12/2014
0.9.0.295 787 11/12/2014
0.9.0.290 624 11/11/2014
0.9.0.279 813 11/9/2014
0.9.0.269 693 11/6/2014
0.9.0.268 986 11/4/2014
0.9.0.266 1,208 11/3/2014
0.9.0.265 721 11/3/2014
0.9.0.263 994 11/3/2014
0.9.0.262 722 11/3/2014
0.9.0.249 476 10/27/2014
0.9.0.236 514 10/25/2014
0.9.0.234 514 10/24/2014
0.9.0.233 529 10/21/2014
0.9.0.227 465 10/21/2014
0.9.0.226 470 10/21/2014
0.9.0.225 532 10/21/2014
0.9.0.222 475 10/19/2014
0.9.0.221 493 10/19/2014
0.9.0.204 484 10/17/2014
0.9.0.200 516 10/15/2014
0.9.0.199 492 10/15/2014
0.9.0.193 483 10/14/2014
0.9.0.189 472 10/14/2014
0.9.0.184-test 474 10/14/2014
0.9.0.183-test 475 10/13/2014
0.9.0.179 470 10/13/2014
0.9.0.174 504 10/13/2014
0.6.0.173 468 10/13/2014
0.6.0.165 515 10/3/2014
0.6.0.160 522 9/18/2014
0.6.0.157 499 9/18/2014
0.6.0.155 492 9/18/2014
0.6.0.151 492 9/17/2014
0.6.0.147 485 9/16/2014
0.6.0.143 489 9/12/2014
0.6.0.141 495 9/10/2014
0.6.0.139 524 9/3/2014
0.6.0.135 499 8/21/2014
0.6.0.134 527 8/8/2014
0.6.0.130 516 8/4/2014
0.6.0.127 546 7/1/2014
0.6.0.101 603 1/21/2014
0.6.0.97 505 1/16/2014
0.5.0.51 502 1/5/2014
0.5.0.36 533 12/9/2013
0.5.0.35 508 12/8/2013
0.5.0.28 525 12/1/2013
Show less