SQL alias used in query but not defined

Good Day Mindscape team,

I am using the latest nightly build but this bug is still occurring.

Here is the sql generated by TRaceLogger.

SELECT Ticket.TicketNum AS [Ticket.TicketNum], Ticket.Alloy AS [Ticket.Alloy], Ticket.BlNum AS [Ticket.BlNum], Ticket.Bundles AS [Ticket.Bundles], Ticket.Checksum AS [Ticket.Checksum], Ticket.CrewNum AS [Ticket.CrewNum], Ticket.CrewSize AS [Ticket.CrewSize], Ticket.DtDue AS [Ticket.DtDue], Ticket.DtPack AS [Ticket.DtPack], Ticket.DtRemoved AS [Ticket.DtRemoved], Ticket.DtScanned AS [Ticket.DtScanned], Ticket.Gross AS [Ticket.Gross], Ticket.HoldStockFlag AS [Ticket.HoldStockFlag], Ticket.Hr AS [Ticket.Hr], Ticket.InvenPc AS [Ticket.InvenPc], Ticket.InvenScannedBy AS [Ticket.InvenScannedBy], Ticket.InvenScannedDt AS [Ticket.InvenScannedDt], Ticket.InvenWt AS [Ticket.InvenWt], Ticket.Len AS [Ticket.Len], Ticket.LenUnit AS [Ticket.LenUnit], Ticket.LockTime AS [Ticket.LockTime], Ticket.LockUser AS [Ticket.LockUser], Ticket.Lot AS [Ticket.Lot], Ticket.LotNum AS [Ticket.LotNum], Ticket.Manifest AS [Ticket.Manifest], Ticket.Master AS [Ticket.Master], Ticket.NextDeptNum AS [Ticket.NextDeptNum], Ticket.OrigCustNum AS [Ticket.OrigCustNum], Ticket.OrigLot AS [Ticket.OrigLot], Ticket.OrigPart AS [Ticket.OrigPart], Ticket.OrigPartCustNum AS [Ticket.OrigPartCustNum], Ticket.OrigPo AS [Ticket.OrigPo], Ticket.OrigSoItemNum AS [Ticket.OrigSoItemNum], Ticket.OrigSoNum AS [Ticket.OrigSoNum], Ticket.OrigTicketNum AS [Ticket.OrigTicketNum], Ticket.PackType AS [Ticket.PackType], Ticket.PackedStockFlag AS [Ticket.PackedStockFlag], Ticket.PackerId AS [Ticket.PackerId], Ticket.Part AS [Ticket.Part], Ticket.Pc AS [Ticket.Pc], Ticket.PctPostConsumer AS [Ticket.PctPostConsumer], Ticket.PctPreConsumer AS [Ticket.PctPreConsumer], Ticket.PctRecycled AS [Ticket.PctRecycled], Ticket.PickListNum AS [Ticket.PickListNum], Ticket.Plant AS [Ticket.Plant], Ticket.Po AS [Ticket.Po], Ticket.PrevDeptNum AS [Ticket.PrevDeptNum], Ticket.ReceivedBy AS [Ticket.ReceivedBy], Ticket.RowId AS [Ticket.RowId], Ticket.ScannerId AS [Ticket.ScannerId], Ticket.Shift AS [Ticket.Shift], Ticket.SoItemNum AS [Ticket.SoItemNum], Ticket.SoNum AS [Ticket.SoNum], Ticket.StartTime AS [Ticket.StartTime], Ticket.Status AS [Ticket.Status], Ticket.StockNote AS [Ticket.StockNote], Ticket.StockNum AS [Ticket.StockNum], Ticket.StopTime AS [Ticket.StopTime], Ticket.Tare AS [Ticket.Tare], Ticket.Temper AS [Ticket.Temper], Ticket.TruckId AS [Ticket.TruckId], Ticket.UnroundedGross AS [Ticket.UnroundedGross], Ticket.UnroundedTare AS [Ticket.UnroundedTare], Ticket.UserAlpha1 AS [Ticket.UserAlpha1], Ticket.UserAlpha10 AS [Ticket.UserAlpha10], Ticket.UserAlpha11 AS [Ticket.UserAlpha11], Ticket.UserAlpha12 AS [Ticket.UserAlpha12], Ticket.UserAlpha13 AS [Ticket.UserAlpha13], Ticket.UserAlpha14 AS [Ticket.UserAlpha14], Ticket.UserAlpha15 AS [Ticket.UserAlpha15], Ticket.UserAlpha16 AS [Ticket.UserAlpha16], Ticket.UserAlpha17 AS [Ticket.UserAlpha17], Ticket.UserAlpha18 AS [Ticket.UserAlpha18], Ticket.UserAlpha19 AS [Ticket.UserAlpha19], Ticket.UserAlpha2 AS [Ticket.UserAlpha2], Ticket.UserAlpha20 AS [Ticket.UserAlpha20], Ticket.UserAlpha3 AS [Ticket.UserAlpha3], Ticket.UserAlpha4 AS [Ticket.UserAlpha4], Ticket.UserAlpha5 AS [Ticket.UserAlpha5], Ticket.UserAlpha6 AS [Ticket.UserAlpha6], Ticket.UserAlpha7 AS [Ticket.UserAlpha7], Ticket.UserAlpha8 AS [Ticket.UserAlpha8], Ticket.UserAlpha9 AS [Ticket.UserAlpha9], Ticket.UserDate1 AS [Ticket.UserDate1], Ticket.UserDate10 AS [Ticket.UserDate10], Ticket.UserDate2 AS [Ticket.UserDate2], Ticket.UserDate3 AS [Ticket.UserDate3], Ticket.UserDate4 AS [Ticket.UserDate4], Ticket.UserDate5 AS [Ticket.UserDate5], Ticket.UserDate6 AS [Ticket.UserDate6], Ticket.UserDate7 AS [Ticket.UserDate7], Ticket.UserDate8 AS [Ticket.UserDate8], Ticket.UserDate9 AS [Ticket.UserDate9], Ticket.UserDecimal1 AS [Ticket.UserDecimal1], Ticket.UserDecimal10 AS [Ticket.UserDecimal10], Ticket.UserDecimal2 AS [Ticket.UserDecimal2], Ticket.UserDecimal3 AS [Ticket.UserDecimal3], Ticket.UserDecimal4 AS [Ticket.UserDecimal4], Ticket.UserDecimal5 AS [Ticket.UserDecimal5], Ticket.UserDecimal6 AS [Ticket.UserDecimal6], Ticket.UserDecimal7 AS [Ticket.UserDecimal7], Ticket.UserDecimal8 AS [Ticket.UserDecimal8], Ticket.UserDecimal9 AS [Ticket.UserDecimal9], Ticket.UserFlag1 AS [Ticket.UserFlag1], Ticket.UserFlag10 AS [Ticket.UserFlag10], Ticket.UserFlag2 AS [Ticket.UserFlag2], Ticket.UserFlag3 AS [Ticket.UserFlag3], Ticket.UserFlag4 AS [Ticket.UserFlag4], Ticket.UserFlag5 AS [Ticket.UserFlag5], Ticket.UserFlag6 AS [Ticket.UserFlag6], Ticket.UserFlag7 AS [Ticket.UserFlag7], Ticket.UserFlag8 AS [Ticket.UserFlag8], Ticket.UserFlag9 AS [Ticket.UserFlag9], Ticket.UserNote1 AS [Ticket.UserNote1], Ticket.UserNote2 AS [Ticket.UserNote2], Ticket.UserNote3 AS [Ticket.UserNote3], Ticket.UserNote4 AS [Ticket.UserNote4], Ticket.UserNote5 AS [Ticket.UserNote5], Ticket.UserNumeric1 AS [Ticket.UserNumeric1], Ticket.UserNumeric10 AS [Ticket.UserNumeric10], Ticket.UserNumeric2 AS [Ticket.UserNumeric2], Ticket.UserNumeric3 AS [Ticket.UserNumeric3], Ticket.UserNumeric4 AS [Ticket.UserNumeric4], Ticket.UserNumeric5 AS [Ticket.UserNumeric5], Ticket.UserNumeric6 AS [Ticket.UserNumeric6], Ticket.UserNumeric7 AS [Ticket.UserNumeric7], Ticket.UserNumeric8 AS [Ticket.UserNumeric8], Ticket.UserNumeric9 AS [Ticket.UserNumeric9], Ticket.VendCustNum AS [Ticket.VendCustNum] FROM foy.Ticket WHERE Ticket.TicketNum = 996815

Notice there is not "Ticket" alias defined for the table in the FROM clause, so I get a SQL Exception.

Here is my unitofwork:

public Ticket GetFoyTicket(int Id) { Ticket ticket;

        using (var uow = _Context.Session)
        {
            ticket = uow.FindById<Ticket>(Id);
        }

        return ticket;
    }

Can you please help me work around this?

Thank you,

Albert

Thanks for reporting this - this looks to be a bug. I have added in a candidate fix which will be available in the next nightly build for you. Let us know if you continue to have problems after installing the nightly build.

Jeremy