Hi,
I got the solution as bellow
public List<T> getRecored_ByQry<T>(string queryString, string strentityName)
{
List<T> lst = new List<T>();
string dbconName = strentityName;
if (std_con.DefaultContainerName.ToString() == strentityName)
{
//queryString = "SELECT VALUE c FROM " + dbconName + "." + tblName + " as c";
ObjectQuery<T> contactQuery = std_con.CreateQuery<T>(queryString);
lst = contactQuery.ToList();
std_con.Refresh(System.Data.Objects.RefreshMode.StoreWins, contactQuery);
}
return lst;
}
call it from code
List<tbl_Project> nlst = new List<tbl_Project>();
selectQry = "SELECT VALUE User " +
" FROM Projects_Entities.tbl_Project " +
" AS User WHERE User.str_S_Code ='" + txtProjectCode.Text + "'";
nlst = getRecored_ByQry<tbl_Project>(selectQry, "Projects_Entities");