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





Tuesday, October 26, 2010

Thursday, August 12, 2010

Indian Students invent the 'iPad Killer'!

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

Wednesday, August 11, 2010

New concept mobile phone

This new Window Phone is the concept mobile phone, which is able to transform its appearance like a window as per the weather. The phone is designed as a thin, clear and transparent plastic sheet, which remains clear during a sunny day, becomes humid during a rainy day and takes a dump outlook during a snowy day.
read more...

Friday, August 6, 2010

Failed to load viewstate.

ViewState and Dynamic Control

The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request.  For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.