Shaolinq.Postgres 1.0.1.841-rc

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 Npgsql).
   
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!

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

Release Notes

- DefaultIfEmpty() not returning singleton list for when DefaultIfEmpty is the final expression in a query (as opposed to a join or aggregate call being the last)
- Bug fixes to nested orderby/groupby queries being incorrectly optimised in some cases
- ComputedExpressions support referencing types without namespaces if they are specified as referenced types in config
- Fix combined DISTINCT TOP/TAKE support for SQL Server
- Support ***DeflatedPredicated*** references including single trip updates and referencing of such objects.
- New Roslyn based generation of SqlExpressionComparer and SqlExpressionHasher.
-- Previous --
- Support ProjectionExpression caching
- Fixed bug where ToListAsync() would erase any included collections on return
- Support UNION and UNION ALL support (Queryable.Union and Queryable.Concat)
- Removed requirement for DataAccessObjects and PersistedMembers to be abstract
- ComputedMember language/parser improvements
- Added support for Queryable.All queries
- Added async versions of Queryable.Any and Queryable.All queries
- Added predicate versions of Single, SingleOrDefault, First, FirstOrDefault
- 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.
- 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

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.9.5.1460-refs-pull-100-merge 0 4/1/2020
1.9.5 108 1/17/2020
1.9.4.1454-refs-pull-97-merge 100 9/18/2019
1.9.4.1453-refs-pull-97-head 70 9/18/2019
1.9.4.1452-refs-pull-96-merge 69 9/18/2019
1.9.4.1451-refs-pull-96-head 70 9/18/2019
1.9.4.1450-refs-pull-95-merge 71 9/18/2019
1.9.4.1449-refs-pull-95-head 70 9/18/2019
1.9.4 338 11/9/2018
1.9.3.1445-fix-null-enum-bug 151 11/9/2018
1.9.3 151 11/9/2018
1.9.1.1438-feature-allow-re... 163 10/23/2018
1.9.1 173 10/23/2018
1.9.0.1437-feature-model-ge... 164 10/21/2018
1.9.0.1435-fix-query-cachin... 171 10/18/2018
1.9.0 173 10/18/2018
1.8.15 166 10/17/2018
1.8.14.1433-fix-nested-quer... 161 10/17/2018
1.8.14 165 10/16/2018
1.8.13.1429-fix-fix-nested-... 166 10/15/2018
1.8.13 172 10/15/2018
1.8.12 211 10/2/2018
1.8.11.1420-feature-allow-i... 177 10/2/2018
1.8.11.1419-feature-allow-i... 183 10/1/2018
1.8.11.1418-feature-allow-i... 197 10/1/2018
1.8.11 181 9/25/2018
1.8.10.1416-fix-distinct-co... 176 9/25/2018
1.8.10 231 8/16/2018
1.8.9 214 8/16/2018
1.8.8.1409-feature-sqlserve... 202 8/13/2018
1.8.8 205 8/10/2018
1.8.7.1404-fix-sql-index-an... 192 8/10/2018
1.8.7 218 8/10/2018
1.8.6 211 8/8/2018
1.8.4.1394-feature-exclude-... 233 8/7/2018
1.8.4 222 8/7/2018
1.8.3.1391-feature-unique-i... 233 8/7/2018
1.8.3 244 8/6/2018
1.8.2.1387-fix-support-over... 236 8/6/2018
1.8.2 245 8/2/2018
1.8.1.1384-fix-computed-mem... 209 8/1/2018
1.8.1.1383-fix-computed-mem... 214 8/1/2018
1.8.1 246 7/29/2018
1.8.0 239 7/28/2018
1.7.2 224 7/23/2018
1.7.1 224 7/22/2018
1.7.0.1340-feature-support-... 226 7/22/2018
1.7.0.1338-feature-support-... 201 7/22/2018
1.7.0 220 7/22/2018
1.6.0.1329-feature-naming-t... 223 7/21/2018
1.5.0.1304 242 7/20/2018
1.5.0.1303-feature-class-le... 209 7/20/2018
1.5.0.1300 301 6/4/2018
1.5.0.1296-fix-datacontext-... 352 5/6/2018
1.5.0.1295 314 4/26/2018
1.5.0.1294 270 4/26/2018
1.5.0.1285 338 2/6/2018
1.5.0.1285-asynchooks-test 307 2/6/2018
1.5.0.1280-asynchooks-test 286 2/5/2018
1.3.1.1240 336 1/23/2018
1.3.1.1208 352 1/17/2018
1.3.1.1207 308 1/8/2018
1.3.1.1206 322 1/8/2018
1.3.1.1204 307 1/3/2018
1.3.1.1198 319 12/21/2017
1.3.1.1195 271 12/1/2017
1.3.1.1194 271 12/1/2017
1.3.1.1193 271 12/1/2017
1.3.1.1171 323 10/17/2017
1.3.1.1163 361 7/5/2017
1.3.1.1160 308 6/21/2017
1.3.1.1159 311 6/21/2017
1.3.1.1155 332 6/20/2017
1.3.1.1153 324 6/19/2017
1.3.1.1151 293 6/16/2017
1.3.1.1148 315 6/15/2017
1.3.0.1144 308 6/12/2017
1.3.0.1141 343 6/9/2017
1.3.0.1137 330 5/12/2017
1.3.0.1135 299 5/11/2017
1.3.0.1134 304 5/11/2017
1.3.0.1131 305 5/6/2017
1.3.0.1130 313 5/6/2017
1.3.0.1129 308 5/5/2017
1.3.0.1128 313 5/5/2017
1.2.0.1118 291 5/4/2017
1.2.0.1116 311 5/4/2017
1.2.0.1114 300 5/4/2017
1.2.0.1112 302 5/4/2017
1.2.0.1111 306 5/3/2017
1.2.0.1107 311 5/2/2017
1.2.0.1104 311 4/29/2017
1.2.0.1103 292 4/28/2017
1.2.0.1101 294 4/28/2017
1.2.0.1095 306 4/27/2017
1.2.0.1092 321 4/18/2017
1.2.0.1088 313 4/17/2017
1.2.0.1087 309 4/17/2017
1.2.0.1086 308 4/17/2017
1.2.0.1085 309 4/17/2017
1.2.0.1084 309 4/17/2017
1.2.0.1072-rc1 283 4/14/2017
1.2.0.1071-rc1 283 4/14/2017
1.2.0.1064-rc1 281 4/1/2017
1.2.0.1061-rc1 290 3/31/2017
1.2.0.1059-rc1 274 3/29/2017
1.2.0.1057-rc1 276 3/28/2017
1.2.0.1055-rc1 265 3/28/2017
1.1.1.1044 307 3/24/2017
1.1.1.1040 314 3/19/2017
1.1.1.1004 328 3/10/2017
1.1.1.1002 312 3/9/2017
1.1.1.1000 366 2/1/2017
1.1.1.998 318 1/31/2017
1.1.1.996 409 12/15/2016
1.1.1.991 380 11/28/2016
1.1.1.989 904 9/22/2016
1.1.1.987 331 9/22/2016
1.1.1.986 313 9/22/2016
1.1.1.985 332 9/22/2016
1.1.1.982 397 8/24/2016
1.1.1.980 332 8/24/2016
1.1.1.979 346 8/22/2016
1.1.0.975 330 8/22/2016
1.1.0.973 339 8/22/2016
1.1.0.972 337 8/22/2016
1.1.0.971 342 8/18/2016
1.1.0.970 344 8/16/2016
1.1.0.967 335 8/15/2016
1.1.0.966 330 8/15/2016
1.1.0.964 339 8/11/2016
1.1.0.963 359 8/9/2016
1.1.0.961 334 8/9/2016
1.1.0.960 323 8/9/2016
1.1.0.959 324 8/8/2016
1.1.0.957 347 8/7/2016
1.1.0.956 339 8/7/2016
1.1.0.947-rc 288 8/6/2016
1.1.0.946-rc 327 8/5/2016
1.1.0.945 351 8/5/2016
1.1.0.942 390 7/27/2016
1.1.0.941 373 7/27/2016
1.1.0.939 350 7/27/2016
1.1.0.938 355 7/27/2016
1.1.0.936 375 7/26/2016
1.1.0.935 369 7/26/2016
1.1.0.932 365 7/25/2016
1.1.0.930 371 7/23/2016
1.1.0.929 368 7/23/2016
1.1.0.928 341 7/22/2016
1.1.0.927 367 7/22/2016
1.1.0.924 367 7/22/2016
1.1.0.923 347 7/21/2016
1.1.0.918 352 7/20/2016
1.1.0.915 323 7/20/2016
1.1.0.912 344 7/20/2016
1.1.0.910 326 7/20/2016
1.1.0.904 337 7/19/2016
1.1.0.903 332 7/18/2016
1.1.0.902 337 7/18/2016
1.1.0.901 349 7/18/2016
1.1.0.887 352 7/16/2016
1.1.0.886 355 7/16/2016
1.1.0.883 491 7/14/2016
1.1.0.879 477 7/13/2016
1.1.0.877 502 7/12/2016
1.1.0.864 344 7/9/2016
1.1.0.863 369 7/9/2016
1.1.0.859 361 7/8/2016
1.1.0.858 368 7/8/2016
1.1.0.857 366 7/6/2016
1.1.0.856 364 6/29/2016
1.1.0.855 334 6/28/2016
1.1.0.854 333 6/25/2016
1.0.1.851-rc 320 6/17/2016
1.0.1.849-rc 316 6/17/2016
1.0.1.842-rc 325 6/9/2016
1.0.1.841-rc 322 6/9/2016
1.0.1.839-rc 317 6/9/2016
1.0.1.837-rc 418 5/31/2016
1.0.1.835-rc 316 5/26/2016
1.0.1.834-rc 315 5/24/2016
1.0.1.833-rc 331 5/20/2016
1.0.1.832-rc 324 5/20/2016
1.0.1.828-rc 314 5/9/2016
1.0.1.827-rc 311 5/7/2016
1.0.1.826-rc 319 5/2/2016
1.0.1.824-rc 312 5/1/2016
1.0.1.823-rc 326 4/21/2016
1.0.1.822-rc 308 4/20/2016
1.0.1.821-rc 308 4/11/2016
1.0.1.819-rc 324 4/11/2016
1.0.1.818-rc 314 4/8/2016
1.0.1.817-rc 317 4/7/2016
1.0.1.813-rc 327 4/7/2016
1.0.1.812-rc 318 3/30/2016
1.0.1.811-rc 321 3/30/2016
1.0.1.810-rc 330 3/30/2016
1.0.1.808-rc 316 3/30/2016
1.0.1.807-rc 339 3/29/2016
1.0.1.806-rc 319 3/29/2016
1.0.1.805-rc 333 3/29/2016
1.0.1.796-rc 315 3/27/2016
1.0.1.793-rc 308 3/27/2016
1.0.1.788-rc 323 3/26/2016
1.0.1.785-rc 309 3/26/2016
1.0.1.778-rc 330 3/22/2016
1.0.1.777-rc 320 3/22/2016
1.0.1.776-rc 345 3/18/2016
1.0.1.775-rc 322 3/18/2016
1.0.1.774-rc 325 3/16/2016
1.0.1.773-rc 313 3/16/2016
1.0.1.771-rc 321 3/15/2016
1.0.1.769-rc 314 3/15/2016
1.0.1.765-rc 308 3/15/2016
1.0.1.764-rc 332 3/15/2016
1.0.1.759-rc 361 3/14/2016
1.0.1.758-rc 314 3/14/2016
1.0.1.757-rc 317 3/14/2016
1.0.1.752-rc 329 3/13/2016
1.0.1.748-rc 343 3/13/2016
1.0.1.747-rc 368 3/13/2016
1.0.1.746-rc 315 3/13/2016
1.0.1.743-rc 327 3/9/2016
1.0.1.742-rc 339 3/8/2016
1.0.1.741-rc 327 3/8/2016
1.0.1.740-rc 328 3/7/2016
1.0.1.736-rc 334 3/7/2016
1.0.1.735-rc 329 3/7/2016
1.0.1.729-rc 330 3/6/2016
1.0.1.728-rc 330 3/6/2016
1.0.1.726-rc 350 3/6/2016
1.0.1.724-rc 358 3/4/2016
1.0.1.723-rc 313 3/3/2016
1.0.1.722-rc 314 3/3/2016
1.0.1.721-rc 327 3/3/2016
1.0.1.719-rc 344 3/2/2016
1.0.1.717-rc 326 3/1/2016
1.0.1.716-rc 329 2/28/2016
1.0.1.711-rc 320 2/28/2016
1.0.1.709-rc 311 2/27/2016
1.0.1.708-rc 337 2/27/2016
1.0.1.707-rc 311 2/27/2016
1.0.1.706-rc 347 2/26/2016
1.0.1.705-rc 331 2/26/2016
1.0.1.701-rc 319 2/25/2016
1.0.1.699-rc 329 2/23/2016
1.0.1.696-rc 346 2/21/2016
1.0.1.693-rc 336 2/20/2016
1.0.1.691-rc 347 2/19/2016
1.0.1.689-rc 315 2/19/2016
1.0.1.684-rc 351 2/18/2016
1.0.1.683-rc 313 2/18/2016
1.0.1.676-rc 346 2/17/2016
1.0.1.673-rc 337 2/17/2016
1.0.1.670-rc 316 2/17/2016
1.0.1.665-rc 322 2/15/2016
1.0.1.663-rc 360 2/14/2016
1.0.1.659-rc 321 2/14/2016
1.0.1.657-rc 307 2/14/2016
1.0.1.654-rc 327 2/14/2016
1.0.1.648-rc 374 2/13/2016
1.0.1.647-rc 366 2/13/2016
1.0.1.632-rc 323 2/11/2016
1.0.1.631-rc 329 2/11/2016
1.0.1.626-rc 321 2/10/2016
1.0.1.625-rc 326 2/10/2016
1.0.1.609-rc 365 2/4/2016
1.0.1.605-rc 397 2/4/2016
1.0.1.604-rc 330 2/4/2016
1.0.1.600-rc 333 1/28/2016
1.0.1.597-rc 340 1/27/2016
1.0.1.596-rc 339 1/26/2016
1.0.1.595-rc 349 1/22/2016
1.0.1.593-rc 352 1/22/2016
1.0.1.590-rc 338 1/21/2016
1.0.1.588-rc 343 1/20/2016
1.0.1.583-rc 313 1/20/2016
1.0.1.582-rc 327 1/20/2016
1.0.1.574-rc 357 1/19/2016
1.0.1.571-rc 319 1/19/2016
1.0.1.570-rc 335 1/18/2016
1.0.1.569-rc 318 1/17/2016
1.0.1.568-rc 326 1/15/2016
1.0.1.565-rc 348 1/8/2016
1.0.1.564-rc 336 1/8/2016
1.0.1.561-rc 317 1/6/2016
1.0.1.557-rc 353 1/3/2016
1.0.1.554-rc 402 12/22/2015
1.0.1.553-rc 386 12/22/2015
1.0.1.552-rc 426 12/22/2015
1.0.1.551-rc 365 12/21/2015
1.0.1.550-rc 363 12/20/2015
1.0.1.545-rc 349 12/17/2015
1.0.1.543-rc 363 12/17/2015
1.0.1.542-rc 335 12/16/2015
1.0.1.539-rc 368 12/16/2015
1.0.1.525-rc 337 12/16/2015
1.0.1.521-rc 325 12/15/2015
1.0.1.512-rc 343 12/14/2015
1.0.1.508-rc 324 12/14/2015
1.0.1.505-rc 330 12/14/2015
1.0.0.492-rc 397 12/11/2015
1.0.0.491-rc 355 12/11/2015
1.0.0.488-rc 388 12/11/2015
1.0.0.487-rc 329 12/11/2015
1.0.0.485-rc 390 12/9/2015
1.0.0.481-rc 332 12/8/2015
1.0.0.479-rc 358 12/7/2015
1.0.0.473-rc 346 12/6/2015
1.0.0.472-rc 329 12/3/2015
1.0.0.469-rc 368 12/1/2015
1.0.0.465-rc 335 11/19/2015
1.0.0.464-rc 365 11/16/2015
1.0.0.458-rc 366 11/3/2015
1.0.0.448-rc 366 10/27/2015
1.0.0.447-rc 363 10/27/2015
1.0.0.446-rc 345 10/27/2015
1.0.0.443-rc 361 10/27/2015
1.0.0.441-rc 354 10/26/2015
1.0.0.436-rc 332 10/26/2015
1.0.0.434-rc 362 10/26/2015
1.0.0.433-rc 373 10/26/2015
0.9.1.426 682 10/8/2015
0.9.1.424 384 10/6/2015
0.9.1.418 413 9/29/2015
0.9.1.415 396 9/29/2015
0.9.1.411 393 9/28/2015
0.9.1.408 404 9/3/2015
0.9.1.407 387 8/18/2015
0.9.1.406 472 8/13/2015
0.9.1.405 357 8/13/2015
0.9.1.404 424 8/13/2015
0.9.1.401 451 7/21/2015
0.9.1.395 433 7/5/2015
0.9.1.394 378 7/4/2015
0.9.1.393 374 7/4/2015
0.9.1.390 413 6/13/2015
0.9.1.388 419 6/13/2015
0.9.1.386 368 6/13/2015
0.9.1.385 399 6/12/2015
0.9.1.382 388 6/12/2015
0.9.1.381 412 6/12/2015
0.9.1.380 373 6/12/2015
0.9.1.378 409 6/12/2015
0.9.1.375 452 2/27/2015
0.9.1.373 469 2/25/2015
0.9.1.370 387 2/25/2015
0.9.1.367 449 2/23/2015
0.9.1.365 387 2/21/2015
0.9.1.361 475 2/21/2015
0.9.1.358 482 2/16/2015
0.9.1.357 388 2/11/2015
0.9.0.355 518 2/10/2015
0.9.0.354 399 2/1/2015
0.9.0.353 444 1/30/2015
0.9.0.350 470 1/29/2015
0.9.0.338 399 1/12/2015
0.9.0.328 410 11/25/2014
0.9.0.326 399 11/24/2014
0.9.0.325 401 11/24/2014
0.9.0.323 456 11/23/2014
0.9.0.313 474 11/22/2014
0.9.0.299 546 11/12/2014
0.9.0.295 673 11/12/2014
0.9.0.290 546 11/11/2014
0.9.0.279 752 11/9/2014
0.9.0.269 677 11/6/2014
0.9.0.268 864 11/4/2014
0.9.0.266 1,157 11/3/2014
0.9.0.265 647 11/3/2014
0.9.0.263 892 11/3/2014
0.9.0.262 723 11/3/2014
0.9.0.249 412 10/27/2014
0.9.0.236 421 10/25/2014
0.9.0.234 419 10/24/2014
0.9.0.233 402 10/21/2014
0.9.0.227 396 10/21/2014
0.9.0.226 402 10/21/2014
0.9.0.225 432 10/21/2014
0.9.0.222 407 10/19/2014
0.9.0.221 403 10/19/2014
0.9.0.204 399 10/17/2014
0.9.0.200 399 10/15/2014
0.9.0.199 443 10/15/2014
0.9.0.193 399 10/14/2014
0.9.0.189 418 10/14/2014
0.9.0.184-test 396 10/14/2014
0.9.0.183-test 379 10/13/2014
0.9.0.179 431 10/13/2014
0.9.0.174 410 10/13/2014
0.6.0.173 391 10/13/2014
0.6.0.165 449 10/3/2014
0.6.0.160 436 9/18/2014
0.6.0.157 448 9/18/2014
0.6.0.155 414 9/18/2014
0.6.0.151 410 9/17/2014
0.6.0.147 444 9/16/2014
0.6.0.143 433 9/12/2014
0.6.0.141 417 9/10/2014
0.6.0.139 432 9/3/2014
0.6.0.135 403 8/21/2014
0.6.0.134 456 8/8/2014
0.6.0.130 457 8/4/2014
0.6.0.127 422 7/1/2014
0.6.0.101 505 1/21/2014
0.6.0.97 429 1/16/2014
0.5.0.51 507 1/5/2014
0.5.0.36 421 12/9/2013
0.5.0.35 463 12/8/2013
0.5.0.28 451 12/1/2013
Show less