Shaolinq.Postgres 1.2.0.1088

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!

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

Release Notes

- New DataAccessModelConfiguration AlwaysSubmitDefaultValues setting
- Add support for DataAccessModel hooks
- Support Configuration option ValueTypesAutoImplicitDefault value type so they don't get given default values on instantiation of the parent DAO unless a value is specified using DefaultValueAttribute. Attempts to commit incomplete objects result in a MissingPropertyValueException.
-- Previous --
- Fixed bug where including properties using a lambda over a generic type class or function type fails
- Support explicit naming of foreign keys via
NamingTransformsConfiguration
- Support explicit naming of primary keys via NamingTransformsConfiguration
- SqlServerProvider: Don't add NOT NULL conditions on index columns if index is not unique
- Support disabling foreign key constraints on DAO properties and BackReferences via ForeignObjectConstraintAttribute.Disabled
- Added UniqueNullIndexAnsiComplianceFixerClassicBehaviour
- Improved performance DataAccessModel.BuildDataAccessModel(Type)
- Added better support for explicitly setting identity columns.
- Added AutoIncrementAttribute.ValidateExpression support allowing declarative skipping of autoincrement values.
- Fix bug where TransactionContext for null transactions (before most outer DataAccessScope) could be replaced with TransactionContexts from inner scopes.
- Various other transaction and async related fixes
- Fix ambient TransactionContext sometimes not being disposed (like on initialisation of DataAccessModel)
- Changed TransactionContext to have to be acquired in a using statement in order to be created. Transactioncontext.GetCurrent() will only return non-null if there is already a current transaction. Fixes leaky ambient DataAccessObjectDataContexts.
- RewriteAsync now validates manually written async methods to make sure they're not calling sync methods when async equivalents are available.
- RewriteAsync now supports searching all types for a matching extension method that can be used for async (rather than just the type that defined the non-async method).
- Added more connection configuration properties to Postgres (KeepAlive, others)
- AsyncRewriter improvements
- Fixed InvalidCastException when saving a property using a  predicated deflated references where the referenced type is not the same as the property container type.
- Fixed OrderBy sometimes ignored with some queries (e.g. GroupBy)
- Added SumAsync(selector) method for decimal and decimal?
- Fix potential exception when projecting structs
- Fixed potential memory leak when querying with similarly structured queries with different constant values
- Fixed ForUpdate not working when using Aggregates after ForUpdate is applied
- Added SumAsync(Decimal) support
- Fixed exception when using Enums with no declared values
- Fixed Insert/Update of predicated deflated references

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.9.5 95 1/17/2020
1.9.4.1454-refs-pull-97-merge 91 9/18/2019
1.9.4.1453-refs-pull-97-head 66 9/18/2019
1.9.4.1452-refs-pull-96-merge 64 9/18/2019
1.9.4.1451-refs-pull-96-head 64 9/18/2019
1.9.4.1450-refs-pull-95-merge 66 9/18/2019
1.9.4.1449-refs-pull-95-head 64 9/18/2019
1.9.4 325 11/9/2018
1.9.3.1445-fix-null-enum-bug 146 11/9/2018
1.9.3 146 11/9/2018
1.9.1.1438-feature-allow-re... 156 10/23/2018
1.9.1 165 10/23/2018
1.9.0.1437-feature-model-ge... 158 10/21/2018
1.9.0.1435-fix-query-cachin... 165 10/18/2018
1.9.0 167 10/18/2018
1.8.15 160 10/17/2018
1.8.14.1433-fix-nested-quer... 155 10/17/2018
1.8.14 158 10/16/2018
1.8.13.1429-fix-fix-nested-... 159 10/15/2018
1.8.13 165 10/15/2018
1.8.12 202 10/2/2018
1.8.11.1420-feature-allow-i... 169 10/2/2018
1.8.11.1419-feature-allow-i... 176 10/1/2018
1.8.11.1418-feature-allow-i... 190 10/1/2018
1.8.11 175 9/25/2018
1.8.10.1416-fix-distinct-co... 170 9/25/2018
1.8.10 224 8/16/2018
1.8.9 207 8/16/2018
1.8.8.1409-feature-sqlserve... 193 8/13/2018
1.8.8 191 8/10/2018
1.8.7.1404-fix-sql-index-an... 185 8/10/2018
1.8.7 210 8/10/2018
1.8.6 201 8/8/2018
1.8.4.1394-feature-exclude-... 227 8/7/2018
1.8.4 215 8/7/2018
1.8.3.1391-feature-unique-i... 228 8/7/2018
1.8.3 236 8/6/2018
1.8.2.1387-fix-support-over... 230 8/6/2018
1.8.2 236 8/2/2018
1.8.1.1384-fix-computed-mem... 202 8/1/2018
1.8.1.1383-fix-computed-mem... 207 8/1/2018
1.8.1 237 7/29/2018
1.8.0 232 7/28/2018
1.7.2 217 7/23/2018
1.7.1 217 7/22/2018
1.7.0.1340-feature-support-... 221 7/22/2018
1.7.0.1338-feature-support-... 194 7/22/2018
1.7.0 210 7/22/2018
1.6.0.1329-feature-naming-t... 219 7/21/2018
1.5.0.1304 236 7/20/2018
1.5.0.1303-feature-class-le... 203 7/20/2018
1.5.0.1300 293 6/4/2018
1.5.0.1296-fix-datacontext-... 346 5/6/2018
1.5.0.1295 306 4/26/2018
1.5.0.1294 263 4/26/2018
1.5.0.1285 331 2/6/2018
1.5.0.1285-asynchooks-test 302 2/6/2018
1.5.0.1280-asynchooks-test 281 2/5/2018
1.3.1.1240 328 1/23/2018
1.3.1.1208 344 1/17/2018
1.3.1.1207 300 1/8/2018
1.3.1.1206 314 1/8/2018
1.3.1.1204 301 1/3/2018
1.3.1.1198 313 12/21/2017
1.3.1.1195 263 12/1/2017
1.3.1.1194 263 12/1/2017
1.3.1.1193 263 12/1/2017
1.3.1.1171 315 10/17/2017
1.3.1.1163 355 7/5/2017
1.3.1.1160 302 6/21/2017
1.3.1.1159 302 6/21/2017
1.3.1.1155 323 6/20/2017
1.3.1.1153 316 6/19/2017
1.3.1.1151 285 6/16/2017
1.3.1.1148 308 6/15/2017
1.3.0.1144 301 6/12/2017
1.3.0.1141 335 6/9/2017
1.3.0.1137 322 5/12/2017
1.3.0.1135 291 5/11/2017
1.3.0.1134 296 5/11/2017
1.3.0.1131 298 5/6/2017
1.3.0.1130 305 5/6/2017
1.3.0.1129 300 5/5/2017
1.3.0.1128 305 5/5/2017
1.2.0.1118 283 5/4/2017
1.2.0.1116 303 5/4/2017
1.2.0.1114 294 5/4/2017
1.2.0.1112 296 5/4/2017
1.2.0.1111 298 5/3/2017
1.2.0.1107 301 5/2/2017
1.2.0.1104 303 4/29/2017
1.2.0.1103 284 4/28/2017
1.2.0.1101 287 4/28/2017
1.2.0.1095 299 4/27/2017
1.2.0.1092 315 4/18/2017
1.2.0.1088 307 4/17/2017
1.2.0.1087 302 4/17/2017
1.2.0.1086 301 4/17/2017
1.2.0.1085 302 4/17/2017
1.2.0.1084 302 4/17/2017
1.2.0.1072-rc1 276 4/14/2017
1.2.0.1071-rc1 276 4/14/2017
1.2.0.1064-rc1 275 4/1/2017
1.2.0.1061-rc1 285 3/31/2017
1.2.0.1059-rc1 266 3/29/2017
1.2.0.1057-rc1 269 3/28/2017
1.2.0.1055-rc1 260 3/28/2017
1.1.1.1044 301 3/24/2017
1.1.1.1040 306 3/19/2017
1.1.1.1004 320 3/10/2017
1.1.1.1002 306 3/9/2017
1.1.1.1000 360 2/1/2017
1.1.1.998 308 1/31/2017
1.1.1.996 400 12/15/2016
1.1.1.991 371 11/28/2016
1.1.1.989 895 9/22/2016
1.1.1.987 324 9/22/2016
1.1.1.986 306 9/22/2016
1.1.1.985 324 9/22/2016
1.1.1.982 387 8/24/2016
1.1.1.980 322 8/24/2016
1.1.1.979 336 8/22/2016
1.1.0.975 321 8/22/2016
1.1.0.973 331 8/22/2016
1.1.0.972 329 8/22/2016
1.1.0.971 334 8/18/2016
1.1.0.970 334 8/16/2016
1.1.0.967 326 8/15/2016
1.1.0.966 322 8/15/2016
1.1.0.964 331 8/11/2016
1.1.0.963 350 8/9/2016
1.1.0.961 325 8/9/2016
1.1.0.960 313 8/9/2016
1.1.0.959 314 8/8/2016
1.1.0.957 338 8/7/2016
1.1.0.956 330 8/7/2016
1.1.0.947-rc 281 8/6/2016
1.1.0.946-rc 320 8/5/2016
1.1.0.945 342 8/5/2016
1.1.0.942 380 7/27/2016
1.1.0.941 364 7/27/2016
1.1.0.939 341 7/27/2016
1.1.0.938 348 7/27/2016
1.1.0.936 367 7/26/2016
1.1.0.935 359 7/26/2016
1.1.0.932 356 7/25/2016
1.1.0.930 362 7/23/2016
1.1.0.929 360 7/23/2016
1.1.0.928 334 7/22/2016
1.1.0.927 360 7/22/2016
1.1.0.924 358 7/22/2016
1.1.0.923 339 7/21/2016
1.1.0.918 344 7/20/2016
1.1.0.915 316 7/20/2016
1.1.0.912 336 7/20/2016
1.1.0.910 318 7/20/2016
1.1.0.904 330 7/19/2016
1.1.0.903 325 7/18/2016
1.1.0.902 329 7/18/2016
1.1.0.901 340 7/18/2016
1.1.0.887 345 7/16/2016
1.1.0.886 348 7/16/2016
1.1.0.883 484 7/14/2016
1.1.0.879 469 7/13/2016
1.1.0.877 493 7/12/2016
1.1.0.864 336 7/9/2016
1.1.0.863 361 7/9/2016
1.1.0.859 353 7/8/2016
1.1.0.858 361 7/8/2016
1.1.0.857 359 7/6/2016
1.1.0.856 356 6/29/2016
1.1.0.855 326 6/28/2016
1.1.0.854 325 6/25/2016
1.0.1.851-rc 314 6/17/2016
1.0.1.849-rc 310 6/17/2016
1.0.1.842-rc 319 6/9/2016
1.0.1.841-rc 315 6/9/2016
1.0.1.839-rc 310 6/9/2016
1.0.1.837-rc 411 5/31/2016
1.0.1.835-rc 309 5/26/2016
1.0.1.834-rc 308 5/24/2016
1.0.1.833-rc 324 5/20/2016
1.0.1.832-rc 317 5/20/2016
1.0.1.828-rc 307 5/9/2016
1.0.1.827-rc 304 5/7/2016
1.0.1.826-rc 311 5/2/2016
1.0.1.824-rc 305 5/1/2016
1.0.1.823-rc 319 4/21/2016
1.0.1.822-rc 302 4/20/2016
1.0.1.821-rc 303 4/11/2016
1.0.1.819-rc 317 4/11/2016
1.0.1.818-rc 307 4/8/2016
1.0.1.817-rc 310 4/7/2016
1.0.1.813-rc 319 4/7/2016
1.0.1.812-rc 312 3/30/2016
1.0.1.811-rc 315 3/30/2016
1.0.1.810-rc 323 3/30/2016
1.0.1.808-rc 309 3/30/2016
1.0.1.807-rc 331 3/29/2016
1.0.1.806-rc 312 3/29/2016
1.0.1.805-rc 327 3/29/2016
1.0.1.796-rc 309 3/27/2016
1.0.1.793-rc 301 3/27/2016
1.0.1.788-rc 316 3/26/2016
1.0.1.785-rc 304 3/26/2016
1.0.1.778-rc 325 3/22/2016
1.0.1.777-rc 312 3/22/2016
1.0.1.776-rc 336 3/18/2016
1.0.1.775-rc 315 3/18/2016
1.0.1.774-rc 318 3/16/2016
1.0.1.773-rc 305 3/16/2016
1.0.1.771-rc 313 3/15/2016
1.0.1.769-rc 307 3/15/2016
1.0.1.765-rc 300 3/15/2016
1.0.1.764-rc 323 3/15/2016
1.0.1.759-rc 352 3/14/2016
1.0.1.758-rc 305 3/14/2016
1.0.1.757-rc 309 3/14/2016
1.0.1.752-rc 321 3/13/2016
1.0.1.748-rc 333 3/13/2016
1.0.1.747-rc 357 3/13/2016
1.0.1.746-rc 306 3/13/2016
1.0.1.743-rc 320 3/9/2016
1.0.1.742-rc 332 3/8/2016
1.0.1.741-rc 320 3/8/2016
1.0.1.740-rc 321 3/7/2016
1.0.1.736-rc 328 3/7/2016
1.0.1.735-rc 323 3/7/2016
1.0.1.729-rc 325 3/6/2016
1.0.1.728-rc 325 3/6/2016
1.0.1.726-rc 343 3/6/2016
1.0.1.724-rc 351 3/4/2016
1.0.1.723-rc 305 3/3/2016
1.0.1.722-rc 306 3/3/2016
1.0.1.721-rc 319 3/3/2016
1.0.1.719-rc 338 3/2/2016
1.0.1.717-rc 320 3/1/2016
1.0.1.716-rc 323 2/28/2016
1.0.1.711-rc 314 2/28/2016
1.0.1.709-rc 305 2/27/2016
1.0.1.708-rc 330 2/27/2016
1.0.1.707-rc 304 2/27/2016
1.0.1.706-rc 339 2/26/2016
1.0.1.705-rc 323 2/26/2016
1.0.1.701-rc 311 2/25/2016
1.0.1.699-rc 321 2/23/2016
1.0.1.696-rc 340 2/21/2016
1.0.1.693-rc 330 2/20/2016
1.0.1.691-rc 341 2/19/2016
1.0.1.689-rc 309 2/19/2016
1.0.1.684-rc 345 2/18/2016
1.0.1.683-rc 307 2/18/2016
1.0.1.676-rc 339 2/17/2016
1.0.1.673-rc 330 2/17/2016
1.0.1.670-rc 310 2/17/2016
1.0.1.665-rc 316 2/15/2016
1.0.1.663-rc 353 2/14/2016
1.0.1.659-rc 314 2/14/2016
1.0.1.657-rc 300 2/14/2016
1.0.1.654-rc 320 2/14/2016
1.0.1.648-rc 366 2/13/2016
1.0.1.647-rc 357 2/13/2016
1.0.1.632-rc 318 2/11/2016
1.0.1.631-rc 324 2/11/2016
1.0.1.626-rc 314 2/10/2016
1.0.1.625-rc 319 2/10/2016
1.0.1.609-rc 357 2/4/2016
1.0.1.605-rc 389 2/4/2016
1.0.1.604-rc 323 2/4/2016
1.0.1.600-rc 326 1/28/2016
1.0.1.597-rc 334 1/27/2016
1.0.1.596-rc 333 1/26/2016
1.0.1.595-rc 334 1/22/2016
1.0.1.593-rc 336 1/22/2016
1.0.1.590-rc 323 1/21/2016
1.0.1.588-rc 326 1/20/2016
1.0.1.583-rc 306 1/20/2016
1.0.1.582-rc 320 1/20/2016
1.0.1.574-rc 349 1/19/2016
1.0.1.571-rc 306 1/19/2016
1.0.1.570-rc 320 1/18/2016
1.0.1.569-rc 310 1/17/2016
1.0.1.568-rc 319 1/15/2016
1.0.1.565-rc 341 1/8/2016
1.0.1.564-rc 329 1/8/2016
1.0.1.561-rc 310 1/6/2016
1.0.1.557-rc 346 1/3/2016
1.0.1.554-rc 394 12/22/2015
1.0.1.553-rc 378 12/22/2015
1.0.1.552-rc 418 12/22/2015
1.0.1.551-rc 358 12/21/2015
1.0.1.550-rc 354 12/20/2015
1.0.1.545-rc 342 12/17/2015
1.0.1.543-rc 356 12/17/2015
1.0.1.542-rc 327 12/16/2015
1.0.1.539-rc 360 12/16/2015
1.0.1.525-rc 329 12/16/2015
1.0.1.521-rc 317 12/15/2015
1.0.1.512-rc 338 12/14/2015
1.0.1.508-rc 319 12/14/2015
1.0.1.505-rc 323 12/14/2015
1.0.0.492-rc 389 12/11/2015
1.0.0.491-rc 348 12/11/2015
1.0.0.488-rc 380 12/11/2015
1.0.0.487-rc 322 12/11/2015
1.0.0.485-rc 382 12/9/2015
1.0.0.481-rc 326 12/8/2015
1.0.0.479-rc 352 12/7/2015
1.0.0.473-rc 340 12/6/2015
1.0.0.472-rc 323 12/3/2015
1.0.0.469-rc 362 12/1/2015
1.0.0.465-rc 329 11/19/2015
1.0.0.464-rc 359 11/16/2015
1.0.0.458-rc 360 11/3/2015
1.0.0.448-rc 361 10/27/2015
1.0.0.447-rc 358 10/27/2015
1.0.0.446-rc 339 10/27/2015
1.0.0.443-rc 355 10/27/2015
1.0.0.441-rc 345 10/26/2015
1.0.0.436-rc 325 10/26/2015
1.0.0.434-rc 357 10/26/2015
1.0.0.433-rc 368 10/26/2015
0.9.1.426 672 10/8/2015
0.9.1.424 374 10/6/2015
0.9.1.418 404 9/29/2015
0.9.1.415 387 9/29/2015
0.9.1.411 382 9/28/2015
0.9.1.408 394 9/3/2015
0.9.1.407 378 8/18/2015
0.9.1.406 453 8/13/2015
0.9.1.405 349 8/13/2015
0.9.1.404 405 8/13/2015
0.9.1.401 441 7/21/2015
0.9.1.395 423 7/5/2015
0.9.1.394 369 7/4/2015
0.9.1.393 365 7/4/2015
0.9.1.390 404 6/13/2015
0.9.1.388 410 6/13/2015
0.9.1.386 360 6/13/2015
0.9.1.385 391 6/12/2015
0.9.1.382 379 6/12/2015
0.9.1.381 403 6/12/2015
0.9.1.380 365 6/12/2015
0.9.1.378 401 6/12/2015
0.9.1.375 444 2/27/2015
0.9.1.373 462 2/25/2015
0.9.1.370 379 2/25/2015
0.9.1.367 441 2/23/2015
0.9.1.365 377 2/21/2015
0.9.1.361 465 2/21/2015
0.9.1.358 472 2/16/2015
0.9.1.357 378 2/11/2015
0.9.0.355 509 2/10/2015
0.9.0.354 390 2/1/2015
0.9.0.353 435 1/30/2015
0.9.0.350 461 1/29/2015
0.9.0.338 390 1/12/2015
0.9.0.328 401 11/25/2014
0.9.0.326 391 11/24/2014
0.9.0.325 393 11/24/2014
0.9.0.323 448 11/23/2014
0.9.0.313 466 11/22/2014
0.9.0.299 537 11/12/2014
0.9.0.295 664 11/12/2014
0.9.0.290 536 11/11/2014
0.9.0.279 742 11/9/2014
0.9.0.269 668 11/6/2014
0.9.0.268 855 11/4/2014
0.9.0.266 1,148 11/3/2014
0.9.0.265 638 11/3/2014
0.9.0.263 883 11/3/2014
0.9.0.262 714 11/3/2014
0.9.0.249 403 10/27/2014
0.9.0.236 412 10/25/2014
0.9.0.234 410 10/24/2014
0.9.0.233 393 10/21/2014
0.9.0.227 387 10/21/2014
0.9.0.226 393 10/21/2014
0.9.0.225 424 10/21/2014
0.9.0.222 399 10/19/2014
0.9.0.221 393 10/19/2014
0.9.0.204 389 10/17/2014
0.9.0.200 390 10/15/2014
0.9.0.199 435 10/15/2014
0.9.0.193 390 10/14/2014
0.9.0.189 409 10/14/2014
0.9.0.184-test 389 10/14/2014
0.9.0.183-test 372 10/13/2014
0.9.0.179 423 10/13/2014
0.9.0.174 402 10/13/2014
0.6.0.173 384 10/13/2014
0.6.0.165 442 10/3/2014
0.6.0.160 427 9/18/2014
0.6.0.157 439 9/18/2014
0.6.0.155 405 9/18/2014
0.6.0.151 401 9/17/2014
0.6.0.147 436 9/16/2014
0.6.0.143 425 9/12/2014
0.6.0.141 409 9/10/2014
0.6.0.139 424 9/3/2014
0.6.0.135 394 8/21/2014
0.6.0.134 447 8/8/2014
0.6.0.130 450 8/4/2014
0.6.0.127 415 7/1/2014
0.6.0.101 497 1/21/2014
0.6.0.97 421 1/16/2014
0.5.0.51 497 1/5/2014
0.5.0.36 411 12/9/2013
0.5.0.35 454 12/8/2013
0.5.0.28 442 12/1/2013
Show less