Last post Feb 05, 2018 02:57 AM by Edward Z
Feb 03, 2018 04:16 PM|kodnil|LINK
I am using WCF data service to get data from sql database. I have written one query which takes longer time to execute. i want to improve this expression to get only the columns i need. I could get column from Table1 but not able to find column from Table2
in example below. Appreciate if anyone could help me with this.
var list = DataContext.Table1.Expand("Table2").Where(T => T.Name = "Test").ToList();
on the similar lines i have one expression which goes like:
var list = DataContext.Table1.Expand("Table2/Table3").Where(T => T.Name = "Test").ToList();
how to get specific columns from 3 tables. alternatively please suggest how can i reduce the response time.
Feb 05, 2018 02:57 AM|Edward Z|LINK
Cross-Platform post, please check the suggestion on below forum.