Shaolinq.Postgres 0.6.0.173

There is a newer version of this package available.
See the version list below for details.
dotnet add package Shaolinq.Postgres --version 0.6.0.173
                    
NuGet\Install-Package Shaolinq.Postgres -Version 0.6.0.173
                    
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" Version="0.6.0.173" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Shaolinq.Postgres" Version="0.6.0.173" />
                    
Directory.Packages.props
<PackageReference Include="Shaolinq.Postgres" />
                    
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 --version 0.6.0.173
                    
#r "nuget: Shaolinq.Postgres, 0.6.0.173"
                    
#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@0.6.0.173
                    
#: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&version=0.6.0.173
                    
Install as a Cake Addin
#tool nuget:?package=Shaolinq.Postgres&version=0.6.0.173
                    
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 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!

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 960 10/1/2020
1.9.5.1476-refs-pull-109-head 894 10/1/2020
1.9.5.1475-refs-pull-100-merge 902 9/30/2020
1.9.5.1474-refs-pull-104-merge 913 9/30/2020
1.9.5.1471-refs-pull-108-merge 877 9/30/2020
1.9.5.1470-refs-pull-108-merge 953 9/30/2020
1.9.5.1469-refs-pull-108-head 936 9/30/2020
1.9.5.1468-refs-pull-107-merge 950 9/30/2020
1.9.5.1467-refs-pull-107-head 927 9/30/2020
1.9.5.1466-refs-pull-106-merge 920 9/30/2020
1.9.5.1465-refs-pull-106-head 973 9/30/2020
1.9.5.1464-refs-pull-105-merge 958 9/30/2020
1.9.5.1462-refs-pull-104-merge 989 9/30/2020
1.9.5.1460-refs-pull-100-merge 952 4/1/2020
1.9.5 1,581 1/17/2020
1.9.4.1454-refs-pull-97-merge 1,079 9/18/2019
1.9.4.1453-refs-pull-97-head 988 9/18/2019
1.9.4.1452-refs-pull-96-merge 969 9/18/2019
1.9.4.1451-refs-pull-96-head 970 9/18/2019
1.9.4.1450-refs-pull-95-merge 1,019 9/18/2019
1.9.4.1449-refs-pull-95-head 969 9/18/2019
1.9.4 6,543 11/9/2018
1.9.3.1445-fix-null-enum-bug 1,171 11/9/2018
1.9.3 1,401 11/9/2018
1.9.1.1438-feature-allow-re... 1,186 10/23/2018
1.9.1 1,391 10/23/2018
1.9.0.1437-feature-model-ge... 1,220 10/21/2018
1.9.0.1435-fix-query-cachin... 1,180 10/18/2018
1.9.0 1,435 10/18/2018
1.8.15 1,449 10/17/2018
1.8.14.1433-fix-nested-quer... 1,226 10/17/2018
1.8.14 1,467 10/16/2018
1.8.13.1429-fix-fix-nested-... 1,196 10/15/2018
1.8.13 1,452 10/15/2018
1.8.12 1,527 10/2/2018
1.8.11.1420-feature-allow-i... 1,246 10/2/2018
1.8.11.1419-feature-allow-i... 1,231 10/1/2018
1.8.11.1418-feature-allow-i... 1,236 10/1/2018
1.8.11 1,426 9/25/2018
1.8.10.1416-fix-distinct-co... 1,248 9/25/2018
1.8.10 1,665 8/16/2018
1.8.9 1,605 8/16/2018
1.8.8.1409-feature-sqlserve... 1,327 8/13/2018
1.8.8 1,596 8/10/2018
1.8.7.1404-fix-sql-index-an... 1,301 8/10/2018
1.8.7 1,639 8/10/2018
1.8.6 1,630 8/8/2018
1.8.4.1394-feature-exclude-... 1,447 8/7/2018
1.8.4 1,652 8/7/2018
1.8.3.1391-feature-unique-i... 1,412 8/7/2018
1.8.3 1,694 8/6/2018
1.8.2.1387-fix-support-over... 1,416 8/6/2018
1.8.2 1,635 8/2/2018
1.8.1.1384-fix-computed-mem... 1,391 8/1/2018
1.8.1.1383-fix-computed-mem... 1,406 8/1/2018
1.8.1 1,648 7/29/2018
1.8.0 1,636 7/28/2018
1.7.2 1,642 7/23/2018
1.7.1 1,689 7/22/2018
1.7.0.1340-feature-support-... 1,451 7/22/2018
1.7.0.1338-feature-support-... 1,372 7/22/2018
1.7.0 1,665 7/22/2018
1.6.0.1329-feature-naming-t... 1,421 7/21/2018
1.5.0.1304 1,653 7/20/2018
1.5.0.1303-feature-class-le... 1,431 7/20/2018
1.5.0.1300 1,950 6/4/2018
1.5.0.1296-fix-datacontext-... 1,750 5/6/2018
1.5.0.1295 1,973 4/26/2018
1.5.0.1294 1,916 4/26/2018
1.5.0.1285 1,930 2/6/2018
1.5.0.1285-asynchooks-test 1,693 2/6/2018
1.5.0.1280-asynchooks-test 1,643 2/5/2018
1.3.1.1240 1,941 1/23/2018
1.3.1.1208 2,003 1/17/2018
1.3.1.1207 1,945 1/8/2018
1.3.1.1206 1,949 1/8/2018
1.3.1.1204 1,949 1/3/2018
1.3.1.1198 1,959 12/21/2017
1.3.1.1195 1,715 12/1/2017
1.3.1.1194 1,759 12/1/2017
1.3.1.1193 1,704 12/1/2017
1.3.1.1171 1,831 10/17/2017
1.3.1.1163 1,814 7/5/2017
1.3.1.1160 1,840 6/21/2017
1.3.1.1159 1,739 6/21/2017
1.3.1.1155 1,756 6/20/2017
1.3.1.1153 1,727 6/19/2017
1.3.1.1151 1,778 6/16/2017
1.3.1.1148 1,805 6/15/2017
1.3.0.1144 1,786 6/12/2017
1.3.0.1141 1,864 6/9/2017
1.3.0.1137 1,788 5/12/2017
1.3.0.1135 1,762 5/11/2017
1.3.0.1134 1,768 5/11/2017
1.3.0.1131 1,799 5/6/2017
1.3.0.1130 1,789 5/6/2017
1.3.0.1129 1,771 5/5/2017
1.3.0.1128 1,781 5/5/2017
1.2.0.1118 1,775 5/4/2017
1.2.0.1116 1,709 5/4/2017
1.2.0.1114 1,747 5/4/2017
1.2.0.1112 1,837 5/4/2017
1.2.0.1111 1,769 5/3/2017
1.2.0.1107 1,774 5/2/2017
1.2.0.1104 1,782 4/29/2017
1.2.0.1103 1,766 4/28/2017
1.2.0.1101 1,811 4/28/2017
1.2.0.1095 1,835 4/27/2017
1.2.0.1092 1,787 4/18/2017
1.2.0.1088 1,759 4/17/2017
1.2.0.1087 1,920 4/17/2017
1.2.0.1086 1,885 4/17/2017
1.2.0.1085 1,998 4/17/2017
1.2.0.1084 1,943 4/17/2017
1.2.0.1072-rc1 1,684 4/14/2017
1.2.0.1071-rc1 1,716 4/14/2017
1.2.0.1064-rc1 1,636 4/1/2017
1.2.0.1061-rc1 1,617 3/31/2017
1.2.0.1059-rc1 1,586 3/29/2017
1.2.0.1057-rc1 1,573 3/28/2017
1.2.0.1055-rc1 1,690 3/28/2017
1.1.1.1044 1,922 3/24/2017
1.1.1.1040 1,936 3/19/2017
1.1.1.1004 1,761 3/10/2017
1.1.1.1002 1,794 3/9/2017
1.1.1.1000 1,771 2/1/2017
1.1.1.998 1,705 1/31/2017
1.1.1.996 1,846 12/15/2016
1.1.1.991 1,820 11/28/2016
1.1.1.989 2,609 9/22/2016
1.1.1.987 2,112 9/22/2016
1.1.1.986 2,186 9/22/2016
1.1.1.985 2,212 9/22/2016
1.1.1.982 1,891 8/24/2016
1.1.1.980 1,815 8/24/2016
1.1.1.979 1,778 8/22/2016
1.1.0.975 1,758 8/22/2016
1.1.0.973 1,789 8/22/2016
1.1.0.972 1,778 8/22/2016
1.1.0.971 1,774 8/18/2016
1.1.0.970 1,765 8/16/2016
1.1.0.967 1,728 8/15/2016
1.1.0.966 1,814 8/15/2016
1.1.0.964 1,828 8/11/2016
1.1.0.963 1,842 8/9/2016
1.1.0.961 1,780 8/9/2016
1.1.0.960 1,806 8/9/2016
1.1.0.959 1,786 8/8/2016
1.1.0.957 1,761 8/7/2016
1.1.0.956 1,782 8/7/2016
1.1.0.947-rc 1,531 8/6/2016
1.1.0.946-rc 1,577 8/5/2016
1.1.0.945 1,849 8/5/2016
1.1.0.942 2,051 7/27/2016
1.1.0.941 2,024 7/27/2016
1.1.0.939 1,875 7/27/2016
1.1.0.938 1,903 7/27/2016
1.1.0.936 2,146 7/26/2016
1.1.0.935 1,779 7/26/2016
1.1.0.932 1,882 7/25/2016
1.1.0.930 1,866 7/23/2016
1.1.0.929 1,842 7/23/2016
1.1.0.928 1,830 7/22/2016
1.1.0.927 1,809 7/22/2016
1.1.0.924 1,902 7/22/2016
1.1.0.923 1,847 7/21/2016
1.1.0.918 1,830 7/20/2016
1.1.0.915 1,802 7/20/2016
1.1.0.912 1,812 7/20/2016
1.1.0.910 1,790 7/20/2016
1.1.0.904 1,844 7/19/2016
1.1.0.903 1,772 7/18/2016
1.1.0.902 1,804 7/18/2016
1.1.0.901 1,876 7/18/2016
1.1.0.887 1,804 7/16/2016
1.1.0.886 1,849 7/16/2016
1.1.0.883 1,921 7/14/2016
1.1.0.879 1,963 7/13/2016
1.1.0.877 1,969 7/12/2016
1.1.0.864 1,826 7/9/2016
1.1.0.863 1,803 7/9/2016
1.1.0.859 1,792 7/8/2016
1.1.0.858 1,824 7/8/2016
1.1.0.857 1,852 7/6/2016
1.1.0.856 1,818 6/29/2016
1.1.0.855 1,834 6/28/2016
1.1.0.854 1,826 6/25/2016
1.0.1.851-rc 1,916 6/17/2016
1.0.1.849-rc 1,889 6/17/2016
1.0.1.842-rc 1,700 6/9/2016
1.0.1.841-rc 1,703 6/9/2016
1.0.1.839-rc 1,742 6/9/2016
1.0.1.837-rc 1,671 5/31/2016
1.0.1.835-rc 1,571 5/26/2016
1.0.1.834-rc 1,543 5/24/2016
1.0.1.833-rc 1,571 5/20/2016
1.0.1.832-rc 1,601 5/20/2016
1.0.1.828-rc 1,543 5/9/2016
1.0.1.827-rc 1,562 5/7/2016
1.0.1.826-rc 1,564 5/2/2016
1.0.1.824-rc 1,544 5/1/2016
1.0.1.823-rc 1,684 4/21/2016
1.0.1.822-rc 1,507 4/20/2016
1.0.1.821-rc 1,493 4/11/2016
1.0.1.819-rc 1,513 4/11/2016
1.0.1.818-rc 1,531 4/8/2016
1.0.1.817-rc 1,584 4/7/2016
1.0.1.813-rc 1,556 4/7/2016
1.0.1.812-rc 1,547 3/30/2016
1.0.1.811-rc 1,573 3/30/2016
1.0.1.810-rc 1,541 3/30/2016
1.0.1.808-rc 1,575 3/30/2016
1.0.1.807-rc 1,542 3/29/2016
1.0.1.806-rc 1,541 3/29/2016
1.0.1.805-rc 1,589 3/29/2016
1.0.1.796-rc 1,538 3/27/2016
1.0.1.793-rc 1,548 3/27/2016
1.0.1.788-rc 1,549 3/26/2016
1.0.1.785-rc 1,538 3/26/2016
1.0.1.778-rc 1,587 3/22/2016
1.0.1.777-rc 1,914 3/22/2016
1.0.1.776-rc 1,561 3/18/2016
1.0.1.775-rc 1,564 3/18/2016
1.0.1.774-rc 1,566 3/16/2016
1.0.1.773-rc 1,541 3/16/2016
1.0.1.771-rc 1,520 3/15/2016
1.0.1.769-rc 1,509 3/15/2016
1.0.1.765-rc 1,538 3/15/2016
1.0.1.764-rc 1,594 3/15/2016
1.0.1.759-rc 1,596 3/14/2016
1.0.1.758-rc 1,543 3/14/2016
1.0.1.757-rc 1,555 3/14/2016
1.0.1.752-rc 1,528 3/13/2016
1.0.1.748-rc 1,723 3/13/2016
1.0.1.747-rc 1,779 3/13/2016
1.0.1.746-rc 1,544 3/13/2016
1.0.1.743-rc 1,552 3/9/2016
1.0.1.742-rc 1,586 3/8/2016
1.0.1.741-rc 1,586 3/8/2016
1.0.1.740-rc 1,566 3/7/2016
1.0.1.736-rc 1,610 3/7/2016
1.0.1.735-rc 1,594 3/7/2016
1.0.1.729-rc 1,615 3/6/2016
1.0.1.728-rc 1,567 3/6/2016
1.0.1.726-rc 1,586 3/6/2016
1.0.1.724-rc 1,623 3/4/2016
1.0.1.723-rc 1,558 3/3/2016
1.0.1.722-rc 1,565 3/3/2016
1.0.1.721-rc 1,575 3/3/2016
1.0.1.719-rc 1,577 3/2/2016
1.0.1.717-rc 1,553 3/1/2016
1.0.1.716-rc 1,852 2/28/2016
1.0.1.711-rc 1,998 2/28/2016
1.0.1.709-rc 1,818 2/27/2016
1.0.1.708-rc 2,066 2/27/2016
1.0.1.707-rc 1,574 2/27/2016
1.0.1.706-rc 2,009 2/26/2016
1.0.1.705-rc 1,643 2/26/2016
1.0.1.701-rc 1,963 2/25/2016
1.0.1.699-rc 1,773 2/23/2016
1.0.1.696-rc 1,597 2/21/2016
1.0.1.693-rc 1,724 2/20/2016
1.0.1.691-rc 1,611 2/19/2016
1.0.1.689-rc 1,551 2/19/2016
1.0.1.684-rc 1,629 2/18/2016
1.0.1.683-rc 1,577 2/18/2016
1.0.1.676-rc 1,600 2/17/2016
1.0.1.673-rc 1,556 2/17/2016
1.0.1.670-rc 1,586 2/17/2016
1.0.1.665-rc 1,534 2/15/2016
1.0.1.663-rc 1,586 2/14/2016
1.0.1.659-rc 1,567 2/14/2016
1.0.1.657-rc 1,512 2/14/2016
1.0.1.654-rc 1,575 2/14/2016
1.0.1.648-rc 1,818 2/13/2016
1.0.1.647-rc 1,841 2/13/2016
1.0.1.632-rc 1,569 2/11/2016
1.0.1.631-rc 1,562 2/11/2016
1.0.1.626-rc 1,551 2/10/2016
1.0.1.625-rc 1,571 2/10/2016
1.0.1.609-rc 1,601 2/4/2016
1.0.1.605-rc 1,605 2/4/2016
1.0.1.604-rc 1,545 2/4/2016
1.0.1.600-rc 1,569 1/28/2016
1.0.1.597-rc 1,590 1/27/2016
1.0.1.596-rc 1,542 1/26/2016
1.0.1.595-rc 1,573 1/22/2016
1.0.1.593-rc 1,582 1/22/2016
1.0.1.590-rc 1,563 1/21/2016
1.0.1.588-rc 1,542 1/20/2016
1.0.1.583-rc 1,545 1/20/2016
1.0.1.582-rc 1,546 1/20/2016
1.0.1.574-rc 1,575 1/19/2016
1.0.1.571-rc 1,544 1/19/2016
1.0.1.570-rc 1,578 1/18/2016
1.0.1.569-rc 1,573 1/17/2016
1.0.1.568-rc 1,706 1/15/2016
1.0.1.565-rc 1,594 1/8/2016
1.0.1.564-rc 1,582 1/8/2016
1.0.1.561-rc 1,594 1/6/2016
1.0.1.557-rc 1,600 1/3/2016
1.0.1.554-rc 1,823 12/22/2015
1.0.1.553-rc 1,822 12/22/2015
1.0.1.552-rc 1,873 12/22/2015
1.0.1.551-rc 1,581 12/21/2015
1.0.1.550-rc 1,608 12/20/2015
1.0.1.545-rc 1,633 12/17/2015
1.0.1.543-rc 1,593 12/17/2015
1.0.1.542-rc 1,595 12/16/2015
1.0.1.539-rc 1,625 12/16/2015
1.0.1.525-rc 1,574 12/16/2015
1.0.1.521-rc 1,531 12/15/2015
1.0.1.512-rc 1,565 12/14/2015
1.0.1.508-rc 1,558 12/14/2015
1.0.1.505-rc 1,542 12/14/2015
1.0.0.492-rc 1,838 12/11/2015
1.0.0.491-rc 1,607 12/11/2015
1.0.0.488-rc 1,785 12/11/2015
1.0.0.487-rc 1,550 12/11/2015
1.0.0.485-rc 1,834 12/9/2015
1.0.0.481-rc 1,554 12/8/2015
1.0.0.479-rc 1,578 12/7/2015
1.0.0.473-rc 1,572 12/6/2015
1.0.0.472-rc 1,712 12/3/2015
1.0.0.469-rc 1,680 12/1/2015
1.0.0.465-rc 1,650 11/19/2015
1.0.0.464-rc 1,630 11/16/2015
1.0.0.458-rc 1,616 11/3/2015
1.0.0.448-rc 1,617 10/27/2015
1.0.0.447-rc 1,606 10/27/2015
1.0.0.446-rc 1,570 10/27/2015
1.0.0.443-rc 1,599 10/27/2015
1.0.0.441-rc 1,560 10/26/2015
1.0.0.436-rc 1,602 10/26/2015
1.0.0.434-rc 1,592 10/26/2015
1.0.0.433-rc 1,610 10/26/2015
0.9.1.426 2,463 10/8/2015
0.9.1.424 2,191 10/6/2015
0.9.1.418 2,001 9/29/2015
0.9.1.415 1,999 9/29/2015
0.9.1.411 2,004 9/28/2015
0.9.1.408 1,951 9/3/2015
0.9.1.407 1,970 8/18/2015
0.9.1.406 2,508 8/13/2015
0.9.1.405 1,890 8/13/2015
0.9.1.404 2,324 8/13/2015
0.9.1.401 2,297 7/21/2015
0.9.1.395 1,957 7/5/2015
0.9.1.394 1,918 7/4/2015
0.9.1.393 1,893 7/4/2015
0.9.1.390 1,924 6/13/2015
0.9.1.388 1,988 6/13/2015
0.9.1.386 1,870 6/13/2015
0.9.1.385 1,848 6/12/2015
0.9.1.382 1,847 6/12/2015
0.9.1.381 1,893 6/12/2015
0.9.1.380 1,865 6/12/2015
0.9.1.378 1,925 6/12/2015
0.9.1.375 2,004 2/27/2015
0.9.1.373 2,260 2/25/2015
0.9.1.370 2,229 2/25/2015
0.9.1.367 2,250 2/23/2015
0.9.1.365 2,197 2/21/2015
0.9.1.361 2,312 2/21/2015
0.9.1.358 2,199 2/16/2015
0.9.1.357 1,987 2/11/2015
0.9.0.355 2,097 2/10/2015
0.9.0.354 1,895 2/1/2015
0.9.0.353 1,930 1/30/2015
0.9.0.350 1,929 1/29/2015
0.9.0.338 1,883 1/12/2015
0.9.0.328 2,052 11/25/2014
0.9.0.326 2,034 11/24/2014
0.9.0.325 2,053 11/24/2014
0.9.0.323 2,080 11/23/2014
0.9.0.313 2,143 11/22/2014
0.9.0.299 2,109 11/12/2014
0.9.0.295 2,204 11/12/2014
0.9.0.290 2,095 11/11/2014
0.9.0.279 2,322 11/9/2014
0.9.0.269 2,229 11/6/2014
0.9.0.268 2,428 11/4/2014
0.9.0.266 2,687 11/3/2014
0.9.0.265 2,159 11/3/2014
0.9.0.263 2,445 11/3/2014
0.9.0.262 2,246 11/3/2014
0.9.0.249 1,999 10/27/2014
0.9.0.236 1,972 10/25/2014
0.9.0.234 1,989 10/24/2014
0.9.0.233 1,916 10/21/2014
0.9.0.227 1,895 10/21/2014
0.9.0.226 1,925 10/21/2014
0.9.0.225 1,975 10/21/2014
0.9.0.222 1,917 10/19/2014
0.9.0.221 1,903 10/19/2014
0.9.0.204 1,928 10/17/2014
0.9.0.200 1,852 10/15/2014
0.9.0.199 1,916 10/15/2014
0.9.0.193 1,921 10/14/2014
0.9.0.189 1,950 10/14/2014
0.9.0.184-test 1,704 10/14/2014
0.9.0.183-test 1,658 10/13/2014
0.9.0.179 1,981 10/13/2014
0.9.0.174 1,931 10/13/2014
0.6.0.173 1,946 10/13/2014
0.6.0.165 1,999 10/3/2014
0.6.0.160 1,932 9/18/2014
0.6.0.157 1,941 9/18/2014
0.6.0.155 1,974 9/18/2014
0.6.0.151 1,949 9/17/2014
0.6.0.147 1,975 9/16/2014
0.6.0.143 1,958 9/12/2014
0.6.0.141 1,970 9/10/2014
0.6.0.139 1,975 9/3/2014
0.6.0.135 1,897 8/21/2014
0.6.0.134 1,974 8/8/2014
0.6.0.130 1,988 8/4/2014
0.6.0.127 1,975 7/1/2014
0.6.0.101 2,093 1/21/2014
0.6.0.97 1,978 1/16/2014
0.5.0.51 2,025 1/5/2014
0.5.0.36 1,952 12/9/2013
0.5.0.35 2,138 12/8/2013
0.5.0.28 2,050 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