<div>
<pre><code id="code-20-40441969-1">Invoice invoice = db.Invoices.Where(s =&gt; s.InvoiceNumber == findInvoiceNumber).OrderBy(s =&gt; s.InvoiceNumber).First();</code></pre>
<br />
You would need to put some sort of order by in, otherwise you would not reliably get the record you are expecting depending on how the SQL execution plan changes (unless invoicenumber is unique). &nbsp;The ToList() is not needed, since Invoices is already a collection.
</div>


Invoice invoice = db.Invoices.Where(s => s.InvoiceNumber == findInvoiceNumber).OrderBy(s => s.InvoiceNumber).First();


You would need to put some sort of order by in, otherwise you would not reliably get the record you are expecting depending on how the SQL execution plan changes (unless invoicenumber is unique).  The ToList() is not needed, since Invoices is already a collection.

<div>
What's wrong with what you have? Really, only the <i>ToList</i> could be taken out (or maybe moved to the end).
</div>


What's wrong with what you have? Really, only the ToList could be taken out (or maybe moved to the end).

<div>
<div class="content wysiwyg-content">
How would I write this query in Linq to sql<br />
<br />

<pre><code id="code-10-28561847-1">Invoice IVN = eo.Invoices.ToList().Where(x =&gt; x.InvoiceNumber == s).First();</code></pre>
</div>
</div>


How would I write this query in Linq to sql

(CODE)

How would I write the following query in Linq?

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although ports exist for Java, PHP, JavaScript and ActionScript. LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources.

LINQ Query

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.