Not equal condition in Linq Query using C# in ASP.Net

nagaraju60 says:

where ExistData.Frmt_Id == Name && ExistData.Status != 'E'

 Change the above with the below code.

where ExistData.Frmt_Id == Name && ExistData.Status != "E"

Like below.

public string ExistOrNot(string Fruit, string Chkvalue)
{
    using (TestEntities dc = new TestEntities())
    {
        var Existvalue = (from ExistData in dc.Table1.AsEnumerable()
                            where ExistData.Name == Fruit && ExistData.Status != "E"
                            select ExistData.Name).FirstOrDefault();

        if (Existvalue != null)
        {
            return "1";
        }
        else
        {
            return "2";
        }
    }
}

Dear @dharmendr,

Thanks for your reply,

i did mistake while writing query in my code. actually the above code is working for me. your code is working while the status datatype is nvarchar. thanks for our team support..

       public string ExistOrNot(string Fruit,string Chkvalue)
       {
           using (DataContext dc = new DataContext())
           {
               var Existvalue = (from ExistData in dc.Table1.AsEnumerable()
                                where ExistData.Frmt_Id == Name && ExistData.Status != 'E'
                                select ExistData.Name.ToString()).FirstOrDefault();
 
               if (Existvalue != null)
               {
                   return Chkvalue = "1";
               }
           }
 
           return Chkvalue = "2";
       }