>Hi All, how do I create a relation ( using ADO ) using more than one field ( apart from concatenating them in the query )
In ADO.NET you can create "calculated" columns:
// The TestCalc column concatenates two existing columns, Code and Descriptionthis.oData.Columns.Add("TestCalc");
this.oData.Columns["TestCalc"].Expression = "iif(description is null, Code, Code + Description)";