This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hello, I think I have found a bug. I was originally using 3.11, but I have tested a repro using the latest v4 nightly (20110928). from c in unitOfWork.Cats where c.Animal.ChipNumber.StartsWith("C") orderby c.Animal.Owner.LastName, c.Animal.Owner.FirstName select c; Result SELECT Cats.CatID AS "Cats.CatID", Error: Unknown column 'Owners0.FirstName' in 'order clause' I have attached a repro zip If you solve this, I'll upgrade to v4! Thanks, Scott |
|
|
Hi Scott, Indeed this does look to be a bug, we will have a look into a fix and Ill post an update once we have an update on this.
Thanks! Jeremy |
|
|
Thanks Jeremy, that's great. I'm having to convert an old MS Linq project to Lightspeed. Cheers, |
|
|
Hi Scott, We have added a fix for this and it will be available in tonights nightly build for you. Let us know how you get on and have a great weekend :)
Thanks! Jeremy |
|
|
Hello, Sorry it's taking so long to get back to you this issue. I have just moved over to NZ for a year - I am up in Auckland, and have been getting a house and broadband sorted. Anyway I tried the update and it has fixed the error in most cases but I am getting another one on a different query but of very similar in nature. I'd be greatful if you could take a look at it as I was hoping to have this project conversion wrapped up by now.
IOrderedQueryable<ModAssignment> assignmentsQuery = from a in UnitOfWork.ModAssignments where a.OrderToTrainId == ott.Id orderby a.ModTrainer.Trainer.Contact.DisplayName ascending , a.Status ascending , a.Commonwealth ascending , a.ModPupil.Contact.LastName ascending select a;
SELECT ModAssignments.ModAssignmentID AS "ModAssignments.ModAssignmentID", ModAssignments.BillingHours AS "ModAssignments.BillingHours", ModAssignments.Commonwealth AS "ModAssignments.Commonwealth", ModAssignments.End AS "ModAssignments.End", ModAssignments.Hours AS "ModAssignments.Hours", ModAssignments.LicenceCategoryId AS "ModAssignments.LicenceCategoryId", ModAssignments.Miles AS "ModAssignments.Miles", ModAssignments.ModPupilId AS "ModAssignments.ModPupilId", ModAssignments.ModTrainerId AS "ModAssignments.ModTrainerId", ModAssignments.OrderToTrainId AS "ModAssignments.OrderToTrainId", ModAssignments.Start AS "ModAssignments.Start", ModAssignments.Status AS "ModAssignments.Status" FROM ModAssignments LEFT OUTER JOIN ModTrainers ON ModAssignments.ModTrainerId = ModTrainers.ModTrainerID LEFT OUTER JOIN Trainers ON ModTrainers.TrainerId = Trainers.TrainerID LEFT OUTER JOIN Contacts ON Trainers.ContactId = Contacts.ContactID LEFT OUTER JOIN ModPupils ON ModAssignments.ModPupilId = ModPupils.ModPupilID WHERE ModAssignments.OrderToTrainId = '00000000-0000-4000-0000-000000000000' ORDER BY Contacts.DisplayName, ModAssignments.Status, ModAssignments.Commonwealth, Contacts0.LastName Unknown column 'Contacts0.LastName' in 'order clause'
I am going to be removing the complexity out of these queries, and am working to cleanup the system - but in the mean time I am having to migrate first then simplify - but these errors are speedbumps. Thanks again for your help.
|
|
|
Thanks Scott, Just an update to let you know we are currently looking into this second issue for you and I will post an update once we have made some progress on this. Hope to have an update for you soon.
Jeremy |
|
|
Hi Scott, I have put in a fix which should cover this second issue today and it will be available in the next nightly build for you. Let us know how you get on with this.
Thanks! Jeremy |
|