asp.net mvc entity framework условия

           
 SQLiteConnection myConnection = new SQLiteConnection(Connect);
          myConnection.Open();

 if (chk0.Checked) { param1 = " AND fire = 0 "; }
else if (chk1.Checked) { param1 = " AND fire = 1 "; }
else {param1 = " "}
 
 if (chk3.Checked) { param2 = " AND str = 0 "; }
else if (chk4.Checked) { param2 = " AND str = 1 "; }
else {param2 = " "}
Connect = "SELECT * FROM item WHERE " + param1 + param2 ;

                if (vulnerability != -100 && raite == "-100")
                {
                    return from Name in northwind.name
                           where class_tip_list.Contains(Grp.class)  
                           select new { тут выборка };
                }
                else
                {
                    return from Name in northwind.name
                           where Grp.level >= slider_min
                           select new { тут выборка };
                }

var q = context.Items.AsQueryable();
 if (chk0.Checked) { q = q.Where(o =>  o.fire = 0); }
else if (chk1.Checked) { q = q.Where(o =>  o.fire = 1);; }
 
 if (chk3.Checked) { q = q.Where(o =>  o.str = 0); }
else if (chk4.Checked) { q = q.Where(o =>  o.str = 1); }
 
var l = q.ToList();

ObjectContext northwind2 = new ObjectContext("name=4lUtkeEntities");
northwind2.DefaultContainerName = "4lUtkeEntities";
 
string esqlQuery = "SELECT Grp._id, Grp._level, Name._name_en as _name, Name._title_en as _title FROM high_five_4lUtkeEntities._name as Name" +
                    " LEFT JOIN 4lUtkeEntities._grp as Grp ON Grp._id = Name._id" +
                    " LEFT JOIN 4lUtkeEntities._skilss as Skil ON Skil._id = Name._id" +
                    " WHERE Name._id =  319";
ObjectQuery<DbDataRecord> onlineOrders = new ObjectQuery<DbDataRecord>(esqlQuery, northwind2);
var tt = onlineOrders.ToList().ConvertTo<NmGpSk>().AsQueryable();
return tt;

 public static class AnonymousTypeConversion
{
 /// <summary>
 /// Converts a single DbDataRwcord object into something else.
 /// The destination type must have a default constructor.
 /// </summary>
 /// <typeparam name="T"></typeparam>
 /// <param name="record"></param>
 /// <returns></returns>
 public static T ConvertTo<T>(this DbDataRecord record)
 {
  T item = Activator.CreateInstance<T>();
  for (int f = 0; f < record.FieldCount; f++)
  {
   PropertyInfo p = item.GetType().GetProperty(record.GetName(f));
   if (p != null && p.PropertyType == record.GetFieldType(f))
   {
    p.SetValue(item, record.GetValue(f), null);
   }
  }
 
  return item;
 }
 
 /// <summary>
 /// Converts a list of DbDataRecord to a list of something else.
 /// </summary>
 /// <typeparam name="T"></typeparam>
 /// <param name="list"></param>
 /// <returns></returns>
 public static List<T> ConvertTo<T>(this List<DbDataRecord> list)
 {
  List<T> result = (List<T>)Activator.CreateInstance<List<T>>();
 
  list.ForEach(rec =>
  {
   result.Add(rec.ConvertTo<T>());
  });
 
  return result;
 }
}

namespace Informer.Models
{
    using System;
    using System.Collections.Generic;
 
    public partial class NmGpSk
    {
        public int _id { get; set; }
        public int _level { get; set; }
        public string _name { get; set; }
        public string _title { get; set; }
    }
}