LINQ to SQL: Single Data Context or Multiple Data Contexts?
One of the biggest questions that often arises when a LINQ to SQL newbie begins to think about how he/she is going to architect the data layer is whether to…
SQL
SQL snippets and guidance for database development. Covers key topics like choosing between single and multiple LINQ to SQL data contexts for your data layer architecture, and simulating Oracle-style rownum functionality in MySQL queries.
Rownum Simulation with MySQL
I recently had the need to SELECT some data from MySQL tables and include a “rownum” column on each row. For example, I needed some results that looked like this:…