C#

Project    State         Title
  ABC      Resolved      Title1
  ABC      Pending       Title2
  DEF      Archived      Title3
  DEF      Resolved      Title4
  DEF      Committed     Title5
  DEF      Active        Title6

Project    Pending      Resolved       Committed     Active
  ABC         2            1              0            3
  DEF         1            3              1            15

private void button2_Click(object sender, EventArgs e)
{
    List<Item> objItems = new List<Item>();

    objItems.Add(new Item(1, "ABC", "Title1", "Resolved"));
    objItems.Add(new Item(2, "ABC", "Title2", "Pending"));
    objItems.Add(new Item(3, "DEF", "Title3", "Archived"));
    objItems.Add(new Item(4, "DEF", "Title4", "Resolved"));
    objItems.Add(new Item(5, "DEF", "Title5", "Committed"));
    objItems.Add(new Item(6, "DEF", "Title6", "Active"));
    objItems.Add(new Item(7, "ABC", "Title2", "Pending"));

    var data = objItems.Pivot(c => c.Project, c => c.State, lst => lst.Sum(c=> c.State)).ToList();
    dataGridView1.DataSource = data;  
}

public class Item
{
    public int Id { get; set; }
    public string Project { get; set; }
    public string Title { get; set; }
    public string State { get; set; }

    public Item(int id, string project, string title, string state)
    {
        this.Id = id;
        this.Project = project;
        this.Title = title;
        this.State = state;
    }
}

    public static class Extension
    {

        public static DataTable ToPivotTable<T, TColumn, TRow, TData>(
            this IEnumerable<T> source,
            Func<T, TColumn> columnSelector,
            Expression<Func<T, TRow>> rowSelector,
            Func<IEnumerable<T>, TData> dataSelector)
        {
            DataTable table = new DataTable();
            var rowName = ((MemberExpression)rowSelector.Body).Member.Name;
            table.Columns.Add(new DataColumn(rowName));
            var columns = source.Select(columnSelector).Distinct();

            foreach (var column in columns)
                table.Columns.Add(new DataColumn(column.ToString()));

            var rows = source.GroupBy(rowSelector.Compile())
                             .Select(rowGroup => new
                             {
                                 Key = rowGroup.Key,
                                 Values = columns.GroupJoin(
                                     rowGroup,
                                     c => c,
                                     r => columnSelector(r),
                                     (c, columnGroup) => dataSelector(columnGroup))
                             });

            foreach (var row in rows)
            {
                var dataRow = table.NewRow();
                var items = row.Values.Cast<object>().ToList();
                items.Insert(0, row.Key);
                dataRow.ItemArray = items.ToArray();
                table.Rows.Add(dataRow);
            }

            return table;
        }

    public static Dictionary<TKey1, Dictionary<TKey2, TValue>> Pivot<TSource, TKey1, TKey2, TValue>(
    this IEnumerable<TSource> source
    , Func<TSource, TKey1> key1Selector
    , Func<TSource, TKey2> key2Selector
    , Func<IEnumerable<TSource>, TValue> aggregate)
        {
            return source.GroupBy(key1Selector).Select(
                x => new
                {
                    X = x.Key,
                    Y = source.GroupBy(key2Selector).Select(
                        z => new
                        {
                            Z = z.Key,
                            V = aggregate(from item in source
                                          where key1Selector(item).Equals(x.Key)
                                          && key2Selector(item).Equals(z.Key)
                                          select item
                            )

                        }
                    ).ToDictionary(e => e.Z, o => o.V)
                }
            ).ToDictionary(e => e.X, o => o.Y);
        } 
    }

results = (from u in dc.Users
            select new UserEntity
            {
                .
                .
                .
                ModifiedDT = u.ModifiedDT.GetValueOrDefault()  //<==THROWS
            }).ToList();

results = (from u in dc.Users
            select new UserEntity
            {
                .
                .
                .
                ModifiedDT = u.ModifiedDT.HasValue ? u.ModifiedDT : null //<== WORKS
            }).ToList();

public T GetValueOrDefault(T defaultValue)
{
    return HasValue ? value : defaultValue;
}

private async void AddUser()
{
    UserEntity user = new UserEntity
    {
        FirstName = "Jack",
        LastName = "Stone",
        UserName = "jstone",
        Password = ""
    };

    await Task.Factory.StartNew(() =>
    {
        IBizObj bo = new BizObj(connString);
        bo.AddUser(user);

    }).ContinueWith(task =>
    {
        UserList.Add(user);
    });
}

public class BizObj : IBizObj
{
    IRepository _repoisitory;

<pre>
public BizObj(string connectionString)
{
    _repoisitory = new FalconRepository(connectionString);
}

public int AddUser(UserEntity entity)
{
    return _repoisitory.AddUser(entity);
}

public int AddUser(UserEntity entity)
{
    using (var dc = GetDataContext())
    {
        int results = 0;

        try
        {
            User user = new User
            {
                FirstName = entity.FirstName,
                LastName = entity.LastName,
                UserName = entity.UserName,
                Password = entity.Password,
                CanLogIn = entity.CanLogIn,
                PasswordChangeDate = entity.PasswordChangeDate,
                CreatedByUserId = 1,
                CreatedDT = DateTime.Now,
            };

            dc.Users.InsertOnSubmit(user);
            dc.SubmitChanges();

            results = user.Id;
        }
        catch (Exception e)
        {
             //<===================================== HANDLE EXCEPTION HERE
        }

        return results;
    }
}