تبدیل string به کد

[itloveh]

با سلام،دوستان به دلایلی باید از در قسمت where از string استفاده کنم اما چطور تو قسمت where این رشته رو تبدیل به کد کنم با " " که خطا می دهد

String query = "p.noahMelk =='آپارتمان' && p.noeMameleh == noehMamelhF " ;
var q = from p in db.mains
where "query"
select new { p.noahMelk, p.modir, p.idmain, p.idUser, p.metrajekol, p.noeMameleh };
GridView1.DataSource = q;
GridView1.DataBind();

[aroshanzamir]

سلام دوست من :


var q = from p in db.mains
where p.noahMelk == "آپارتمان" && p.noeMameleh == "noehMamelhF"
select new { p.noahMelk, p.modir, p.idmain, p.idUser, p.metrajekol, p.noeMameleh };
GridView1.DataSource = q;
GridView1.DataBind();

[itloveh]

نه دوست عزیز من که گفتم به دلایلی نمی شه به این شکل استفاده کنم باید همون query که به صورت رشته است را بنویسم که اجرا کنه
چون به شرایطی یه چیزایی هم به رشته query اضافه می شود

[aroshanzamir]

public class Student
{
public int Id { get; set; }
public string Name { get; set; }
public string Family { get; set; }
}
public class Employee
{
public int Id { get; set; }
public string Name { get; set; }
public string Address { get; set; }
public string Family { get; set; }
public string Phone { get; set; }
}
public class Clerk
{
public int Id { get; set; }
public string Name { get; set; }
public string Family { get; set; }
}


public class Result
{
public int Id { get; set; }
public string Name { get; set; }
}






class Program
{
static void Main(string[] args)
{


List<Student> LstStudent = new List<Student>()
{
new Student(){ Id=1, Name="Reza", Family="Madadian" },
new Student(){Id=2, Name="Milad", Family="Mohseni"},
new Student(){ Id=3, Name="Mitra", Family="Mohammadi"}
};


List<Employee> LstEmployee = new List<Employee>()
{
new Employee(){ Id=1, Name="Zahra" , Family="Miladi", Address="Shiraz. Pasargad", Phone="0917111111"},
new Employee(){ Id=2, Name="Reza" , Family="Javadi", Address="Shiraz. Pasdaran", Phone="0917333333"},
new Employee(){ Id=3, Name="Goli" , Family="Ghasemi", Address="Shiraz. Modaras", Phone="0917222222"}
};




List<Clerk> LstClrk = new List<Clerk>()
{
new Clerk(){ Id=1, Name="Abolfazl", Family="Sarhangi"},
new Clerk(){ Id=1, Name="Sajad", Family="Kohan"},
new Clerk(){ Id=1, Name="Amir", Family="Nourozi"}
};




string word="Reza";




List<Result> LstResult = ((from student in LstStudent.Where(x => x.Name.Contains(word)) select new Result { Id = student.Id, Name = student.Name }).
Concat(from employee in LstEmployee.Where(x => x.Name.Contains(word)) select new Result { Id = employee.Id, Name = employee.Name })).
Concat(from clerk in LstClrk.Where(x => x.Name.Contains(word)) select new Result { Id = clerk.Id, Name = clerk.Name }).ToList();




foreach (var item in LstResult)
{
Console.WriteLine(string.Format("Id :{0} / Name : {1}",item.Id,item.Name.ToString()));
}








}
}