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…

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…

Get useful blogging, marketing and learning resources, delivered to your mailbox. Plus, get regularly updated with extra tools & guides to help you learn, grow and earn better.

Get 10 exclusive e-books & templates for free, to begin with. 🎁