The History of Programming Languages [Infographic]

The History of Programming Languages [Infographic]

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 Spyridon Spyriadis' blog as seen here

---
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...

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...

Microsoft PDC10

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

‘Adam’ the ‘iPad Killer!’ – a new gizmo from Indian students

As everybody knows Apple has newly launched a new magical and revolutionary device called “iPad”, as everybody knows it has got some good features and a new way of experiencing with the web, emails, photos, videos and what not! you can access so many online apps using this device and with only $499. By looking at Apple’s Invention, Indian Students came up a cool and new gizmo named “Adam” which has got more features than “iPad”.
read more