Simple Linq question: How to create query with logic operators

Question

Just began to develop using LINQ, and still can't understand some simple things. So, LinqTable.SingleOrDefault(t=>(t.Field1=="value1")) is equal to SQL "SELECT * FROM LinqTable WHERE Field1="value1" LIMIT 1"

How to create (using Linq) the query like "SELECT * FROM LinqTable WHERE Field1="value1" AND Field2="value2" LIMIT 1?

Answer 1

SingleOrDefault(t=>(t.Field1=="value1" && t.Field2=="value2"))

Answer 2

Normally, you'd want to use Where to do this:

var result = LinqTable.Where(t => t.Field1 == "value1" && t.Field2 == "value2").SingleOrDefault();

You can do this directly in the SingleOrDefault line as well:

var result = LinqTable.SingleOrDefault(t => t.Field1 == "value1" && t.Field2 == "value2");

Answer 3

LinqTable.Where(row => row.Field1 == "value1" && row.Field2 == "value2").FirstOrDefault();