Shaolinq.Postgres 0.9.1.405

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

Release Notes

- Allow direct configuration with connection strings
Previous Versions:
- Fixed sometimes queries failing if referencing a primary key on a DAO property
- Fixed Any function sometimes not working
- Allow DAO types to be defined in other assemblies
- SQL server provider now always disables enlistment
- Switch to using ConfigurationManager for configs
- Added TransactionScopeFactory
- Removed dependency on EF
- Support for ConnectionString rather than pure object or XML configuration
- Added Azure friendly DeleteDatabaseDropsTablesOnly option for SqlServer
- Added Azure friendly DisabledForeignKeyContext
- Support OrderBy in sub-queries on SQL server
- Support for projecting IGrouping when aggregates are both used and not used.
- 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

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.9.5 0 1/17/2020
1.9.4.1454-refs-pull-97-merge 86 9/18/2019
1.9.4.1453-refs-pull-97-head 65 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 65 9/18/2019
1.9.4.1449-refs-pull-95-head 64 9/18/2019
1.9.4 320 11/9/2018
1.9.3.1445-fix-null-enum-bug 145 11/9/2018
1.9.3 144 11/9/2018
1.9.1.1438-feature-allow-re... 154 10/23/2018
1.9.1 163 10/23/2018
1.9.0.1437-feature-model-ge... 156 10/21/2018
1.9.0.1435-fix-query-cachin... 163 10/18/2018
1.9.0 166 10/18/2018
1.8.15 158 10/17/2018
1.8.14.1433-fix-nested-quer... 153 10/17/2018
1.8.14 156 10/16/2018
1.8.13.1429-fix-fix-nested-... 158 10/15/2018
1.8.13 163 10/15/2018
1.8.12 201 10/2/2018
1.8.11.1420-feature-allow-i... 168 10/2/2018
1.8.11.1419-feature-allow-i... 174 10/1/2018
1.8.11.1418-feature-allow-i... 188 10/1/2018
1.8.11 174 9/25/2018
1.8.10.1416-fix-distinct-co... 169 9/25/2018
1.8.10 223 8/16/2018
1.8.9 207 8/16/2018
1.8.8.1409-feature-sqlserve... 193 8/13/2018
1.8.8 190 8/10/2018
1.8.7.1404-fix-sql-index-an... 184 8/10/2018
1.8.7 209 8/10/2018
1.8.6 199 8/8/2018
1.8.4.1394-feature-exclude-... 225 8/7/2018
1.8.4 214 8/7/2018
1.8.3.1391-feature-unique-i... 226 8/7/2018
1.8.3 233 8/6/2018
1.8.2.1387-fix-support-over... 229 8/6/2018
1.8.2 233 8/2/2018
1.8.1.1384-fix-computed-mem... 201 8/1/2018
1.8.1.1383-fix-computed-mem... 206 8/1/2018
1.8.1 236 7/29/2018
1.8.0 231 7/28/2018
1.7.2 216 7/23/2018
1.7.1 215 7/22/2018
1.7.0.1340-feature-support-... 219 7/22/2018
1.7.0.1338-feature-support-... 192 7/22/2018
1.7.0 209 7/22/2018
1.6.0.1329-feature-naming-t... 218 7/21/2018
1.5.0.1304 235 7/20/2018
1.5.0.1303-feature-class-le... 202 7/20/2018
1.5.0.1300 292 6/4/2018
1.5.0.1296-fix-datacontext-... 344 5/6/2018
1.5.0.1295 304 4/26/2018
1.5.0.1294 261 4/26/2018
1.5.0.1285 329 2/6/2018
1.5.0.1285-asynchooks-test 300 2/6/2018
1.5.0.1280-asynchooks-test 280 2/5/2018
1.3.1.1240 327 1/23/2018
1.3.1.1208 343 1/17/2018
1.3.1.1207 299 1/8/2018
1.3.1.1206 313 1/8/2018
1.3.1.1204 300 1/3/2018
1.3.1.1198 312 12/21/2017
1.3.1.1195 262 12/1/2017
1.3.1.1194 262 12/1/2017
1.3.1.1193 262 12/1/2017
1.3.1.1171 313 10/17/2017
1.3.1.1163 354 7/5/2017
1.3.1.1160 299 6/21/2017
1.3.1.1159 300 6/21/2017
1.3.1.1155 322 6/20/2017
1.3.1.1153 315 6/19/2017
1.3.1.1151 284 6/16/2017
1.3.1.1148 307 6/15/2017
1.3.0.1144 299 6/12/2017
1.3.0.1141 334 6/9/2017
1.3.0.1137 321 5/12/2017
1.3.0.1135 288 5/11/2017
1.3.0.1134 293 5/11/2017
1.3.0.1131 296 5/6/2017
1.3.0.1130 304 5/6/2017
1.3.0.1129 299 5/5/2017
1.3.0.1128 304 5/5/2017
1.2.0.1118 282 5/4/2017
1.2.0.1116 302 5/4/2017
1.2.0.1114 293 5/4/2017
1.2.0.1112 295 5/4/2017
1.2.0.1111 297 5/3/2017
1.2.0.1107 300 5/2/2017
1.2.0.1104 302 4/29/2017
1.2.0.1103 283 4/28/2017
1.2.0.1101 286 4/28/2017
1.2.0.1095 297 4/27/2017
1.2.0.1092 314 4/18/2017
1.2.0.1088 306 4/17/2017
1.2.0.1087 301 4/17/2017
1.2.0.1086 299 4/17/2017
1.2.0.1085 301 4/17/2017
1.2.0.1084 301 4/17/2017
1.2.0.1072-rc1 275 4/14/2017
1.2.0.1071-rc1 274 4/14/2017
1.2.0.1064-rc1 274 4/1/2017
1.2.0.1061-rc1 283 3/31/2017
1.2.0.1059-rc1 264 3/29/2017
1.2.0.1057-rc1 268 3/28/2017
1.2.0.1055-rc1 259 3/28/2017
1.1.1.1044 300 3/24/2017
1.1.1.1040 305 3/19/2017
1.1.1.1004 319 3/10/2017
1.1.1.1002 305 3/9/2017
1.1.1.1000 358 2/1/2017
1.1.1.998 307 1/31/2017
1.1.1.996 398 12/15/2016
1.1.1.991 370 11/28/2016
1.1.1.989 883 9/22/2016
1.1.1.987 323 9/22/2016
1.1.1.986 305 9/22/2016
1.1.1.985 323 9/22/2016
1.1.1.982 386 8/24/2016
1.1.1.980 319 8/24/2016
1.1.1.979 335 8/22/2016
1.1.0.975 320 8/22/2016
1.1.0.973 329 8/22/2016
1.1.0.972 328 8/22/2016
1.1.0.971 333 8/18/2016
1.1.0.970 333 8/16/2016
1.1.0.967 325 8/15/2016
1.1.0.966 321 8/15/2016
1.1.0.964 330 8/11/2016
1.1.0.963 348 8/9/2016
1.1.0.961 324 8/9/2016
1.1.0.960 312 8/9/2016
1.1.0.959 312 8/8/2016
1.1.0.957 336 8/7/2016
1.1.0.956 329 8/7/2016
1.1.0.947-rc 279 8/6/2016
1.1.0.946-rc 318 8/5/2016
1.1.0.945 341 8/5/2016
1.1.0.942 379 7/27/2016
1.1.0.941 363 7/27/2016
1.1.0.939 340 7/27/2016
1.1.0.938 346 7/27/2016
1.1.0.936 366 7/26/2016
1.1.0.935 358 7/26/2016
1.1.0.932 355 7/25/2016
1.1.0.930 361 7/23/2016
1.1.0.929 359 7/23/2016
1.1.0.928 333 7/22/2016
1.1.0.927 359 7/22/2016
1.1.0.924 356 7/22/2016
1.1.0.923 338 7/21/2016
1.1.0.918 343 7/20/2016
1.1.0.915 314 7/20/2016
1.1.0.912 333 7/20/2016
1.1.0.910 317 7/20/2016
1.1.0.904 328 7/19/2016
1.1.0.903 323 7/18/2016
1.1.0.902 328 7/18/2016
1.1.0.901 339 7/18/2016
1.1.0.887 344 7/16/2016
1.1.0.886 347 7/16/2016
1.1.0.883 483 7/14/2016
1.1.0.879 468 7/13/2016
1.1.0.877 492 7/12/2016
1.1.0.864 335 7/9/2016
1.1.0.863 360 7/9/2016
1.1.0.859 351 7/8/2016
1.1.0.858 360 7/8/2016
1.1.0.857 358 7/6/2016
1.1.0.856 355 6/29/2016
1.1.0.855 324 6/28/2016
1.1.0.854 324 6/25/2016
1.0.1.851-rc 312 6/17/2016
1.0.1.849-rc 308 6/17/2016
1.0.1.842-rc 317 6/9/2016
1.0.1.841-rc 314 6/9/2016
1.0.1.839-rc 309 6/9/2016
1.0.1.837-rc 409 5/31/2016
1.0.1.835-rc 308 5/26/2016
1.0.1.834-rc 307 5/24/2016
1.0.1.833-rc 323 5/20/2016
1.0.1.832-rc 315 5/20/2016
1.0.1.828-rc 304 5/9/2016
1.0.1.827-rc 301 5/7/2016
1.0.1.826-rc 308 5/2/2016
1.0.1.824-rc 303 5/1/2016
1.0.1.823-rc 316 4/21/2016
1.0.1.822-rc 300 4/20/2016
1.0.1.821-rc 301 4/11/2016
1.0.1.819-rc 315 4/11/2016
1.0.1.818-rc 304 4/8/2016
1.0.1.817-rc 308 4/7/2016
1.0.1.813-rc 317 4/7/2016
1.0.1.812-rc 309 3/30/2016
1.0.1.811-rc 312 3/30/2016
1.0.1.810-rc 319 3/30/2016
1.0.1.808-rc 307 3/30/2016
1.0.1.807-rc 328 3/29/2016
1.0.1.806-rc 309 3/29/2016
1.0.1.805-rc 325 3/29/2016
1.0.1.796-rc 307 3/27/2016
1.0.1.793-rc 298 3/27/2016
1.0.1.788-rc 314 3/26/2016
1.0.1.785-rc 302 3/26/2016
1.0.1.778-rc 323 3/22/2016
1.0.1.777-rc 310 3/22/2016
1.0.1.776-rc 334 3/18/2016
1.0.1.775-rc 313 3/18/2016
1.0.1.774-rc 316 3/16/2016
1.0.1.773-rc 302 3/16/2016
1.0.1.771-rc 310 3/15/2016
1.0.1.769-rc 305 3/15/2016
1.0.1.765-rc 298 3/15/2016
1.0.1.764-rc 321 3/15/2016
1.0.1.759-rc 350 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 319 3/13/2016
1.0.1.748-rc 331 3/13/2016
1.0.1.747-rc 353 3/13/2016
1.0.1.746-rc 304 3/13/2016
1.0.1.743-rc 318 3/9/2016
1.0.1.742-rc 330 3/8/2016
1.0.1.741-rc 318 3/8/2016
1.0.1.740-rc 319 3/7/2016
1.0.1.736-rc 326 3/7/2016
1.0.1.735-rc 319 3/7/2016
1.0.1.729-rc 323 3/6/2016
1.0.1.728-rc 322 3/6/2016
1.0.1.726-rc 339 3/6/2016
1.0.1.724-rc 349 3/4/2016
1.0.1.723-rc 303 3/3/2016
1.0.1.722-rc 304 3/3/2016
1.0.1.721-rc 317 3/3/2016
1.0.1.719-rc 335 3/2/2016
1.0.1.717-rc 318 3/1/2016
1.0.1.716-rc 320 2/28/2016
1.0.1.711-rc 311 2/28/2016
1.0.1.709-rc 303 2/27/2016
1.0.1.708-rc 328 2/27/2016
1.0.1.707-rc 301 2/27/2016
1.0.1.706-rc 337 2/26/2016
1.0.1.705-rc 321 2/26/2016
1.0.1.701-rc 308 2/25/2016
1.0.1.699-rc 319 2/23/2016
1.0.1.696-rc 337 2/21/2016
1.0.1.693-rc 327 2/20/2016
1.0.1.691-rc 338 2/19/2016
1.0.1.689-rc 307 2/19/2016
1.0.1.684-rc 343 2/18/2016
1.0.1.683-rc 304 2/18/2016
1.0.1.676-rc 337 2/17/2016
1.0.1.673-rc 328 2/17/2016
1.0.1.670-rc 308 2/17/2016
1.0.1.665-rc 314 2/15/2016
1.0.1.663-rc 350 2/14/2016
1.0.1.659-rc 310 2/14/2016
1.0.1.657-rc 298 2/14/2016
1.0.1.654-rc 318 2/14/2016
1.0.1.648-rc 362 2/13/2016
1.0.1.647-rc 355 2/13/2016
1.0.1.632-rc 316 2/11/2016
1.0.1.631-rc 322 2/11/2016
1.0.1.626-rc 311 2/10/2016
1.0.1.625-rc 317 2/10/2016
1.0.1.609-rc 355 2/4/2016
1.0.1.605-rc 385 2/4/2016
1.0.1.604-rc 321 2/4/2016
1.0.1.600-rc 323 1/28/2016
1.0.1.597-rc 330 1/27/2016
1.0.1.596-rc 331 1/26/2016
1.0.1.595-rc 332 1/22/2016
1.0.1.593-rc 332 1/22/2016
1.0.1.590-rc 320 1/21/2016
1.0.1.588-rc 323 1/20/2016
1.0.1.583-rc 304 1/20/2016
1.0.1.582-rc 318 1/20/2016
1.0.1.574-rc 346 1/19/2016
1.0.1.571-rc 304 1/19/2016
1.0.1.570-rc 318 1/18/2016
1.0.1.569-rc 308 1/17/2016
1.0.1.568-rc 317 1/15/2016
1.0.1.565-rc 338 1/8/2016
1.0.1.564-rc 327 1/8/2016
1.0.1.561-rc 307 1/6/2016
1.0.1.557-rc 343 1/3/2016
1.0.1.554-rc 391 12/22/2015
1.0.1.553-rc 376 12/22/2015
1.0.1.552-rc 416 12/22/2015
1.0.1.551-rc 354 12/21/2015
1.0.1.550-rc 352 12/20/2015
1.0.1.545-rc 340 12/17/2015
1.0.1.543-rc 354 12/17/2015
1.0.1.542-rc 324 12/16/2015
1.0.1.539-rc 358 12/16/2015
1.0.1.525-rc 325 12/16/2015
1.0.1.521-rc 313 12/15/2015
1.0.1.512-rc 336 12/14/2015
1.0.1.508-rc 317 12/14/2015
1.0.1.505-rc 320 12/14/2015
1.0.0.492-rc 386 12/11/2015
1.0.0.491-rc 346 12/11/2015
1.0.0.488-rc 377 12/11/2015
1.0.0.487-rc 320 12/11/2015
1.0.0.485-rc 379 12/9/2015
1.0.0.481-rc 324 12/8/2015
1.0.0.479-rc 350 12/7/2015
1.0.0.473-rc 338 12/6/2015
1.0.0.472-rc 320 12/3/2015
1.0.0.469-rc 359 12/1/2015
1.0.0.465-rc 326 11/19/2015
1.0.0.464-rc 357 11/16/2015
1.0.0.458-rc 357 11/3/2015
1.0.0.448-rc 358 10/27/2015
1.0.0.447-rc 355 10/27/2015
1.0.0.446-rc 336 10/27/2015
1.0.0.443-rc 353 10/27/2015
1.0.0.441-rc 343 10/26/2015
1.0.0.436-rc 323 10/26/2015
1.0.0.434-rc 354 10/26/2015
1.0.0.433-rc 364 10/26/2015
0.9.1.426 670 10/8/2015
0.9.1.424 370 10/6/2015
0.9.1.418 400 9/29/2015
0.9.1.415 385 9/29/2015
0.9.1.411 380 9/28/2015
0.9.1.408 392 9/3/2015
0.9.1.407 376 8/18/2015
0.9.1.406 451 8/13/2015
0.9.1.405 347 8/13/2015
0.9.1.404 402 8/13/2015
0.9.1.401 439 7/21/2015
0.9.1.395 419 7/5/2015
0.9.1.394 367 7/4/2015
0.9.1.393 363 7/4/2015
0.9.1.390 402 6/13/2015
0.9.1.388 408 6/13/2015
0.9.1.386 358 6/13/2015
0.9.1.385 389 6/12/2015
0.9.1.382 377 6/12/2015
0.9.1.381 400 6/12/2015
0.9.1.380 363 6/12/2015
0.9.1.378 398 6/12/2015
0.9.1.375 442 2/27/2015
0.9.1.373 459 2/25/2015
0.9.1.370 376 2/25/2015
0.9.1.367 439 2/23/2015
0.9.1.365 375 2/21/2015
0.9.1.361 461 2/21/2015
0.9.1.358 470 2/16/2015
0.9.1.357 375 2/11/2015
0.9.0.355 507 2/10/2015
0.9.0.354 388 2/1/2015
0.9.0.353 432 1/30/2015
0.9.0.350 459 1/29/2015
0.9.0.338 388 1/12/2015
0.9.0.328 400 11/25/2014
0.9.0.326 390 11/24/2014
0.9.0.325 391 11/24/2014
0.9.0.323 445 11/23/2014
0.9.0.313 464 11/22/2014
0.9.0.299 536 11/12/2014
0.9.0.295 662 11/12/2014
0.9.0.290 533 11/11/2014
0.9.0.279 741 11/9/2014
0.9.0.269 666 11/6/2014
0.9.0.268 854 11/4/2014
0.9.0.266 1,147 11/3/2014
0.9.0.265 636 11/3/2014
0.9.0.263 882 11/3/2014
0.9.0.262 713 11/3/2014
0.9.0.249 401 10/27/2014
0.9.0.236 411 10/25/2014
0.9.0.234 408 10/24/2014
0.9.0.233 391 10/21/2014
0.9.0.227 384 10/21/2014
0.9.0.226 392 10/21/2014
0.9.0.225 422 10/21/2014
0.9.0.222 398 10/19/2014
0.9.0.221 392 10/19/2014
0.9.0.204 388 10/17/2014
0.9.0.200 389 10/15/2014
0.9.0.199 434 10/15/2014
0.9.0.193 388 10/14/2014
0.9.0.189 408 10/14/2014
0.9.0.184-test 387 10/14/2014
0.9.0.183-test 371 10/13/2014
0.9.0.179 422 10/13/2014
0.9.0.174 401 10/13/2014
0.6.0.173 383 10/13/2014
0.6.0.165 441 10/3/2014
0.6.0.160 426 9/18/2014
0.6.0.157 436 9/18/2014
0.6.0.155 404 9/18/2014
0.6.0.151 400 9/17/2014
0.6.0.147 435 9/16/2014
0.6.0.143 424 9/12/2014
0.6.0.141 408 9/10/2014
0.6.0.139 423 9/3/2014
0.6.0.135 392 8/21/2014
0.6.0.134 444 8/8/2014
0.6.0.130 448 8/4/2014
0.6.0.127 412 7/1/2014
0.6.0.101 496 1/21/2014
0.6.0.97 419 1/16/2014
0.5.0.51 496 1/5/2014
0.5.0.36 410 12/9/2013
0.5.0.35 453 12/8/2013
0.5.0.28 441 12/1/2013
Show less