Partial Classes, Interfaces & Generics

Partial classes can be used to split definitions of classes, structs or interfaces over two or more source files. Each source file contains a section of the class definition which are combined at when the application is compiled. Partial classes can be beneficial in the following situations: Working on large projects, allowing developers to work on different sections of a class without both having to access the same physical...

Read rest of entry

C# System Types

The type system in .NET or Common Type System (CTS) divides types into 2 categories: Values Types Reference Types Value Types These are simple data types that directly contain their data, for example:Integers Floats Enums Structs Reference Types These types store references to objects.  Reference type variables have the ability to refer to the same data, so two variables can point to same object and the object be manipulated...

Read rest of entry

SQL: Format Dates

Formatting dates in T-SQL is generally a nuisance as no format date function exists. In the past I have seen many developers (including myself) use the DATEPART() functions to split the dates and then manually build up a date string. Alternatively I have seen developers CAST() the date to format. Recently however, I discovered the different...

Read rest of entry

SQL: Get the length of text, ntext & image

Ever needed to find the lengh of a ntext field in SQL only to be met with the following error message, whilst using the LEN() function? This can be achieved by simply using the DATALENGHT() function.  DATALENGTH is especially useful with varchar, varbinary, text, image, nvarchar, and ntext data...

Read rest of entry

Getting Started with LINQ to Entities

Introducing the object context, basics queries, eager loading, lazy loading and projection.In this video, Julie Lerman will show you how to query your database with LINQ to Entities queries against an Entity Data Model. This video uses Entity Framework 4.0 and Visual Studio 2010. Presented by Julie Lerman. Context object var context = new myModel.MyEntities Basic query var query = from c in context.Customers select...

Read rest of entry

Creating an Entity Data Model from a Database

The entity framework is an object-relational mapping (ORM) framework for the .NET Framework. The entity framework separates the conceptual and logical data models, allowing developers to program against the conceptual model rather than the logical model. This video walks you through the basics of creating an entity data model from an existing database using Entity Framework 4.0 and Visual Studio 2010. You’ll learn to run the...

Read rest of entry

JSON - An Express Overview

Whilst building a new reporting engine this week I was advised by a friend to consider using JSON as a simple and effective way to store the business rules. Having not used JSON before, I decided to take a quick look and found it to be a very straightforward yet elegant way of storing data. What is JSON? JSON (JavaScript Object Notation) is a neat and structured text-based data format that is an accepted alternative to XML. ...

Read rest of entry