Always remain updated about current software development trends

Articles by DAVE C ANDREWS

How to Join Multiple Columns with Linq To SQL

By Dave C Andrews

Today I had to create a Linq-To-SQL query which joined two tables. These tables had compound primary keys (table simplified for example): Table Referrers ServerID (PK) ReferrerID (PK) Value 1 1 My value 1 1 2 My value 2 1 3 My value 3 Table ReferrerInfo ServerID...

Conditional Sums in SQL Aggregate Methods

By Dave C Andrews

Count the records in a table which are of a certain type.

How to Use Computed or Calculated Columns

By Dave C Andrews

You can have your tables make computations themselves, without running through a view.

  • Page 1 of 1
  •