Shaolinq.Postgres.DotConnect 0.9.0.184-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.184-test
                    
NuGet\Install-Package Shaolinq.Postgres.DotConnect -Version 0.9.0.184-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.184-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.184-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.184-test
                    
#r "nuget: Shaolinq.Postgres.DotConnect, 0.9.0.184-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.184-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.184-test&prerelease
                    
Install as a Cake Addin
#tool nuget:?package=Shaolinq.Postgres.DotConnect&version=0.9.0.184-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 487 10/1/2020
1.9.5.1476-refs-pull-109-head 409 10/1/2020
1.9.5.1475-refs-pull-100-merge 439 9/30/2020
1.9.5.1474-refs-pull-104-merge 458 9/30/2020
1.9.5.1471-refs-pull-108-merge 458 9/30/2020
1.9.5.1470-refs-pull-108-merge 466 9/30/2020
1.9.5.1469-refs-pull-108-head 482 9/30/2020
1.9.5.1468-refs-pull-107-merge 468 9/30/2020
1.9.5.1467-refs-pull-107-head 495 9/30/2020
1.9.5.1466-refs-pull-106-merge 486 9/30/2020
1.9.5.1465-refs-pull-106-head 472 9/30/2020
1.9.5.1464-refs-pull-105-merge 527 9/30/2020
1.9.5.1462-refs-pull-104-merge 534 9/30/2020
1.9.5.1460-refs-pull-100-merge 511 4/1/2020
1.9.5 1,170 1/17/2020
1.9.4.1454-refs-pull-97-merge 559 9/18/2019
1.9.4.1453-refs-pull-97-head 564 9/18/2019
1.9.4.1452-refs-pull-96-merge 544 9/18/2019
1.9.4.1451-refs-pull-96-head 523 9/18/2019
1.9.4.1450-refs-pull-95-merge 567 9/18/2019
1.9.4.1449-refs-pull-95-head 560 9/18/2019
1.9.4 1,102 11/9/2018
1.9.3.1445-fix-null-enum-bug 714 11/9/2018
1.9.3 1,035 11/9/2018
1.9.1.1438-feature-allow-re... 756 10/23/2018
1.9.1 1,083 10/23/2018
1.9.0.1437-feature-model-ge... 740 10/21/2018
1.9.0.1435-fix-query-cachin... 754 10/18/2018
1.9.0 1,065 10/18/2018
1.8.15 1,070 10/17/2018
1.8.14.1433-fix-nested-quer... 753 10/17/2018
1.8.14 1,019 10/16/2018
1.8.13.1429-fix-fix-nested-... 757 10/15/2018
1.8.13 1,007 10/15/2018
1.8.12 1,055 10/2/2018
1.8.11.1420-feature-allow-i... 772 10/2/2018
1.8.11.1419-feature-allow-i... 794 10/1/2018
1.8.11.1418-feature-allow-i... 764 10/1/2018
1.8.11 1,098 9/25/2018
1.8.10.1416-fix-distinct-co... 836 9/25/2018
1.8.10 1,138 8/16/2018
1.8.9 1,189 8/16/2018
1.8.8.1409-feature-sqlserve... 876 8/13/2018
1.8.8 1,193 8/10/2018
1.8.7.1404-fix-sql-index-an... 865 8/10/2018
1.8.7 1,140 8/10/2018
1.8.6 1,217 8/8/2018
1.8.4.1394-feature-exclude-... 960 8/7/2018
1.8.4 1,195 8/7/2018
1.8.3.1391-feature-unique-i... 921 8/7/2018
1.8.3 1,221 8/6/2018
1.8.2.1387-fix-support-over... 943 8/6/2018
1.8.2 1,193 8/2/2018
1.8.1.1384-fix-computed-mem... 921 8/1/2018
1.8.1.1383-fix-computed-mem... 932 8/1/2018
1.8.1 1,249 7/29/2018
1.8.0 1,273 7/28/2018
1.7.2 1,183 7/23/2018
1.7.1 1,208 7/22/2018
1.7.0.1340-feature-support-... 920 7/22/2018
1.7.0.1338-feature-support-... 917 7/22/2018
1.7.0 1,228 7/22/2018
1.6.0.1329-feature-naming-t... 935 7/21/2018
1.5.0.1304 1,178 7/20/2018
1.5.0.1303-feature-class-le... 909 7/20/2018
1.5.0.1300 1,434 6/4/2018
1.5.0.1296-fix-datacontext-... 1,211 5/6/2018
1.5.0.1295 1,441 4/26/2018
1.5.0.1294 1,393 4/26/2018
1.5.0.1285 1,426 2/6/2018
1.5.0.1285-asynchooks-test 1,148 2/6/2018
1.5.0.1280-asynchooks-test 1,116 2/5/2018
1.3.1.1240 1,492 1/23/2018
1.3.1.1208 1,463 1/17/2018
1.3.1.1207 1,443 1/8/2018
1.3.1.1206 1,431 1/8/2018
1.3.1.1204 1,449 1/3/2018
1.3.1.1198 1,467 12/21/2017
1.3.1.1195 1,264 12/1/2017
1.3.1.1194 1,252 12/1/2017
1.3.1.1193 1,239 12/1/2017
1.3.1.1171 1,271 10/17/2017
1.3.1.1163 1,332 7/5/2017
1.3.1.1160 1,362 6/21/2017
1.3.1.1159 1,285 6/21/2017
1.3.1.1155 1,297 6/20/2017
1.3.1.1153 1,275 6/19/2017
1.3.1.1151 1,337 6/16/2017
1.3.1.1148 1,339 6/15/2017
1.3.0.1144 1,316 6/12/2017
1.3.0.1141 1,348 6/9/2017
1.3.0.1137 1,319 5/12/2017
1.3.0.1135 1,315 5/11/2017
1.3.0.1134 1,298 5/11/2017
1.3.0.1131 1,316 5/6/2017
1.3.0.1130 1,346 5/6/2017
1.3.0.1129 1,319 5/5/2017
1.3.0.1128 1,320 5/5/2017
1.2.0.1118 1,347 5/4/2017
1.2.0.1116 1,351 5/4/2017
1.2.0.1114 1,310 5/4/2017
1.2.0.1112 1,310 5/4/2017
1.2.0.1111 1,347 5/3/2017
1.2.0.1107 1,286 5/2/2017
1.2.0.1104 1,337 4/29/2017
1.2.0.1103 1,376 4/28/2017
1.2.0.1101 1,285 4/28/2017
1.2.0.1095 1,312 4/27/2017
1.2.0.1092 1,336 4/18/2017
1.2.0.1088 1,354 4/17/2017
1.2.0.1087 1,377 4/17/2017
1.2.0.1086 1,338 4/17/2017
1.2.0.1085 1,312 4/17/2017
1.2.0.1084 1,329 4/17/2017
1.2.0.1064-rc1 1,036 4/1/2017
1.2.0.1061-rc1 1,029 3/31/2017
1.2.0.1059-rc1 1,044 3/29/2017
1.2.0.1057-rc1 1,041 3/28/2017
1.2.0.1055-rc1 1,039 3/28/2017
1.1.1.1044 1,381 3/24/2017
1.1.1.1040 1,276 3/19/2017
1.1.1.1004 1,283 3/10/2017
1.1.1.1002 1,369 3/9/2017
1.1.1.1000 1,372 2/1/2017
1.1.1.998 1,319 1/31/2017
1.1.1.996 1,405 12/15/2016
1.1.1.991 1,365 11/28/2016
1.1.1.989 1,577 9/22/2016
1.1.1.987 1,777 9/22/2016
1.1.1.986 1,746 9/22/2016
1.1.1.985 1,747 9/22/2016
1.1.1.982 1,439 8/24/2016
1.1.1.980 1,367 8/24/2016
1.1.1.979 1,379 8/22/2016
1.1.0.975 1,368 8/22/2016
1.1.0.973 1,379 8/22/2016
1.1.0.972 1,387 8/22/2016
1.1.0.971 1,405 8/18/2016
1.1.0.970 1,379 8/16/2016
1.1.0.967 1,393 8/15/2016
1.1.0.966 1,384 8/15/2016
1.1.0.964 1,352 8/11/2016
1.1.0.963 1,363 8/9/2016
1.1.0.961 1,362 8/9/2016
1.1.0.960 1,422 8/9/2016
1.1.0.959 1,400 8/8/2016
1.1.0.957 1,405 8/7/2016
1.1.0.956 1,366 8/7/2016
1.1.0.947-rc 1,061 8/6/2016
1.1.0.946-rc 1,066 8/5/2016
1.1.0.945 1,371 8/5/2016
1.1.0.942 1,603 7/27/2016
1.1.0.941 1,606 7/27/2016
1.1.0.939 1,580 7/27/2016
1.1.0.938 1,606 7/27/2016
1.1.0.936 1,710 7/26/2016
1.1.0.935 1,349 7/26/2016
1.1.0.932 1,357 7/25/2016
1.1.0.930 1,379 7/23/2016
1.1.0.929 1,356 7/23/2016
1.1.0.928 1,351 7/22/2016
1.1.0.927 1,431 7/22/2016
1.1.0.924 1,458 7/22/2016
1.1.0.923 1,391 7/21/2016
1.1.0.918 1,390 7/20/2016
1.1.0.915 1,343 7/20/2016
1.1.0.912 1,349 7/20/2016
1.1.0.910 1,358 7/20/2016
1.1.0.904 1,335 7/19/2016
1.1.0.903 1,358 7/18/2016
1.1.0.902 1,368 7/18/2016
1.1.0.901 1,379 7/18/2016
1.1.0.887 1,344 7/16/2016
1.1.0.886 1,409 7/16/2016
1.1.0.883 1,490 7/14/2016
1.1.0.879 1,536 7/13/2016
1.1.0.877 1,505 7/12/2016
1.1.0.864 1,392 7/9/2016
1.1.0.863 1,430 7/9/2016
1.1.0.859 1,389 7/8/2016
1.1.0.858 1,397 7/8/2016
1.1.0.857 1,370 7/6/2016
1.1.0.856 1,397 6/29/2016
1.1.0.855 1,421 6/28/2016
1.1.0.854 1,403 6/25/2016
1.0.1.851-rc 1,411 6/17/2016
1.0.1.849-rc 1,392 6/17/2016
1.0.1.842-rc 1,166 6/9/2016
1.0.1.841-rc 1,192 6/9/2016
1.0.1.839-rc 1,264 6/9/2016
1.0.1.837-rc 1,085 5/31/2016
1.0.1.835-rc 1,109 5/26/2016
1.0.1.834-rc 1,044 5/24/2016
1.0.1.833-rc 1,132 5/20/2016
1.0.1.832-rc 1,088 5/20/2016
1.0.1.828-rc 1,059 5/9/2016
1.0.1.827-rc 1,051 5/7/2016
1.0.1.826-rc 1,056 5/2/2016
1.0.1.824-rc 1,076 5/1/2016
1.0.1.823-rc 1,221 4/21/2016
1.0.1.822-rc 1,065 4/20/2016
1.0.1.821-rc 1,043 4/11/2016
1.0.1.819-rc 1,121 4/11/2016
1.0.1.818-rc 1,115 4/8/2016
1.0.1.817-rc 1,098 4/7/2016
1.0.1.813-rc 1,073 4/7/2016
1.0.1.812-rc 1,064 3/30/2016
1.0.1.811-rc 1,101 3/30/2016
1.0.1.810-rc 1,089 3/30/2016
1.0.1.808-rc 1,056 3/30/2016
1.0.1.807-rc 1,094 3/29/2016
1.0.1.806-rc 1,072 3/29/2016
1.0.1.805-rc 1,080 3/29/2016
1.0.1.796-rc 1,090 3/27/2016
1.0.1.793-rc 1,035 3/27/2016
1.0.1.788-rc 1,107 3/26/2016
1.0.1.785-rc 1,063 3/26/2016
1.0.1.778-rc 1,112 3/22/2016
1.0.1.777-rc 1,311 3/22/2016
1.0.1.776-rc 1,140 3/18/2016
1.0.1.775-rc 1,031 3/18/2016
1.0.1.774-rc 1,069 3/16/2016
1.0.1.773-rc 1,056 3/16/2016
1.0.1.771-rc 1,068 3/15/2016
1.0.1.769-rc 1,080 3/15/2016
1.0.1.765-rc 1,024 3/15/2016
1.0.1.764-rc 1,021 3/15/2016
1.0.1.759-rc 1,097 3/14/2016
1.0.1.758-rc 1,057 3/14/2016
1.0.1.757-rc 1,051 3/14/2016
1.0.1.752-rc 1,065 3/13/2016
1.0.1.748-rc 1,257 3/13/2016
1.0.1.747-rc 1,264 3/13/2016
1.0.1.746-rc 1,063 3/13/2016
1.0.1.743-rc 1,053 3/9/2016
1.0.1.742-rc 1,074 3/8/2016
1.0.1.741-rc 1,060 3/8/2016
1.0.1.740-rc 1,088 3/7/2016
1.0.1.736-rc 1,094 3/7/2016
1.0.1.735-rc 1,069 3/7/2016
1.0.1.729-rc 1,067 3/6/2016
1.0.1.728-rc 1,055 3/6/2016
1.0.1.726-rc 1,018 3/6/2016
1.0.1.724-rc 1,065 3/4/2016
1.0.1.723-rc 1,090 3/3/2016
1.0.1.722-rc 1,073 3/3/2016
1.0.1.721-rc 1,043 3/3/2016
1.0.1.719-rc 1,194 3/2/2016
1.0.1.717-rc 1,066 3/1/2016
1.0.1.716-rc 1,258 2/28/2016
1.0.1.711-rc 1,540 2/28/2016
1.0.1.709-rc 1,409 2/27/2016
1.0.1.708-rc 1,566 2/27/2016
1.0.1.707-rc 1,133 2/27/2016
1.0.1.706-rc 1,426 2/26/2016
1.0.1.705-rc 1,431 2/26/2016
1.0.1.701-rc 1,489 2/25/2016
1.0.1.699-rc 1,121 2/23/2016
1.0.1.696-rc 1,192 2/21/2016
1.0.1.693-rc 1,132 2/20/2016
1.0.1.691-rc 1,059 2/19/2016
1.0.1.689-rc 1,105 2/19/2016
1.0.1.684-rc 1,099 2/18/2016
1.0.1.683-rc 1,085 2/18/2016
1.0.1.676-rc 1,060 2/17/2016
1.0.1.673-rc 1,099 2/17/2016
1.0.1.670-rc 1,089 2/17/2016
1.0.1.665-rc 1,063 2/15/2016
1.0.1.663-rc 1,086 2/14/2016
1.0.1.659-rc 1,100 2/14/2016
1.0.1.657-rc 1,075 2/14/2016
1.0.1.654-rc 1,080 2/14/2016
1.0.1.648-rc 1,085 2/13/2016
1.0.1.647-rc 1,306 2/13/2016
1.0.1.632-rc 1,084 2/11/2016
1.0.1.631-rc 1,057 2/11/2016
1.0.1.626-rc 1,077 2/10/2016
1.0.1.625-rc 1,069 2/10/2016
1.0.1.609-rc 1,071 2/4/2016
1.0.1.605-rc 1,111 2/4/2016
1.0.1.604-rc 1,081 2/4/2016
1.0.1.600-rc 1,070 1/28/2016
1.0.1.597-rc 1,088 1/27/2016
1.0.1.596-rc 1,044 1/26/2016
1.0.1.595-rc 1,093 1/22/2016
1.0.1.593-rc 1,119 1/22/2016
1.0.1.590-rc 1,104 1/21/2016
1.0.1.588-rc 1,079 1/20/2016
1.0.1.583-rc 1,064 1/20/2016
1.0.1.582-rc 1,067 1/20/2016
1.0.1.574-rc 1,062 1/19/2016
1.0.1.571-rc 1,065 1/19/2016
1.0.1.570-rc 1,102 1/18/2016
1.0.1.569-rc 1,102 1/17/2016
1.0.1.568-rc 1,344 1/15/2016
1.0.1.565-rc 1,087 1/8/2016
1.0.1.564-rc 1,090 1/8/2016
1.0.1.561-rc 1,076 1/6/2016
1.0.1.557-rc 1,092 1/3/2016
1.0.1.554-rc 1,315 12/22/2015
1.0.1.553-rc 1,376 12/22/2015
1.0.1.552-rc 1,298 12/22/2015
1.0.1.551-rc 1,092 12/21/2015
1.0.1.550-rc 1,114 12/20/2015
1.0.1.545-rc 1,049 12/17/2015
1.0.1.543-rc 1,088 12/17/2015
1.0.1.542-rc 1,078 12/16/2015
1.0.1.539-rc 1,103 12/16/2015
1.0.1.525-rc 1,081 12/16/2015
1.0.1.521-rc 1,100 12/15/2015
1.0.1.512-rc 1,081 12/14/2015
1.0.1.508-rc 1,084 12/14/2015
1.0.1.505-rc 1,062 12/14/2015
1.0.0.492-rc 1,077 12/11/2015
1.0.0.491-rc 1,085 12/11/2015
1.0.0.488-rc 1,292 12/11/2015
1.0.0.487-rc 1,128 12/11/2015
1.0.0.485-rc 1,405 12/9/2015
1.0.0.481-rc 1,084 12/8/2015
1.0.0.479-rc 1,288 12/7/2015
1.0.0.473-rc 1,167 12/6/2015
1.0.0.472-rc 1,445 12/3/2015
1.0.0.469-rc 1,206 12/1/2015
1.0.0.465-rc 1,157 11/19/2015
1.0.0.464-rc 1,146 11/16/2015
1.0.0.458-rc 1,128 11/3/2015
1.0.0.448-rc 1,155 10/27/2015
1.0.0.447-rc 1,113 10/27/2015
1.0.0.446-rc 1,067 10/27/2015
1.0.0.443-rc 1,103 10/27/2015
1.0.0.441-rc 1,116 10/26/2015
1.0.0.436-rc 1,123 10/26/2015
1.0.0.434-rc 1,080 10/26/2015
0.9.1.426 1,587 10/8/2015
0.9.1.424 1,468 10/6/2015
0.9.1.418 1,549 9/29/2015
0.9.1.415 1,482 9/29/2015
0.9.1.411 1,513 9/28/2015
0.9.1.408 1,463 9/3/2015
0.9.1.407 1,436 8/18/2015
0.9.1.406 2,132 8/13/2015
0.9.1.405 1,623 8/13/2015
0.9.1.404 1,652 8/13/2015
0.9.1.401 1,753 7/21/2015
0.9.1.395 1,511 7/5/2015
0.9.1.394 1,433 7/4/2015
0.9.1.393 1,407 7/4/2015
0.9.1.390 1,427 6/13/2015
0.9.1.388 1,443 6/13/2015
0.9.1.386 1,423 6/13/2015
0.9.1.385 1,455 6/12/2015
0.9.1.382 1,445 6/12/2015
0.9.1.381 1,510 6/12/2015
0.9.1.380 1,381 6/12/2015
0.9.1.378 1,423 6/12/2015
0.9.1.375 2,027 2/27/2015
0.9.1.373 1,666 2/25/2015
0.9.1.370 1,782 2/25/2015
0.9.1.367 1,811 2/23/2015
0.9.1.365 1,856 2/21/2015
0.9.1.361 1,833 2/21/2015
0.9.1.358 1,659 2/16/2015
0.9.1.357 1,566 2/11/2015
0.9.0.355 1,524 2/10/2015
0.9.0.354 1,463 2/1/2015
0.9.0.353 1,538 1/30/2015
0.9.0.350 1,506 1/29/2015
0.9.0.338 1,475 1/12/2015
0.9.0.328 1,652 11/25/2014
0.9.0.326 1,610 11/24/2014
0.9.0.325 1,583 11/24/2014
0.9.0.323 1,574 11/23/2014
0.9.0.313 1,593 11/22/2014
0.9.0.299 1,688 11/12/2014
0.9.0.295 1,859 11/12/2014
0.9.0.290 1,619 11/11/2014
0.9.0.279 1,806 11/9/2014
0.9.0.269 1,736 11/6/2014
0.9.0.268 2,013 11/4/2014
0.9.0.266 2,230 11/3/2014
0.9.0.265 1,780 11/3/2014
0.9.0.263 1,988 11/3/2014
0.9.0.262 1,706 11/3/2014
0.9.0.249 1,455 10/27/2014
0.9.0.236 1,496 10/25/2014
0.9.0.234 1,506 10/24/2014
0.9.0.233 1,483 10/21/2014
0.9.0.227 1,456 10/21/2014
0.9.0.226 1,444 10/21/2014
0.9.0.225 1,472 10/21/2014
0.9.0.222 1,449 10/19/2014
0.9.0.221 1,474 10/19/2014
0.9.0.204 1,452 10/17/2014
0.9.0.200 1,498 10/15/2014
0.9.0.199 1,479 10/15/2014
0.9.0.193 1,482 10/14/2014
0.9.0.189 1,455 10/14/2014
0.9.0.184-test 1,165 10/14/2014
0.9.0.183-test 1,158 10/13/2014
0.9.0.179 1,484 10/13/2014
0.9.0.174 1,484 10/13/2014
0.6.0.173 1,451 10/13/2014
0.6.0.165 1,487 10/3/2014
0.6.0.160 1,491 9/18/2014
0.6.0.157 1,463 9/18/2014
0.6.0.155 1,476 9/18/2014
0.6.0.151 1,491 9/17/2014
0.6.0.147 1,446 9/16/2014
0.6.0.143 1,423 9/12/2014
0.6.0.141 1,490 9/10/2014
0.6.0.139 1,513 9/3/2014
0.6.0.135 1,505 8/21/2014
0.6.0.134 1,517 8/8/2014
0.6.0.130 1,542 8/4/2014
0.6.0.127 1,554 7/1/2014
0.6.0.101 1,692 1/21/2014
0.6.0.97 1,555 1/16/2014
0.5.0.51 1,496 1/5/2014
0.5.0.36 1,581 12/9/2013
0.5.0.35 1,492 12/8/2013
0.5.0.28 1,550 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