Shaolinq.Postgres.DotConnect 0.9.0.353

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.353                
NuGet\Install-Package Shaolinq.Postgres.DotConnect -Version 0.9.0.353                
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.353" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Shaolinq.Postgres.DotConnect --version 0.9.0.353                
#r "nuget: Shaolinq.Postgres.DotConnect, 0.9.0.353"                
#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.
// Install Shaolinq.Postgres.DotConnect as a Cake Addin
#addin nuget:?package=Shaolinq.Postgres.DotConnect&version=0.9.0.353

// Install Shaolinq.Postgres.DotConnect as a Cake Tool
#tool nuget:?package=Shaolinq.Postgres.DotConnect&version=0.9.0.353                

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 377 10/1/2020
1.9.5.1476-refs-pull-109-head 310 10/1/2020
1.9.5.1475-refs-pull-100-merge 344 9/30/2020
1.9.5.1474-refs-pull-104-merge 358 9/30/2020
1.9.5.1471-refs-pull-108-merge 356 9/30/2020
1.9.5.1470-refs-pull-108-merge 371 9/30/2020
1.9.5.1469-refs-pull-108-head 382 9/30/2020
1.9.5.1468-refs-pull-107-merge 375 9/30/2020
1.9.5.1467-refs-pull-107-head 397 9/30/2020
1.9.5.1466-refs-pull-106-merge 392 9/30/2020
1.9.5.1465-refs-pull-106-head 375 9/30/2020
1.9.5.1464-refs-pull-105-merge 436 9/30/2020
1.9.5.1462-refs-pull-104-merge 440 9/30/2020
1.9.5.1460-refs-pull-100-merge 411 4/1/2020
1.9.5 1,015 1/17/2020
1.9.4.1454-refs-pull-97-merge 454 9/18/2019
1.9.4.1453-refs-pull-97-head 455 9/18/2019
1.9.4.1452-refs-pull-96-merge 433 9/18/2019
1.9.4.1451-refs-pull-96-head 415 9/18/2019
1.9.4.1450-refs-pull-95-merge 463 9/18/2019
1.9.4.1449-refs-pull-95-head 446 9/18/2019
1.9.4 960 11/9/2018
1.9.3.1445-fix-null-enum-bug 589 11/9/2018
1.9.3 896 11/9/2018
1.9.1.1438-feature-allow-re... 630 10/23/2018
1.9.1 949 10/23/2018
1.9.0.1437-feature-model-ge... 618 10/21/2018
1.9.0.1435-fix-query-cachin... 631 10/18/2018
1.9.0 932 10/18/2018
1.8.15 930 10/17/2018
1.8.14.1433-fix-nested-quer... 628 10/17/2018
1.8.14 884 10/16/2018
1.8.13.1429-fix-fix-nested-... 628 10/15/2018
1.8.13 879 10/15/2018
1.8.12 914 10/2/2018
1.8.11.1420-feature-allow-i... 642 10/2/2018
1.8.11.1419-feature-allow-i... 659 10/1/2018
1.8.11.1418-feature-allow-i... 637 10/1/2018
1.8.11 944 9/25/2018
1.8.10.1416-fix-distinct-co... 699 9/25/2018
1.8.10 996 8/16/2018
1.8.9 1,048 8/16/2018
1.8.8.1409-feature-sqlserve... 742 8/13/2018
1.8.8 1,056 8/10/2018
1.8.7.1404-fix-sql-index-an... 726 8/10/2018
1.8.7 987 8/10/2018
1.8.6 1,064 8/8/2018
1.8.4.1394-feature-exclude-... 764 8/7/2018
1.8.4 986 8/7/2018
1.8.3.1391-feature-unique-i... 718 8/7/2018
1.8.3 1,008 8/6/2018
1.8.2.1387-fix-support-over... 740 8/6/2018
1.8.2 987 8/2/2018
1.8.1.1384-fix-computed-mem... 718 8/1/2018
1.8.1.1383-fix-computed-mem... 737 8/1/2018
1.8.1 1,034 7/29/2018
1.8.0 1,060 7/28/2018
1.7.2 967 7/23/2018
1.7.1 1,001 7/22/2018
1.7.0.1340-feature-support-... 680 7/22/2018
1.7.0.1338-feature-support-... 715 7/22/2018
1.7.0 1,015 7/22/2018
1.6.0.1329-feature-naming-t... 736 7/21/2018
1.5.0.1304 962 7/20/2018
1.5.0.1303-feature-class-le... 712 7/20/2018
1.5.0.1300 1,130 6/4/2018
1.5.0.1296-fix-datacontext-... 910 5/6/2018
1.5.0.1295 1,124 4/26/2018
1.5.0.1294 1,081 4/26/2018
1.5.0.1285 1,110 2/6/2018
1.5.0.1285-asynchooks-test 847 2/6/2018
1.5.0.1280-asynchooks-test 806 2/5/2018
1.3.1.1240 1,177 1/23/2018
1.3.1.1208 1,147 1/17/2018
1.3.1.1207 1,124 1/8/2018
1.3.1.1206 1,113 1/8/2018
1.3.1.1204 1,130 1/3/2018
1.3.1.1198 1,152 12/21/2017
1.3.1.1195 1,041 12/1/2017
1.3.1.1194 1,026 12/1/2017
1.3.1.1193 1,018 12/1/2017
1.3.1.1171 1,042 10/17/2017
1.3.1.1163 1,105 7/5/2017
1.3.1.1160 1,139 6/21/2017
1.3.1.1159 1,056 6/21/2017
1.3.1.1155 1,070 6/20/2017
1.3.1.1153 1,052 6/19/2017
1.3.1.1151 1,108 6/16/2017
1.3.1.1148 1,112 6/15/2017
1.3.0.1144 1,088 6/12/2017
1.3.0.1141 1,127 6/9/2017
1.3.0.1137 1,097 5/12/2017
1.3.0.1135 1,094 5/11/2017
1.3.0.1134 1,072 5/11/2017
1.3.0.1131 1,095 5/6/2017
1.3.0.1130 1,110 5/6/2017
1.3.0.1129 1,100 5/5/2017
1.3.0.1128 1,101 5/5/2017
1.2.0.1118 1,114 5/4/2017
1.2.0.1116 1,119 5/4/2017
1.2.0.1114 1,083 5/4/2017
1.2.0.1112 1,081 5/4/2017
1.2.0.1111 1,123 5/3/2017
1.2.0.1107 1,061 5/2/2017
1.2.0.1104 1,109 4/29/2017
1.2.0.1103 1,150 4/28/2017
1.2.0.1101 1,061 4/28/2017
1.2.0.1095 1,091 4/27/2017
1.2.0.1092 1,111 4/18/2017
1.2.0.1088 1,129 4/17/2017
1.2.0.1087 1,155 4/17/2017
1.2.0.1086 1,113 4/17/2017
1.2.0.1085 1,082 4/17/2017
1.2.0.1084 1,097 4/17/2017
1.2.0.1064-rc1 824 4/1/2017
1.2.0.1061-rc1 812 3/31/2017
1.2.0.1059-rc1 826 3/29/2017
1.2.0.1057-rc1 825 3/28/2017
1.2.0.1055-rc1 823 3/28/2017
1.1.1.1044 1,149 3/24/2017
1.1.1.1040 1,055 3/19/2017
1.1.1.1004 1,056 3/10/2017
1.1.1.1002 1,144 3/9/2017
1.1.1.1000 1,150 2/1/2017
1.1.1.998 1,096 1/31/2017
1.1.1.996 1,175 12/15/2016
1.1.1.991 1,138 11/28/2016
1.1.1.989 1,351 9/22/2016
1.1.1.987 1,545 9/22/2016
1.1.1.986 1,521 9/22/2016
1.1.1.985 1,524 9/22/2016
1.1.1.982 1,204 8/24/2016
1.1.1.980 1,141 8/24/2016
1.1.1.979 1,140 8/22/2016
1.1.0.975 1,139 8/22/2016
1.1.0.973 1,143 8/22/2016
1.1.0.972 1,155 8/22/2016
1.1.0.971 1,176 8/18/2016
1.1.0.970 1,148 8/16/2016
1.1.0.967 1,162 8/15/2016
1.1.0.966 1,153 8/15/2016
1.1.0.964 1,119 8/11/2016
1.1.0.963 1,139 8/9/2016
1.1.0.961 1,123 8/9/2016
1.1.0.960 1,187 8/9/2016
1.1.0.959 1,165 8/8/2016
1.1.0.957 1,177 8/7/2016
1.1.0.956 1,140 8/7/2016
1.1.0.947-rc 845 8/6/2016
1.1.0.946-rc 846 8/5/2016
1.1.0.945 1,141 8/5/2016
1.1.0.942 1,371 7/27/2016
1.1.0.941 1,377 7/27/2016
1.1.0.939 1,349 7/27/2016
1.1.0.938 1,371 7/27/2016
1.1.0.936 1,472 7/26/2016
1.1.0.935 1,118 7/26/2016
1.1.0.932 1,123 7/25/2016
1.1.0.930 1,149 7/23/2016
1.1.0.929 1,124 7/23/2016
1.1.0.928 1,119 7/22/2016
1.1.0.927 1,205 7/22/2016
1.1.0.924 1,233 7/22/2016
1.1.0.923 1,176 7/21/2016
1.1.0.918 1,164 7/20/2016
1.1.0.915 1,107 7/20/2016
1.1.0.912 1,121 7/20/2016
1.1.0.910 1,130 7/20/2016
1.1.0.904 1,105 7/19/2016
1.1.0.903 1,130 7/18/2016
1.1.0.902 1,134 7/18/2016
1.1.0.901 1,151 7/18/2016
1.1.0.887 1,120 7/16/2016
1.1.0.886 1,173 7/16/2016
1.1.0.883 1,263 7/14/2016
1.1.0.879 1,305 7/13/2016
1.1.0.877 1,277 7/12/2016
1.1.0.864 1,166 7/9/2016
1.1.0.863 1,196 7/9/2016
1.1.0.859 1,160 7/8/2016
1.1.0.858 1,170 7/8/2016
1.1.0.857 1,145 7/6/2016
1.1.0.856 1,167 6/29/2016
1.1.0.855 1,191 6/28/2016
1.1.0.854 1,174 6/25/2016
1.0.1.851-rc 1,191 6/17/2016
1.0.1.849-rc 1,172 6/17/2016
1.0.1.842-rc 945 6/9/2016
1.0.1.841-rc 972 6/9/2016
1.0.1.839-rc 1,039 6/9/2016
1.0.1.837-rc 868 5/31/2016
1.0.1.835-rc 886 5/26/2016
1.0.1.834-rc 821 5/24/2016
1.0.1.833-rc 907 5/20/2016
1.0.1.832-rc 865 5/20/2016
1.0.1.828-rc 840 5/9/2016
1.0.1.827-rc 827 5/7/2016
1.0.1.826-rc 836 5/2/2016
1.0.1.824-rc 853 5/1/2016
1.0.1.823-rc 1,003 4/21/2016
1.0.1.822-rc 847 4/20/2016
1.0.1.821-rc 820 4/11/2016
1.0.1.819-rc 894 4/11/2016
1.0.1.818-rc 885 4/8/2016
1.0.1.817-rc 873 4/7/2016
1.0.1.813-rc 857 4/7/2016
1.0.1.812-rc 841 3/30/2016
1.0.1.811-rc 879 3/30/2016
1.0.1.810-rc 865 3/30/2016
1.0.1.808-rc 831 3/30/2016
1.0.1.807-rc 873 3/29/2016
1.0.1.806-rc 851 3/29/2016
1.0.1.805-rc 857 3/29/2016
1.0.1.796-rc 864 3/27/2016
1.0.1.793-rc 817 3/27/2016
1.0.1.788-rc 876 3/26/2016
1.0.1.785-rc 834 3/26/2016
1.0.1.778-rc 888 3/22/2016
1.0.1.777-rc 1,085 3/22/2016
1.0.1.776-rc 916 3/18/2016
1.0.1.775-rc 809 3/18/2016
1.0.1.774-rc 845 3/16/2016
1.0.1.773-rc 829 3/16/2016
1.0.1.771-rc 844 3/15/2016
1.0.1.769-rc 858 3/15/2016
1.0.1.765-rc 802 3/15/2016
1.0.1.764-rc 800 3/15/2016
1.0.1.759-rc 877 3/14/2016
1.0.1.758-rc 842 3/14/2016
1.0.1.757-rc 831 3/14/2016
1.0.1.752-rc 839 3/13/2016
1.0.1.748-rc 924 3/13/2016
1.0.1.747-rc 930 3/13/2016
1.0.1.746-rc 841 3/13/2016
1.0.1.743-rc 827 3/9/2016
1.0.1.742-rc 850 3/8/2016
1.0.1.741-rc 844 3/8/2016
1.0.1.740-rc 858 3/7/2016
1.0.1.736-rc 864 3/7/2016
1.0.1.735-rc 845 3/7/2016
1.0.1.729-rc 841 3/6/2016
1.0.1.728-rc 828 3/6/2016
1.0.1.726-rc 796 3/6/2016
1.0.1.724-rc 838 3/4/2016
1.0.1.723-rc 870 3/3/2016
1.0.1.722-rc 855 3/3/2016
1.0.1.721-rc 821 3/3/2016
1.0.1.719-rc 970 3/2/2016
1.0.1.717-rc 850 3/1/2016
1.0.1.716-rc 1,039 2/28/2016
1.0.1.711-rc 1,312 2/28/2016
1.0.1.709-rc 1,177 2/27/2016
1.0.1.708-rc 1,345 2/27/2016
1.0.1.707-rc 916 2/27/2016
1.0.1.706-rc 1,205 2/26/2016
1.0.1.705-rc 1,209 2/26/2016
1.0.1.701-rc 1,261 2/25/2016
1.0.1.699-rc 896 2/23/2016
1.0.1.696-rc 958 2/21/2016
1.0.1.693-rc 898 2/20/2016
1.0.1.691-rc 840 2/19/2016
1.0.1.689-rc 882 2/19/2016
1.0.1.684-rc 871 2/18/2016
1.0.1.683-rc 865 2/18/2016
1.0.1.676-rc 837 2/17/2016
1.0.1.673-rc 872 2/17/2016
1.0.1.670-rc 865 2/17/2016
1.0.1.665-rc 838 2/15/2016
1.0.1.663-rc 869 2/14/2016
1.0.1.659-rc 881 2/14/2016
1.0.1.657-rc 849 2/14/2016
1.0.1.654-rc 861 2/14/2016
1.0.1.648-rc 864 2/13/2016
1.0.1.647-rc 976 2/13/2016
1.0.1.632-rc 858 2/11/2016
1.0.1.631-rc 834 2/11/2016
1.0.1.626-rc 847 2/10/2016
1.0.1.625-rc 838 2/10/2016
1.0.1.609-rc 844 2/4/2016
1.0.1.605-rc 886 2/4/2016
1.0.1.604-rc 858 2/4/2016
1.0.1.600-rc 848 1/28/2016
1.0.1.597-rc 868 1/27/2016
1.0.1.596-rc 826 1/26/2016
1.0.1.595-rc 867 1/22/2016
1.0.1.593-rc 895 1/22/2016
1.0.1.590-rc 875 1/21/2016
1.0.1.588-rc 857 1/20/2016
1.0.1.583-rc 841 1/20/2016
1.0.1.582-rc 848 1/20/2016
1.0.1.574-rc 840 1/19/2016
1.0.1.571-rc 838 1/19/2016
1.0.1.570-rc 881 1/18/2016
1.0.1.569-rc 879 1/17/2016
1.0.1.568-rc 1,121 1/15/2016
1.0.1.565-rc 867 1/8/2016
1.0.1.564-rc 868 1/8/2016
1.0.1.561-rc 851 1/6/2016
1.0.1.557-rc 866 1/3/2016
1.0.1.554-rc 973 12/22/2015
1.0.1.553-rc 1,035 12/22/2015
1.0.1.552-rc 960 12/22/2015
1.0.1.551-rc 862 12/21/2015
1.0.1.550-rc 890 12/20/2015
1.0.1.545-rc 822 12/17/2015
1.0.1.543-rc 861 12/17/2015
1.0.1.542-rc 850 12/16/2015
1.0.1.539-rc 873 12/16/2015
1.0.1.525-rc 860 12/16/2015
1.0.1.521-rc 874 12/15/2015
1.0.1.512-rc 855 12/14/2015
1.0.1.508-rc 858 12/14/2015
1.0.1.505-rc 838 12/14/2015
1.0.0.492-rc 846 12/11/2015
1.0.0.491-rc 862 12/11/2015
1.0.0.488-rc 954 12/11/2015
1.0.0.487-rc 902 12/11/2015
1.0.0.485-rc 1,059 12/9/2015
1.0.0.481-rc 844 12/8/2015
1.0.0.479-rc 1,056 12/7/2015
1.0.0.473-rc 940 12/6/2015
1.0.0.472-rc 1,218 12/3/2015
1.0.0.469-rc 989 12/1/2015
1.0.0.465-rc 935 11/19/2015
1.0.0.464-rc 923 11/16/2015
1.0.0.458-rc 901 11/3/2015
1.0.0.448-rc 914 10/27/2015
1.0.0.447-rc 867 10/27/2015
1.0.0.446-rc 851 10/27/2015
1.0.0.443-rc 877 10/27/2015
1.0.0.441-rc 893 10/26/2015
1.0.0.436-rc 899 10/26/2015
1.0.0.434-rc 854 10/26/2015
0.9.1.426 1,350 10/8/2015
0.9.1.424 1,238 10/6/2015
0.9.1.418 1,317 9/29/2015
0.9.1.415 1,244 9/29/2015
0.9.1.411 1,265 9/28/2015
0.9.1.408 1,234 9/3/2015
0.9.1.407 1,208 8/18/2015
0.9.1.406 1,744 8/13/2015
0.9.1.405 1,385 8/13/2015
0.9.1.404 1,315 8/13/2015
0.9.1.401 1,403 7/21/2015
0.9.1.395 1,271 7/5/2015
0.9.1.394 1,194 7/4/2015
0.9.1.393 1,176 7/4/2015
0.9.1.390 1,193 6/13/2015
0.9.1.388 1,202 6/13/2015
0.9.1.386 1,180 6/13/2015
0.9.1.385 1,212 6/12/2015
0.9.1.382 1,209 6/12/2015
0.9.1.381 1,251 6/12/2015
0.9.1.380 1,162 6/12/2015
0.9.1.378 1,201 6/12/2015
0.9.1.375 1,771 2/27/2015
0.9.1.373 1,448 2/25/2015
0.9.1.370 1,545 2/25/2015
0.9.1.367 1,569 2/23/2015
0.9.1.365 1,614 2/21/2015
0.9.1.361 1,614 2/21/2015
0.9.1.358 1,423 2/16/2015
0.9.1.357 1,345 2/11/2015
0.9.0.355 1,285 2/10/2015
0.9.0.354 1,225 2/1/2015
0.9.0.353 1,297 1/30/2015
0.9.0.350 1,265 1/29/2015
0.9.0.338 1,240 1/12/2015
0.9.0.328 1,409 11/25/2014
0.9.0.326 1,372 11/24/2014
0.9.0.325 1,346 11/24/2014
0.9.0.323 1,338 11/23/2014
0.9.0.313 1,354 11/22/2014
0.9.0.299 1,454 11/12/2014
0.9.0.295 1,620 11/12/2014
0.9.0.290 1,387 11/11/2014
0.9.0.279 1,568 11/9/2014
0.9.0.269 1,492 11/6/2014
0.9.0.268 1,772 11/4/2014
0.9.0.266 1,984 11/3/2014
0.9.0.265 1,535 11/3/2014
0.9.0.263 1,757 11/3/2014
0.9.0.262 1,467 11/3/2014
0.9.0.249 1,212 10/27/2014
0.9.0.236 1,262 10/25/2014
0.9.0.234 1,267 10/24/2014
0.9.0.233 1,249 10/21/2014
0.9.0.227 1,220 10/21/2014
0.9.0.226 1,210 10/21/2014
0.9.0.225 1,253 10/21/2014
0.9.0.222 1,217 10/19/2014
0.9.0.221 1,237 10/19/2014
0.9.0.204 1,222 10/17/2014
0.9.0.200 1,259 10/15/2014
0.9.0.199 1,238 10/15/2014
0.9.0.193 1,240 10/14/2014
0.9.0.189 1,213 10/14/2014
0.9.0.184-test 939 10/14/2014
0.9.0.183-test 930 10/13/2014
0.9.0.179 1,245 10/13/2014
0.9.0.174 1,249 10/13/2014
0.6.0.173 1,207 10/13/2014
0.6.0.165 1,233 10/3/2014
0.6.0.160 1,258 9/18/2014
0.6.0.157 1,228 9/18/2014
0.6.0.155 1,240 9/18/2014
0.6.0.151 1,237 9/17/2014
0.6.0.147 1,199 9/16/2014
0.6.0.143 1,190 9/12/2014
0.6.0.141 1,255 9/10/2014
0.6.0.139 1,275 9/3/2014
0.6.0.135 1,284 8/21/2014
0.6.0.134 1,278 8/8/2014
0.6.0.130 1,299 8/4/2014
0.6.0.127 1,312 7/1/2014
0.6.0.101 1,450 1/21/2014
0.6.0.97 1,311 1/16/2014
0.5.0.51 1,248 1/5/2014
0.5.0.36 1,330 12/9/2013
0.5.0.35 1,247 12/8/2013
0.5.0.28 1,304 12/1/2013

- 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