Tag: Development

Community

Using LINQ in ASP.NET (Part 2)

(Bipin Joshi) In the Part 1 of this series I discussed the basic operations of LINQ to SQL. By default when you use LINQ to SQL queries as shown earlier, they internally use SQL statements i.e. INSERT, UPDATE, DELETE and SELECT. In many real world applications you use stored procedures. Luckily, LIN

Community

History Tables

(Kenneth Downs) A history table allows you to use one table to track changes in another table. While the basic idea is simple, a naive implementation will lead to bloat and will be difficult to query. A more sophisticated approach allows easier queries and can produce not just information about sing