Problems joining table with same name

1

Hi,
i get naming problems when joining a many to many relation table with same name.

System.Data.SqlClient.SqlException: ‘The objects “LicenseItems” and “LicenseItems” in the FROM clause have the same exposed names. Use correlation names to distinguish them.’

      var licenseItems = 
                Db.Select(Db
                    .From<LicenseItem>()
                    .Join<LicenseTypeItem,LicenseItem>((li,lt) => lt.Id == li.LicenseItemsId && li.LicenseTypesId == licenseType.Id)
                ).ToList();
2

You can’t join on tables with the same name with the Typed API, you’d need to use a CustomJoin or JoinAlias, some examples below: