Where() question

Hello,

I have a query that has an problem with the "Where()"

               qry = new Select(columns)

                    .From(FormField.Schema)

                    .InnerJoin(TaskForm.Schema)

                    .LeftOuterJoin(TaskFormValue.Schema)

                    .Where(TaskForm.Columns.TaskFormId).IsEqualTo(sectionFormId.ToString())

                    .OrderAsc(FormField.Columns.FieldOrder);

The column "TaskFormId" is in both "TaskForm" & "TaskFormValue" tables. The problem is that when the sql hits the server the column "TaskForm.Columns.TaskFormId" is chopped down to just "TaskFormId" and throws an "Ambiguous column name" error.

So how to I get it to pass "TaskForm.TaskFormId" to the sql server?

Try this

.Where(TaskForm.TaskFormIdColumn).IsEqualTo(sectionFormId.ToString())

Brilliant! That worked perfectly.