具有多个/未知条件的动态linq查询

from t in Contacts 
where t.Email == \"email@domain.com\" || t.Email.Contains (\"mydomain\")
where t.Field1 == \"valuewewant\"
where t.Field2 != \"valuewedontwant\"
select t

List<FieldCriteria>

Email, Equals, \"email@domain.com\"
Email, Contains, \"mydomain\" Field1,
Equals, \"valuewewant\" Field2,
DoesNotEqual, \"valuewedontwant\"

new FieldCriteria
{
FieldName = \"Email\",
Operator = 1, 
Value = \"email@mydomain.com\"
}

enum Operator
{
    Equals = 1,
}

class Condition
{
    public string Field { get; set; }
    public Operator Operator { get; set;}
    public string Value { get; set;}
}

void Main()
{
    var conditions = new List<Condition>();

    conditions.Add(new Condition {
        Field = \"Email\",
        Operator = Operator.Equals,
        Value = \"email1@domain.com\"
    });

    conditions.Add(new Condition {
        Field = \"Email\",
        Operator = Operator.Equals,
        Value = \"email2@domain.com\"
    });

    conditions.Add(new Condition {
        Field = \"Field1\",
        Operator = Operator.Equals,
        Value = \"Chris\"
    });

    var statusConditions = \"Status = 1\";

    var emailConditions = from c in conditions where c.Field == \"Email\" select c;
    var field1Conditions = from c in conditions where c.Field == \"Field1\" select c;


    var emailConditionsFormatted = from c in emailConditions select string.Format(\"Email=\\\"{0}\\\"\", c.Value);
    var field1ConditionsFormatted = from c in field1Conditions select string.Format(\"Field1=\\\"{0}\\\"\", c.Value);

    string[] conditionsArray = emailConditionsFormatted.ToArray();
    var emailConditionsJoined = string.Join(\"||\", conditionsArray);
    Console.WriteLine(String.Format(\"Formatted Condition For Email: {0}\",emailConditionsJoined));

    conditionsArray = field1ConditionsFormatted.ToArray();
    var field1ConditionsJoined = string.Join(\"||\", conditionsArray);
    Console.WriteLine(String.Format(\"Formatted Condition For Field1: {0}\",field1ConditionsJoined));



    IQueryable results = ContactView.Where(statusConditions);

    if (emailConditions != null)
    {
        results = results.Where(emailConditionsJoined);
    }

    if (field1Conditions != null)
    {
        results = results.Where(field1ConditionsJoined);
    }

    results = results.Select(\"id\");

    foreach (int id in results)
    {
        Console.WriteLine(id.ToString());
    }
}

-- Region Parameters
DECLARE @p0 VarChar(1000) = \'Chris\'
DECLARE @p1 VarChar(1000) = \'email1@domain.com\'
DECLARE @p2 VarChar(1000) = \'email2@domain.com\'
DECLARE @p3 Int = 1
-- EndRegion
SELECT [t0].[id]
FROM [Contacts].[ContactView] AS [t0]
WHERE ([t0].[field1] = @p0) AND (([t0].[email] = @p1) OR ([t0].[email] = @p2)) AND ([t0].[status] = @p3)

Formatted Condition For Email: Email=\"email1@domain.com\"||Email=\"email2@domain.com\"
Formatted Condition For Field1: Field1=\"Chris\"