LINQ as you already know stands for "Lanugage Integrated Query" - but many people don't know that its pronunciation is "LINK" not "Link Cue"

Just in case, if you are living under the rock, LINQ to SQL is an O/RM (object relational mapping) implementation that ships in the .NET Framework 3.5 release, and which allows you to model a relational database using .NET classes.  You can then query the database using LINQ, as well as update/insert/delete data from it.

LINQ to SQL fully supports transactions, views, and stored procedures.  It also provides an easy way to integrate data validation and business logic rules into your data model.

Here is the simple query you can use to fetch column information from a given table:

SELECT
ORDINAL_POSITION
,COLUMN_NAME
,DATA_TYPE
,CHARACTER_MAXIMUM_LENGTH
,IS_NULLABLE
,COLUMN_DEFAULT
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'Product' -- place your table in question here in quotes
ORDER BY
ORDINAL_POSITION ASC;

Another more simpler option could be to use sp_help as follows:

sp_help 'Product' -- place your table in question here in quotes

A very nice trick with tab controls to asynchronously load their content in the background and improve perceived page load time.

Reducing Page Load Time with UpdatePanel and Timer

It's the office space everybody's talking about.....

Google Australia

Often times, a really cool looking bag draws the attention of the unsavory - those that may want to take that which is tantalizingly hidden within. It's the fact that the contents are invisible that makes the temptation so high! You might have a big wad of cash inside, or a stack of iPhones, a felt satchel of diamonds, or maybe a large gold brick!

Then again, maybe all you've got is a pack of gum, a ball of twine, a rubber-band, and a large caliber handgun. Sure, the potential risk is high on a mark like that, but the potential reward could be even higher!

We've got a solution - show the world exactly what you're carrying, even if what you're showing is only a reasonable facsimile. The X-Ray tote and shoulder bags, made of a space-age woven plastic fiber, appear to have been bombarded by X-rays, and have magically made your eyes sensitive to their reflection. It appears as though your stuff has gone through the security check at the airport (although, we highly recommend AGAINST carrying these through such a checkpoint as the NTSB, as a rule, has no sense of humor).

Show everyone your iPod, stack-o-benjamins, eye-drops, nail clippers, lollipop, sunglasses, and prescriptions as well as your pepper-spray, switchblade, brass knuckles and revolver. Maybe you've really got that stuff in your bag, but then again, maybe you don't! The indecision will make any potential thief pause in confusion long enough for you to be out of sight and long gone. Who knew personal security could be had through the power of suggestion?

Click here to buy

Sometimes, you might get an error "The time on your machine does not match with the network time". The basic issue here is that the time on the machine is not automatically synced with the time on the domain controller.

To resolve this problem, simply login as a local account and sync the time with the domain controller using the Net time command.

To do this, goto the command prompt and run the following:

NET TIME /domain:mydomainname /SET /Y

This will synchronize the machine time to that of the domain controller.