Shaolinq.Postgres.DotConnect 0.9.0.183-test

This is a prerelease version of Shaolinq.Postgres.DotConnect.
There is a newer version of this package available.
See the version list below for details.
dotnet add package Shaolinq.Postgres.DotConnect --version 0.9.0.183-test
                    
NuGet\Install-Package Shaolinq.Postgres.DotConnect -Version 0.9.0.183-test
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Shaolinq.Postgres.DotConnect" Version="0.9.0.183-test" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Shaolinq.Postgres.DotConnect" Version="0.9.0.183-test" />
                    
Directory.Packages.props
<PackageReference Include="Shaolinq.Postgres.DotConnect" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Shaolinq.Postgres.DotConnect --version 0.9.0.183-test
                    
#r "nuget: Shaolinq.Postgres.DotConnect, 0.9.0.183-test"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package Shaolinq.Postgres.DotConnect@0.9.0.183-test
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Shaolinq.Postgres.DotConnect&version=0.9.0.183-test&prerelease
                    
Install as a Cake Addin
#tool nuget:?package=Shaolinq.Postgres.DotConnect&version=0.9.0.183-test&prerelease
                    
Install as a Cake Tool

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!

Product Compatible and additional computed target framework versions.
.NET Framework net40 is compatible.  net403 was computed.  net45 was computed.  net451 was computed.  net452 was computed.  net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.9.5.1477-refs-pull-109-merge 485 10/1/2020
1.9.5.1476-refs-pull-109-head 407 10/1/2020
1.9.5.1475-refs-pull-100-merge 437 9/30/2020
1.9.5.1474-refs-pull-104-merge 456 9/30/2020
1.9.5.1471-refs-pull-108-merge 456 9/30/2020
1.9.5.1470-refs-pull-108-merge 464 9/30/2020
1.9.5.1469-refs-pull-108-head 480 9/30/2020
1.9.5.1468-refs-pull-107-merge 466 9/30/2020
1.9.5.1467-refs-pull-107-head 493 9/30/2020
1.9.5.1466-refs-pull-106-merge 484 9/30/2020
1.9.5.1465-refs-pull-106-head 470 9/30/2020
1.9.5.1464-refs-pull-105-merge 525 9/30/2020
1.9.5.1462-refs-pull-104-merge 531 9/30/2020
1.9.5.1460-refs-pull-100-merge 509 4/1/2020
1.9.5 1,167 1/17/2020
1.9.4.1454-refs-pull-97-merge 557 9/18/2019
1.9.4.1453-refs-pull-97-head 562 9/18/2019
1.9.4.1452-refs-pull-96-merge 542 9/18/2019
1.9.4.1451-refs-pull-96-head 521 9/18/2019
1.9.4.1450-refs-pull-95-merge 565 9/18/2019
1.9.4.1449-refs-pull-95-head 558 9/18/2019
1.9.4 1,100 11/9/2018
1.9.3.1445-fix-null-enum-bug 712 11/9/2018
1.9.3 1,033 11/9/2018
1.9.1.1438-feature-allow-re... 755 10/23/2018
1.9.1 1,082 10/23/2018
1.9.0.1437-feature-model-ge... 739 10/21/2018
1.9.0.1435-fix-query-cachin... 753 10/18/2018
1.9.0 1,064 10/18/2018
1.8.15 1,068 10/17/2018
1.8.14.1433-fix-nested-quer... 752 10/17/2018
1.8.14 1,018 10/16/2018
1.8.13.1429-fix-fix-nested-... 756 10/15/2018
1.8.13 1,006 10/15/2018
1.8.12 1,054 10/2/2018
1.8.11.1420-feature-allow-i... 771 10/2/2018
1.8.11.1419-feature-allow-i... 793 10/1/2018
1.8.11.1418-feature-allow-i... 763 10/1/2018
1.8.11 1,097 9/25/2018
1.8.10.1416-fix-distinct-co... 835 9/25/2018
1.8.10 1,137 8/16/2018
1.8.9 1,188 8/16/2018
1.8.8.1409-feature-sqlserve... 875 8/13/2018
1.8.8 1,192 8/10/2018
1.8.7.1404-fix-sql-index-an... 864 8/10/2018
1.8.7 1,139 8/10/2018
1.8.6 1,215 8/8/2018
1.8.4.1394-feature-exclude-... 957 8/7/2018
1.8.4 1,192 8/7/2018
1.8.3.1391-feature-unique-i... 918 8/7/2018
1.8.3 1,218 8/6/2018
1.8.2.1387-fix-support-over... 940 8/6/2018
1.8.2 1,190 8/2/2018
1.8.1.1384-fix-computed-mem... 918 8/1/2018
1.8.1.1383-fix-computed-mem... 929 8/1/2018
1.8.1 1,246 7/29/2018
1.8.0 1,270 7/28/2018
1.7.2 1,180 7/23/2018
1.7.1 1,205 7/22/2018
1.7.0.1340-feature-support-... 917 7/22/2018
1.7.0.1338-feature-support-... 914 7/22/2018
1.7.0 1,225 7/22/2018
1.6.0.1329-feature-naming-t... 932 7/21/2018
1.5.0.1304 1,175 7/20/2018
1.5.0.1303-feature-class-le... 906 7/20/2018
1.5.0.1300 1,432 6/4/2018
1.5.0.1296-fix-datacontext-... 1,206 5/6/2018
1.5.0.1295 1,437 4/26/2018
1.5.0.1294 1,389 4/26/2018
1.5.0.1285 1,422 2/6/2018
1.5.0.1285-asynchooks-test 1,144 2/6/2018
1.5.0.1280-asynchooks-test 1,112 2/5/2018
1.3.1.1240 1,488 1/23/2018
1.3.1.1208 1,459 1/17/2018
1.3.1.1207 1,439 1/8/2018
1.3.1.1206 1,427 1/8/2018
1.3.1.1204 1,445 1/3/2018
1.3.1.1198 1,463 12/21/2017
1.3.1.1195 1,261 12/1/2017
1.3.1.1194 1,249 12/1/2017
1.3.1.1193 1,236 12/1/2017
1.3.1.1171 1,269 10/17/2017
1.3.1.1163 1,330 7/5/2017
1.3.1.1160 1,360 6/21/2017
1.3.1.1159 1,283 6/21/2017
1.3.1.1155 1,295 6/20/2017
1.3.1.1153 1,273 6/19/2017
1.3.1.1151 1,335 6/16/2017
1.3.1.1148 1,337 6/15/2017
1.3.0.1144 1,314 6/12/2017
1.3.0.1141 1,346 6/9/2017
1.3.0.1137 1,317 5/12/2017
1.3.0.1135 1,313 5/11/2017
1.3.0.1134 1,296 5/11/2017
1.3.0.1131 1,314 5/6/2017
1.3.0.1130 1,342 5/6/2017
1.3.0.1129 1,317 5/5/2017
1.3.0.1128 1,318 5/5/2017
1.2.0.1118 1,345 5/4/2017
1.2.0.1116 1,349 5/4/2017
1.2.0.1114 1,308 5/4/2017
1.2.0.1112 1,308 5/4/2017
1.2.0.1111 1,345 5/3/2017
1.2.0.1107 1,284 5/2/2017
1.2.0.1104 1,335 4/29/2017
1.2.0.1103 1,374 4/28/2017
1.2.0.1101 1,283 4/28/2017
1.2.0.1095 1,310 4/27/2017
1.2.0.1092 1,334 4/18/2017
1.2.0.1088 1,351 4/17/2017
1.2.0.1087 1,374 4/17/2017
1.2.0.1086 1,335 4/17/2017
1.2.0.1085 1,309 4/17/2017
1.2.0.1084 1,326 4/17/2017
1.2.0.1064-rc1 1,033 4/1/2017
1.2.0.1061-rc1 1,026 3/31/2017
1.2.0.1059-rc1 1,041 3/29/2017
1.2.0.1057-rc1 1,038 3/28/2017
1.2.0.1055-rc1 1,035 3/28/2017
1.1.1.1044 1,378 3/24/2017
1.1.1.1040 1,273 3/19/2017
1.1.1.1004 1,280 3/10/2017
1.1.1.1002 1,365 3/9/2017
1.1.1.1000 1,369 2/1/2017
1.1.1.998 1,316 1/31/2017
1.1.1.996 1,402 12/15/2016
1.1.1.991 1,362 11/28/2016
1.1.1.989 1,574 9/22/2016
1.1.1.987 1,774 9/22/2016
1.1.1.986 1,743 9/22/2016
1.1.1.985 1,744 9/22/2016
1.1.1.982 1,435 8/24/2016
1.1.1.980 1,364 8/24/2016
1.1.1.979 1,376 8/22/2016
1.1.0.975 1,365 8/22/2016
1.1.0.973 1,376 8/22/2016
1.1.0.972 1,384 8/22/2016
1.1.0.971 1,401 8/18/2016
1.1.0.970 1,376 8/16/2016
1.1.0.967 1,390 8/15/2016
1.1.0.966 1,381 8/15/2016
1.1.0.964 1,349 8/11/2016
1.1.0.963 1,360 8/9/2016
1.1.0.961 1,359 8/9/2016
1.1.0.960 1,419 8/9/2016
1.1.0.959 1,397 8/8/2016
1.1.0.957 1,402 8/7/2016
1.1.0.956 1,363 8/7/2016
1.1.0.947-rc 1,058 8/6/2016
1.1.0.946-rc 1,063 8/5/2016
1.1.0.945 1,368 8/5/2016
1.1.0.942 1,600 7/27/2016
1.1.0.941 1,603 7/27/2016
1.1.0.939 1,577 7/27/2016
1.1.0.938 1,603 7/27/2016
1.1.0.936 1,707 7/26/2016
1.1.0.935 1,346 7/26/2016
1.1.0.932 1,354 7/25/2016
1.1.0.930 1,376 7/23/2016
1.1.0.929 1,353 7/23/2016
1.1.0.928 1,348 7/22/2016
1.1.0.927 1,428 7/22/2016
1.1.0.924 1,456 7/22/2016
1.1.0.923 1,388 7/21/2016
1.1.0.918 1,387 7/20/2016
1.1.0.915 1,338 7/20/2016
1.1.0.912 1,347 7/20/2016
1.1.0.910 1,356 7/20/2016
1.1.0.904 1,332 7/19/2016
1.1.0.903 1,356 7/18/2016
1.1.0.902 1,366 7/18/2016
1.1.0.901 1,377 7/18/2016
1.1.0.887 1,342 7/16/2016
1.1.0.886 1,407 7/16/2016
1.1.0.883 1,487 7/14/2016
1.1.0.879 1,534 7/13/2016
1.1.0.877 1,503 7/12/2016
1.1.0.864 1,390 7/9/2016
1.1.0.863 1,427 7/9/2016
1.1.0.859 1,386 7/8/2016
1.1.0.858 1,394 7/8/2016
1.1.0.857 1,367 7/6/2016
1.1.0.856 1,394 6/29/2016
1.1.0.855 1,418 6/28/2016
1.1.0.854 1,400 6/25/2016
1.0.1.851-rc 1,408 6/17/2016
1.0.1.849-rc 1,389 6/17/2016
1.0.1.842-rc 1,164 6/9/2016
1.0.1.841-rc 1,190 6/9/2016
1.0.1.839-rc 1,261 6/9/2016
1.0.1.837-rc 1,082 5/31/2016
1.0.1.835-rc 1,106 5/26/2016
1.0.1.834-rc 1,042 5/24/2016
1.0.1.833-rc 1,129 5/20/2016
1.0.1.832-rc 1,086 5/20/2016
1.0.1.828-rc 1,056 5/9/2016
1.0.1.827-rc 1,048 5/7/2016
1.0.1.826-rc 1,054 5/2/2016
1.0.1.824-rc 1,073 5/1/2016
1.0.1.823-rc 1,218 4/21/2016
1.0.1.822-rc 1,063 4/20/2016
1.0.1.821-rc 1,040 4/11/2016
1.0.1.819-rc 1,118 4/11/2016
1.0.1.818-rc 1,113 4/8/2016
1.0.1.817-rc 1,095 4/7/2016
1.0.1.813-rc 1,070 4/7/2016
1.0.1.812-rc 1,061 3/30/2016
1.0.1.811-rc 1,098 3/30/2016
1.0.1.810-rc 1,086 3/30/2016
1.0.1.808-rc 1,053 3/30/2016
1.0.1.807-rc 1,091 3/29/2016
1.0.1.806-rc 1,069 3/29/2016
1.0.1.805-rc 1,077 3/29/2016
1.0.1.796-rc 1,087 3/27/2016
1.0.1.793-rc 1,032 3/27/2016
1.0.1.788-rc 1,104 3/26/2016
1.0.1.785-rc 1,059 3/26/2016
1.0.1.778-rc 1,109 3/22/2016
1.0.1.777-rc 1,308 3/22/2016
1.0.1.776-rc 1,137 3/18/2016
1.0.1.775-rc 1,028 3/18/2016
1.0.1.774-rc 1,066 3/16/2016
1.0.1.773-rc 1,053 3/16/2016
1.0.1.771-rc 1,065 3/15/2016
1.0.1.769-rc 1,077 3/15/2016
1.0.1.765-rc 1,021 3/15/2016
1.0.1.764-rc 1,018 3/15/2016
1.0.1.759-rc 1,094 3/14/2016
1.0.1.758-rc 1,054 3/14/2016
1.0.1.757-rc 1,048 3/14/2016
1.0.1.752-rc 1,062 3/13/2016
1.0.1.748-rc 1,253 3/13/2016
1.0.1.747-rc 1,260 3/13/2016
1.0.1.746-rc 1,060 3/13/2016
1.0.1.743-rc 1,050 3/9/2016
1.0.1.742-rc 1,071 3/8/2016
1.0.1.741-rc 1,057 3/8/2016
1.0.1.740-rc 1,085 3/7/2016
1.0.1.736-rc 1,091 3/7/2016
1.0.1.735-rc 1,066 3/7/2016
1.0.1.729-rc 1,064 3/6/2016
1.0.1.728-rc 1,052 3/6/2016
1.0.1.726-rc 1,015 3/6/2016
1.0.1.724-rc 1,062 3/4/2016
1.0.1.723-rc 1,087 3/3/2016
1.0.1.722-rc 1,070 3/3/2016
1.0.1.721-rc 1,040 3/3/2016
1.0.1.719-rc 1,191 3/2/2016
1.0.1.717-rc 1,063 3/1/2016
1.0.1.716-rc 1,255 2/28/2016
1.0.1.711-rc 1,537 2/28/2016
1.0.1.709-rc 1,406 2/27/2016
1.0.1.708-rc 1,563 2/27/2016
1.0.1.707-rc 1,130 2/27/2016
1.0.1.706-rc 1,423 2/26/2016
1.0.1.705-rc 1,429 2/26/2016
1.0.1.701-rc 1,486 2/25/2016
1.0.1.699-rc 1,118 2/23/2016
1.0.1.696-rc 1,190 2/21/2016
1.0.1.693-rc 1,129 2/20/2016
1.0.1.691-rc 1,057 2/19/2016
1.0.1.689-rc 1,102 2/19/2016
1.0.1.684-rc 1,097 2/18/2016
1.0.1.683-rc 1,083 2/18/2016
1.0.1.676-rc 1,057 2/17/2016
1.0.1.673-rc 1,096 2/17/2016
1.0.1.670-rc 1,086 2/17/2016
1.0.1.665-rc 1,059 2/15/2016
1.0.1.663-rc 1,084 2/14/2016
1.0.1.659-rc 1,097 2/14/2016
1.0.1.657-rc 1,072 2/14/2016
1.0.1.654-rc 1,077 2/14/2016
1.0.1.648-rc 1,082 2/13/2016
1.0.1.647-rc 1,303 2/13/2016
1.0.1.632-rc 1,081 2/11/2016
1.0.1.631-rc 1,054 2/11/2016
1.0.1.626-rc 1,074 2/10/2016
1.0.1.625-rc 1,066 2/10/2016
1.0.1.609-rc 1,068 2/4/2016
1.0.1.605-rc 1,109 2/4/2016
1.0.1.604-rc 1,078 2/4/2016
1.0.1.600-rc 1,067 1/28/2016
1.0.1.597-rc 1,085 1/27/2016
1.0.1.596-rc 1,041 1/26/2016
1.0.1.595-rc 1,091 1/22/2016
1.0.1.593-rc 1,117 1/22/2016
1.0.1.590-rc 1,101 1/21/2016
1.0.1.588-rc 1,076 1/20/2016
1.0.1.583-rc 1,061 1/20/2016
1.0.1.582-rc 1,064 1/20/2016
1.0.1.574-rc 1,059 1/19/2016
1.0.1.571-rc 1,062 1/19/2016
1.0.1.570-rc 1,099 1/18/2016
1.0.1.569-rc 1,099 1/17/2016
1.0.1.568-rc 1,341 1/15/2016
1.0.1.565-rc 1,085 1/8/2016
1.0.1.564-rc 1,087 1/8/2016
1.0.1.561-rc 1,074 1/6/2016
1.0.1.557-rc 1,089 1/3/2016
1.0.1.554-rc 1,311 12/22/2015
1.0.1.553-rc 1,372 12/22/2015
1.0.1.552-rc 1,294 12/22/2015
1.0.1.551-rc 1,089 12/21/2015
1.0.1.550-rc 1,111 12/20/2015
1.0.1.545-rc 1,046 12/17/2015
1.0.1.543-rc 1,085 12/17/2015
1.0.1.542-rc 1,075 12/16/2015
1.0.1.539-rc 1,099 12/16/2015
1.0.1.525-rc 1,078 12/16/2015
1.0.1.521-rc 1,097 12/15/2015
1.0.1.512-rc 1,078 12/14/2015
1.0.1.508-rc 1,080 12/14/2015
1.0.1.505-rc 1,059 12/14/2015
1.0.0.492-rc 1,074 12/11/2015
1.0.0.491-rc 1,082 12/11/2015
1.0.0.488-rc 1,288 12/11/2015
1.0.0.487-rc 1,125 12/11/2015
1.0.0.485-rc 1,401 12/9/2015
1.0.0.481-rc 1,081 12/8/2015
1.0.0.479-rc 1,285 12/7/2015
1.0.0.473-rc 1,164 12/6/2015
1.0.0.472-rc 1,442 12/3/2015
1.0.0.469-rc 1,203 12/1/2015
1.0.0.465-rc 1,154 11/19/2015
1.0.0.464-rc 1,143 11/16/2015
1.0.0.458-rc 1,125 11/3/2015
1.0.0.448-rc 1,152 10/27/2015
1.0.0.447-rc 1,110 10/27/2015
1.0.0.446-rc 1,064 10/27/2015
1.0.0.443-rc 1,100 10/27/2015
1.0.0.441-rc 1,113 10/26/2015
1.0.0.436-rc 1,120 10/26/2015
1.0.0.434-rc 1,077 10/26/2015
0.9.1.426 1,584 10/8/2015
0.9.1.424 1,465 10/6/2015
0.9.1.418 1,546 9/29/2015
0.9.1.415 1,479 9/29/2015
0.9.1.411 1,510 9/28/2015
0.9.1.408 1,460 9/3/2015
0.9.1.407 1,433 8/18/2015
0.9.1.406 2,128 8/13/2015
0.9.1.405 1,620 8/13/2015
0.9.1.404 1,648 8/13/2015
0.9.1.401 1,749 7/21/2015
0.9.1.395 1,508 7/5/2015
0.9.1.394 1,430 7/4/2015
0.9.1.393 1,404 7/4/2015
0.9.1.390 1,424 6/13/2015
0.9.1.388 1,440 6/13/2015
0.9.1.386 1,420 6/13/2015
0.9.1.385 1,452 6/12/2015
0.9.1.382 1,442 6/12/2015
0.9.1.381 1,507 6/12/2015
0.9.1.380 1,378 6/12/2015
0.9.1.378 1,420 6/12/2015
0.9.1.375 2,024 2/27/2015
0.9.1.373 1,663 2/25/2015
0.9.1.370 1,778 2/25/2015
0.9.1.367 1,808 2/23/2015
0.9.1.365 1,853 2/21/2015
0.9.1.361 1,830 2/21/2015
0.9.1.358 1,656 2/16/2015
0.9.1.357 1,563 2/11/2015
0.9.0.355 1,521 2/10/2015
0.9.0.354 1,460 2/1/2015
0.9.0.353 1,535 1/30/2015
0.9.0.350 1,502 1/29/2015
0.9.0.338 1,472 1/12/2015
0.9.0.328 1,649 11/25/2014
0.9.0.326 1,607 11/24/2014
0.9.0.325 1,580 11/24/2014
0.9.0.323 1,571 11/23/2014
0.9.0.313 1,590 11/22/2014
0.9.0.299 1,685 11/12/2014
0.9.0.295 1,856 11/12/2014
0.9.0.290 1,616 11/11/2014
0.9.0.279 1,802 11/9/2014
0.9.0.269 1,733 11/6/2014
0.9.0.268 2,010 11/4/2014
0.9.0.266 2,227 11/3/2014
0.9.0.265 1,777 11/3/2014
0.9.0.263 1,985 11/3/2014
0.9.0.262 1,703 11/3/2014
0.9.0.249 1,452 10/27/2014
0.9.0.236 1,493 10/25/2014
0.9.0.234 1,503 10/24/2014
0.9.0.233 1,480 10/21/2014
0.9.0.227 1,453 10/21/2014
0.9.0.226 1,441 10/21/2014
0.9.0.225 1,469 10/21/2014
0.9.0.222 1,446 10/19/2014
0.9.0.221 1,471 10/19/2014
0.9.0.204 1,449 10/17/2014
0.9.0.200 1,495 10/15/2014
0.9.0.199 1,476 10/15/2014
0.9.0.193 1,479 10/14/2014
0.9.0.189 1,452 10/14/2014
0.9.0.184-test 1,162 10/14/2014
0.9.0.183-test 1,155 10/13/2014
0.9.0.179 1,481 10/13/2014
0.9.0.174 1,481 10/13/2014
0.6.0.173 1,447 10/13/2014
0.6.0.165 1,484 10/3/2014
0.6.0.160 1,488 9/18/2014
0.6.0.157 1,460 9/18/2014
0.6.0.155 1,473 9/18/2014
0.6.0.151 1,488 9/17/2014
0.6.0.147 1,443 9/16/2014
0.6.0.143 1,420 9/12/2014
0.6.0.141 1,487 9/10/2014
0.6.0.139 1,510 9/3/2014
0.6.0.135 1,502 8/21/2014
0.6.0.134 1,514 8/8/2014
0.6.0.130 1,539 8/4/2014
0.6.0.127 1,551 7/1/2014
0.6.0.101 1,689 1/21/2014
0.6.0.97 1,552 1/16/2014
0.5.0.51 1,493 1/5/2014
0.5.0.36 1,578 12/9/2013
0.5.0.35 1,489 12/8/2013
0.5.0.28 1,547 12/1/2013

- Support for Include() when selecting related objects on objects.
- 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
- Bug fixes