Hello,

I am just getting my feet wet in EntitySpaces.  I am trying to bind a join query to a asp.net gridview and keep getting the message "field not found".  I know that it has something to do with having the same field name "description" in the joined tables.  I can bind other fields in the joins but when I included the two "description" fields from two joined tables I get the message "Field not found in data source".  I have tried alias and combination of things from the forum but not able to come up with anything.

 I am using SQL2005 and Visual Studio 2008.

 This is this exact error message that is returned per my code snippet below.

 "A field or property with the name 'Description1' was not found on the selected data source."

GoalQuery qGoal = new GoalQuery("g");

InterventionTypeQuery qIntType = new InterventionTypeQuery("it");

GoalAreaQuery qGoalArea = new GoalAreaQuery("ga");

UserQuery qUser = new UserQuery("u");

qGoal.Description.Coalesce("g.Description"),

qIntType.Description.Coalesce("it.Description")

GoalCollection Coll = new GoalCollection();

Try this on one of them:

qIntType.Description.Coalesce("it.Description").As("MyDescription");

Let us know if this works ...

I still get:

A field or property with the name 'MyDescription' was not found on the selected data source.

Darrinb:

I still get:

A field or property with the name 'MyDescription' was not found on the selected data source.

Can you provide the create statements for those tables and the sql for that query?

Does that query run from SQL Management Studio? I had this problem before when I forgot to update a query after editing a table.

While debugging in Visual Studio when you drill down into your collections datatable in a quick watch window do you see a column named 'MyDescription'? If you do try binding like so to your gridview

MyGridView.DataSource = myCollection.LowLevelBind();

The lowlevelbind did the trick!  What exactly does/is lowlevelbind do? 

Thanks Scott!

Mike,

I removed the LowLevelBind, removed the existing reference to "EntitySpaces.Core.dll" and made a reference to the "EntitySpaces.Core.Dll" under the Web folder.  The results.....my binding worked just fine.  Thanks!