SQL

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 split the data model into multiple data contexts or put the entire model into a single context. This question is usually due to concerns about performance and/or difficulty of maintaining the model. The purpose of this

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: id rownum name 1234 1 Billy 8274 2 Carl 4352 3 Dave Notice that I cannot use the “id” column because it is auto-generated, and the data is not inserted into the table in the order