Shaolinq.Postgres 0.9.0.183-test

This is a prerelease version of Shaolinq.Postgres.
There is a newer version of this package available.
See the version list below for details.
dotnet add package Shaolinq.Postgres --version 0.9.0.183-test
                    
NuGet\Install-Package Shaolinq.Postgres -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" 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" Version="0.9.0.183-test" />
                    
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.9.0.183-test
                    
#r "nuget: Shaolinq.Postgres, 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.
#addin nuget:?package=Shaolinq.Postgres&version=0.9.0.183-test&prerelease
                    
Install Shaolinq.Postgres as a Cake Addin
#tool nuget:?package=Shaolinq.Postgres&version=0.9.0.183-test&prerelease
                    
Install Shaolinq.Postgres 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 839 10/1/2020
1.9.5.1476-refs-pull-109-head 785 10/1/2020
1.9.5.1475-refs-pull-100-merge 809 9/30/2020
1.9.5.1474-refs-pull-104-merge 804 9/30/2020
1.9.5.1471-refs-pull-108-merge 767 9/30/2020
1.9.5.1470-refs-pull-108-merge 847 9/30/2020
1.9.5.1469-refs-pull-108-head 823 9/30/2020
1.9.5.1468-refs-pull-107-merge 841 9/30/2020
1.9.5.1467-refs-pull-107-head 803 9/30/2020
1.9.5.1466-refs-pull-106-merge 815 9/30/2020
1.9.5.1465-refs-pull-106-head 863 9/30/2020
1.9.5.1464-refs-pull-105-merge 854 9/30/2020
1.9.5.1462-refs-pull-104-merge 881 9/30/2020
1.9.5.1460-refs-pull-100-merge 854 4/1/2020
1.9.5 1,435 1/17/2020
1.9.4.1454-refs-pull-97-merge 961 9/18/2019
1.9.4.1453-refs-pull-97-head 876 9/18/2019
1.9.4.1452-refs-pull-96-merge 869 9/18/2019
1.9.4.1451-refs-pull-96-head 871 9/18/2019
1.9.4.1450-refs-pull-95-merge 920 9/18/2019
1.9.4.1449-refs-pull-95-head 856 9/18/2019
1.9.4 4,317 11/9/2018
1.9.3.1445-fix-null-enum-bug 1,058 11/9/2018
1.9.3 1,294 11/9/2018
1.9.1.1438-feature-allow-re... 1,063 10/23/2018
1.9.1 1,280 10/23/2018
1.9.0.1437-feature-model-ge... 1,098 10/21/2018
1.9.0.1435-fix-query-cachin... 1,072 10/18/2018
1.9.0 1,325 10/18/2018
1.8.15 1,325 10/17/2018
1.8.14.1433-fix-nested-quer... 1,098 10/17/2018
1.8.14 1,344 10/16/2018
1.8.13.1429-fix-fix-nested-... 1,088 10/15/2018
1.8.13 1,345 10/15/2018
1.8.12 1,398 10/2/2018
1.8.11.1420-feature-allow-i... 1,119 10/2/2018
1.8.11.1419-feature-allow-i... 1,122 10/1/2018
1.8.11.1418-feature-allow-i... 1,110 10/1/2018
1.8.11 1,294 9/25/2018
1.8.10.1416-fix-distinct-co... 1,118 9/25/2018
1.8.10 1,537 8/16/2018
1.8.9 1,493 8/16/2018
1.8.8.1409-feature-sqlserve... 1,212 8/13/2018
1.8.8 1,477 8/10/2018
1.8.7.1404-fix-sql-index-an... 1,192 8/10/2018
1.8.7 1,494 8/10/2018
1.8.6 1,501 8/8/2018
1.8.4.1394-feature-exclude-... 1,267 8/7/2018
1.8.4 1,476 8/7/2018
1.8.3.1391-feature-unique-i... 1,219 8/7/2018
1.8.3 1,492 8/6/2018
1.8.2.1387-fix-support-over... 1,222 8/6/2018
1.8.2 1,462 8/2/2018
1.8.1.1384-fix-computed-mem... 1,213 8/1/2018
1.8.1.1383-fix-computed-mem... 1,227 8/1/2018
1.8.1 1,462 7/29/2018
1.8.0 1,447 7/28/2018
1.7.2 1,464 7/23/2018
1.7.1 1,499 7/22/2018
1.7.0.1340-feature-support-... 1,240 7/22/2018
1.7.0.1338-feature-support-... 1,188 7/22/2018
1.7.0 1,468 7/22/2018
1.6.0.1329-feature-naming-t... 1,231 7/21/2018
1.5.0.1304 1,446 7/20/2018
1.5.0.1303-feature-class-le... 1,221 7/20/2018
1.5.0.1300 1,677 6/4/2018
1.5.0.1296-fix-datacontext-... 1,468 5/6/2018
1.5.0.1295 1,711 4/26/2018
1.5.0.1294 1,635 4/26/2018
1.5.0.1285 1,654 2/6/2018
1.5.0.1285-asynchooks-test 1,417 2/6/2018
1.5.0.1280-asynchooks-test 1,372 2/5/2018
1.3.1.1240 1,670 1/23/2018
1.3.1.1208 1,734 1/17/2018
1.3.1.1207 1,665 1/8/2018
1.3.1.1206 1,681 1/8/2018
1.3.1.1204 1,682 1/3/2018
1.3.1.1198 1,670 12/21/2017
1.3.1.1195 1,488 12/1/2017
1.3.1.1194 1,536 12/1/2017
1.3.1.1193 1,519 12/1/2017
1.3.1.1171 1,613 10/17/2017
1.3.1.1163 1,619 7/5/2017
1.3.1.1160 1,651 6/21/2017
1.3.1.1159 1,558 6/21/2017
1.3.1.1155 1,575 6/20/2017
1.3.1.1153 1,517 6/19/2017
1.3.1.1151 1,569 6/16/2017
1.3.1.1148 1,595 6/15/2017
1.3.0.1144 1,573 6/12/2017
1.3.0.1141 1,672 6/9/2017
1.3.0.1137 1,605 5/12/2017
1.3.0.1135 1,562 5/11/2017
1.3.0.1134 1,578 5/11/2017
1.3.0.1131 1,601 5/6/2017
1.3.0.1130 1,571 5/6/2017
1.3.0.1129 1,582 5/5/2017
1.3.0.1128 1,585 5/5/2017
1.2.0.1118 1,553 5/4/2017
1.2.0.1116 1,530 5/4/2017
1.2.0.1114 1,556 5/4/2017
1.2.0.1112 1,643 5/4/2017
1.2.0.1111 1,590 5/3/2017
1.2.0.1107 1,565 5/2/2017
1.2.0.1104 1,567 4/29/2017
1.2.0.1103 1,563 4/28/2017
1.2.0.1101 1,620 4/28/2017
1.2.0.1095 1,640 4/27/2017
1.2.0.1092 1,587 4/18/2017
1.2.0.1088 1,550 4/17/2017
1.2.0.1087 1,708 4/17/2017
1.2.0.1086 1,650 4/17/2017
1.2.0.1085 1,801 4/17/2017
1.2.0.1084 1,735 4/17/2017
1.2.0.1072-rc1 1,455 4/14/2017
1.2.0.1071-rc1 1,490 4/14/2017
1.2.0.1064-rc1 1,430 4/1/2017
1.2.0.1061-rc1 1,411 3/31/2017
1.2.0.1059-rc1 1,374 3/29/2017
1.2.0.1057-rc1 1,360 3/28/2017
1.2.0.1055-rc1 1,459 3/28/2017
1.1.1.1044 1,682 3/24/2017
1.1.1.1040 1,724 3/19/2017
1.1.1.1004 1,573 3/10/2017
1.1.1.1002 1,595 3/9/2017
1.1.1.1000 1,589 2/1/2017
1.1.1.998 1,521 1/31/2017
1.1.1.996 1,659 12/15/2016
1.1.1.991 1,624 11/28/2016
1.1.1.989 2,413 9/22/2016
1.1.1.987 1,929 9/22/2016
1.1.1.986 1,987 9/22/2016
1.1.1.985 2,026 9/22/2016
1.1.1.982 1,692 8/24/2016
1.1.1.980 1,599 8/24/2016
1.1.1.979 1,574 8/22/2016
1.1.0.975 1,565 8/22/2016
1.1.0.973 1,590 8/22/2016
1.1.0.972 1,579 8/22/2016
1.1.0.971 1,588 8/18/2016
1.1.0.970 1,557 8/16/2016
1.1.0.967 1,528 8/15/2016
1.1.0.966 1,622 8/15/2016
1.1.0.964 1,635 8/11/2016
1.1.0.963 1,643 8/9/2016
1.1.0.961 1,576 8/9/2016
1.1.0.960 1,589 8/9/2016
1.1.0.959 1,599 8/8/2016
1.1.0.957 1,577 8/7/2016
1.1.0.956 1,582 8/7/2016
1.1.0.947-rc 1,333 8/6/2016
1.1.0.946-rc 1,379 8/5/2016
1.1.0.945 1,639 8/5/2016
1.1.0.942 1,828 7/27/2016
1.1.0.941 1,823 7/27/2016
1.1.0.939 1,674 7/27/2016
1.1.0.938 1,693 7/27/2016
1.1.0.936 1,943 7/26/2016
1.1.0.935 1,591 7/26/2016
1.1.0.932 1,670 7/25/2016
1.1.0.930 1,661 7/23/2016
1.1.0.929 1,650 7/23/2016
1.1.0.928 1,629 7/22/2016
1.1.0.927 1,625 7/22/2016
1.1.0.924 1,701 7/22/2016
1.1.0.923 1,647 7/21/2016
1.1.0.918 1,646 7/20/2016
1.1.0.915 1,619 7/20/2016
1.1.0.912 1,611 7/20/2016
1.1.0.910 1,585 7/20/2016
1.1.0.904 1,636 7/19/2016
1.1.0.903 1,563 7/18/2016
1.1.0.902 1,618 7/18/2016
1.1.0.901 1,667 7/18/2016
1.1.0.887 1,623 7/16/2016
1.1.0.886 1,668 7/16/2016
1.1.0.883 1,732 7/14/2016
1.1.0.879 1,776 7/13/2016
1.1.0.877 1,766 7/12/2016
1.1.0.864 1,632 7/9/2016
1.1.0.863 1,605 7/9/2016
1.1.0.859 1,590 7/8/2016
1.1.0.858 1,625 7/8/2016
1.1.0.857 1,659 7/6/2016
1.1.0.856 1,628 6/29/2016
1.1.0.855 1,624 6/28/2016
1.1.0.854 1,635 6/25/2016
1.0.1.851-rc 1,712 6/17/2016
1.0.1.849-rc 1,684 6/17/2016
1.0.1.842-rc 1,499 6/9/2016
1.0.1.841-rc 1,514 6/9/2016
1.0.1.839-rc 1,546 6/9/2016
1.0.1.837-rc 1,468 5/31/2016
1.0.1.835-rc 1,366 5/26/2016
1.0.1.834-rc 1,351 5/24/2016
1.0.1.833-rc 1,362 5/20/2016
1.0.1.832-rc 1,415 5/20/2016
1.0.1.828-rc 1,338 5/9/2016
1.0.1.827-rc 1,358 5/7/2016
1.0.1.826-rc 1,378 5/2/2016
1.0.1.824-rc 1,355 5/1/2016
1.0.1.823-rc 1,499 4/21/2016
1.0.1.822-rc 1,322 4/20/2016
1.0.1.821-rc 1,297 4/11/2016
1.0.1.819-rc 1,311 4/11/2016
1.0.1.818-rc 1,330 4/8/2016
1.0.1.817-rc 1,377 4/7/2016
1.0.1.813-rc 1,361 4/7/2016
1.0.1.812-rc 1,341 3/30/2016
1.0.1.811-rc 1,374 3/30/2016
1.0.1.810-rc 1,355 3/30/2016
1.0.1.808-rc 1,372 3/30/2016
1.0.1.807-rc 1,346 3/29/2016
1.0.1.806-rc 1,343 3/29/2016
1.0.1.805-rc 1,380 3/29/2016
1.0.1.796-rc 1,351 3/27/2016
1.0.1.793-rc 1,351 3/27/2016
1.0.1.788-rc 1,361 3/26/2016
1.0.1.785-rc 1,345 3/26/2016
1.0.1.778-rc 1,385 3/22/2016
1.0.1.777-rc 1,709 3/22/2016
1.0.1.776-rc 1,369 3/18/2016
1.0.1.775-rc 1,361 3/18/2016
1.0.1.774-rc 1,363 3/16/2016
1.0.1.773-rc 1,340 3/16/2016
1.0.1.771-rc 1,332 3/15/2016
1.0.1.769-rc 1,309 3/15/2016
1.0.1.765-rc 1,337 3/15/2016
1.0.1.764-rc 1,385 3/15/2016
1.0.1.759-rc 1,393 3/14/2016
1.0.1.758-rc 1,336 3/14/2016
1.0.1.757-rc 1,350 3/14/2016
1.0.1.752-rc 1,340 3/13/2016
1.0.1.748-rc 1,435 3/13/2016
1.0.1.747-rc 1,494 3/13/2016
1.0.1.746-rc 1,355 3/13/2016
1.0.1.743-rc 1,363 3/9/2016
1.0.1.742-rc 1,401 3/8/2016
1.0.1.741-rc 1,390 3/8/2016
1.0.1.740-rc 1,365 3/7/2016
1.0.1.736-rc 1,418 3/7/2016
1.0.1.735-rc 1,391 3/7/2016
1.0.1.729-rc 1,408 3/6/2016
1.0.1.728-rc 1,360 3/6/2016
1.0.1.726-rc 1,394 3/6/2016
1.0.1.724-rc 1,415 3/4/2016
1.0.1.723-rc 1,359 3/3/2016
1.0.1.722-rc 1,366 3/3/2016
1.0.1.721-rc 1,377 3/3/2016
1.0.1.719-rc 1,384 3/2/2016
1.0.1.717-rc 1,357 3/1/2016
1.0.1.716-rc 1,651 2/28/2016
1.0.1.711-rc 1,801 2/28/2016
1.0.1.709-rc 1,633 2/27/2016
1.0.1.708-rc 1,868 2/27/2016
1.0.1.707-rc 1,372 2/27/2016
1.0.1.706-rc 1,810 2/26/2016
1.0.1.705-rc 1,447 2/26/2016
1.0.1.701-rc 1,760 2/25/2016
1.0.1.699-rc 1,584 2/23/2016
1.0.1.696-rc 1,408 2/21/2016
1.0.1.693-rc 1,521 2/20/2016
1.0.1.691-rc 1,414 2/19/2016
1.0.1.689-rc 1,353 2/19/2016
1.0.1.684-rc 1,424 2/18/2016
1.0.1.683-rc 1,377 2/18/2016
1.0.1.676-rc 1,396 2/17/2016
1.0.1.673-rc 1,354 2/17/2016
1.0.1.670-rc 1,374 2/17/2016
1.0.1.665-rc 1,333 2/15/2016
1.0.1.663-rc 1,401 2/14/2016
1.0.1.659-rc 1,365 2/14/2016
1.0.1.657-rc 1,327 2/14/2016
1.0.1.654-rc 1,378 2/14/2016
1.0.1.648-rc 1,536 2/13/2016
1.0.1.647-rc 1,552 2/13/2016
1.0.1.632-rc 1,365 2/11/2016
1.0.1.631-rc 1,358 2/11/2016
1.0.1.626-rc 1,363 2/10/2016
1.0.1.625-rc 1,361 2/10/2016
1.0.1.609-rc 1,404 2/4/2016
1.0.1.605-rc 1,419 2/4/2016
1.0.1.604-rc 1,357 2/4/2016
1.0.1.600-rc 1,381 1/28/2016
1.0.1.597-rc 1,397 1/27/2016
1.0.1.596-rc 1,340 1/26/2016
1.0.1.595-rc 1,376 1/22/2016
1.0.1.593-rc 1,396 1/22/2016
1.0.1.590-rc 1,359 1/21/2016
1.0.1.588-rc 1,346 1/20/2016
1.0.1.583-rc 1,347 1/20/2016
1.0.1.582-rc 1,362 1/20/2016
1.0.1.574-rc 1,390 1/19/2016
1.0.1.571-rc 1,343 1/19/2016
1.0.1.570-rc 1,388 1/18/2016
1.0.1.569-rc 1,375 1/17/2016
1.0.1.568-rc 1,521 1/15/2016
1.0.1.565-rc 1,392 1/8/2016
1.0.1.564-rc 1,384 1/8/2016
1.0.1.561-rc 1,389 1/6/2016
1.0.1.557-rc 1,401 1/3/2016
1.0.1.554-rc 1,540 12/22/2015
1.0.1.553-rc 1,537 12/22/2015
1.0.1.552-rc 1,581 12/22/2015
1.0.1.551-rc 1,376 12/21/2015
1.0.1.550-rc 1,400 12/20/2015
1.0.1.545-rc 1,426 12/17/2015
1.0.1.543-rc 1,405 12/17/2015
1.0.1.542-rc 1,407 12/16/2015
1.0.1.539-rc 1,424 12/16/2015
1.0.1.525-rc 1,386 12/16/2015
1.0.1.521-rc 1,341 12/15/2015
1.0.1.512-rc 1,360 12/14/2015
1.0.1.508-rc 1,367 12/14/2015
1.0.1.505-rc 1,354 12/14/2015
1.0.0.492-rc 1,547 12/11/2015
1.0.0.491-rc 1,400 12/11/2015
1.0.0.488-rc 1,497 12/11/2015
1.0.0.487-rc 1,346 12/11/2015
1.0.0.485-rc 1,562 12/9/2015
1.0.0.481-rc 1,347 12/8/2015
1.0.0.479-rc 1,393 12/7/2015
1.0.0.473-rc 1,384 12/6/2015
1.0.0.472-rc 1,524 12/3/2015
1.0.0.469-rc 1,493 12/1/2015
1.0.0.465-rc 1,460 11/19/2015
1.0.0.464-rc 1,442 11/16/2015
1.0.0.458-rc 1,426 11/3/2015
1.0.0.448-rc 1,431 10/27/2015
1.0.0.447-rc 1,407 10/27/2015
1.0.0.446-rc 1,387 10/27/2015
1.0.0.443-rc 1,406 10/27/2015
1.0.0.441-rc 1,376 10/26/2015
1.0.0.436-rc 1,408 10/26/2015
1.0.0.434-rc 1,409 10/26/2015
1.0.0.433-rc 1,426 10/26/2015
0.9.1.426 2,263 10/8/2015
0.9.1.424 2,000 10/6/2015
0.9.1.418 1,789 9/29/2015
0.9.1.415 1,813 9/29/2015
0.9.1.411 1,804 9/28/2015
0.9.1.408 1,756 9/3/2015
0.9.1.407 1,774 8/18/2015
0.9.1.406 2,229 8/13/2015
0.9.1.405 1,697 8/13/2015
0.9.1.404 2,043 8/13/2015
0.9.1.401 2,013 7/21/2015
0.9.1.395 1,770 7/5/2015
0.9.1.394 1,711 7/4/2015
0.9.1.393 1,699 7/4/2015
0.9.1.390 1,725 6/13/2015
0.9.1.388 1,781 6/13/2015
0.9.1.386 1,676 6/13/2015
0.9.1.385 1,663 6/12/2015
0.9.1.382 1,654 6/12/2015
0.9.1.381 1,690 6/12/2015
0.9.1.380 1,657 6/12/2015
0.9.1.378 1,722 6/12/2015
0.9.1.375 1,785 2/27/2015
0.9.1.373 2,071 2/25/2015
0.9.1.370 2,031 2/25/2015
0.9.1.367 2,039 2/23/2015
0.9.1.365 1,984 2/21/2015
0.9.1.361 2,109 2/21/2015
0.9.1.358 2,011 2/16/2015
0.9.1.357 1,798 2/11/2015
0.9.0.355 1,906 2/10/2015
0.9.0.354 1,707 2/1/2015
0.9.0.353 1,740 1/30/2015
0.9.0.350 1,740 1/29/2015
0.9.0.338 1,691 1/12/2015
0.9.0.328 1,843 11/25/2014
0.9.0.326 1,834 11/24/2014
0.9.0.325 1,844 11/24/2014
0.9.0.323 1,888 11/23/2014
0.9.0.313 1,939 11/22/2014
0.9.0.299 1,906 11/12/2014
0.9.0.295 1,998 11/12/2014
0.9.0.290 1,902 11/11/2014
0.9.0.279 2,117 11/9/2014
0.9.0.269 2,035 11/6/2014
0.9.0.268 2,220 11/4/2014
0.9.0.266 2,495 11/3/2014
0.9.0.265 1,953 11/3/2014
0.9.0.263 2,243 11/3/2014
0.9.0.262 2,054 11/3/2014
0.9.0.249 1,796 10/27/2014
0.9.0.236 1,780 10/25/2014
0.9.0.234 1,796 10/24/2014
0.9.0.233 1,707 10/21/2014
0.9.0.227 1,706 10/21/2014
0.9.0.226 1,734 10/21/2014
0.9.0.225 1,767 10/21/2014
0.9.0.222 1,727 10/19/2014
0.9.0.221 1,714 10/19/2014
0.9.0.204 1,733 10/17/2014
0.9.0.200 1,661 10/15/2014
0.9.0.199 1,725 10/15/2014
0.9.0.193 1,709 10/14/2014
0.9.0.189 1,759 10/14/2014
0.9.0.184-test 1,488 10/14/2014
0.9.0.183-test 1,468 10/13/2014
0.9.0.179 1,788 10/13/2014
0.9.0.174 1,740 10/13/2014
0.6.0.173 1,734 10/13/2014
0.6.0.165 1,794 10/3/2014
0.6.0.160 1,732 9/18/2014
0.6.0.157 1,741 9/18/2014
0.6.0.155 1,767 9/18/2014
0.6.0.151 1,757 9/17/2014
0.6.0.147 1,766 9/16/2014
0.6.0.143 1,749 9/12/2014
0.6.0.141 1,777 9/10/2014
0.6.0.139 1,760 9/3/2014
0.6.0.135 1,710 8/21/2014
0.6.0.134 1,782 8/8/2014
0.6.0.130 1,797 8/4/2014
0.6.0.127 1,761 7/1/2014
0.6.0.101 1,881 1/21/2014
0.6.0.97 1,772 1/16/2014
0.5.0.51 1,826 1/5/2014
0.5.0.36 1,739 12/9/2013
0.5.0.35 1,927 12/8/2013
0.5.0.28 1,832 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