Wednesday, February 8, 2012

A Simple tic tac toe game with QUnit, JQuery and a pure javascript engine

Check out my friend and colleague Gideon's work
A Simple tic tac toe game with QUnit, JQuery and a pure javascript engine

Wednesday, July 27, 2011

Getting SQL Server Date/Time usng LINQ to SQL

If you want to get the current date/time from your SQL Server (possibly to avoid different times between your server and the clients) using LINQ to SQL, you will find that there is no straight forward way of doing this.

Having had some trouble trying to accomplish this, I thought that it might be worth sharing how it can be done.
Note that this is extracted from

---
Using LINQ to SQL there is no way to get the time from the database built in the class. What you need to do is write your own code as the example below:


using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Data;
using System.Collections.Generic;
using System.Reflection;
using System.Linq;
using System.Linq.Expressions;
using System.ComponentModel;
using System;
 
partial class dbGTOnlineDataContext
{
    [Function(Name = "GetDate", IsComposable = true)]
    public DateTime GetSystemDate()
    {
        MethodInfo mi = MethodBase.GetCurrentMethod() as MethodInfo;
        return (DateTime)this.ExecuteMethodCall(this, mi, new object[] { }).ReturnValue;
    }
}


Then anywhere in your code you can simple use the code below to get the time from the SQL Server database:


myDatabaseDataContext db = new myDatabaseDataContext();
DateTime dtNow = db.GetSystemDate();


Hope this helps...

Friday, February 4, 2011

Duet Enterprise Workflow SharePoint Extension

This is a follow up blog on a SAP blog about how to develop a custom workflow solution on the backend. This blog is to explain how workflow works on the SharePoint side and offer some customization entry points for you to create extended solutions leverage SAP backend process and SharePoint workflow and flexible UI options.

Read the full article...

Tuesday, October 26, 2010

Microsoft PDC10

I am attending...
Microsoft PDC10
How about you?