Group items tagged

"Tired of querying in antiquated SQL? Well, you don't have to! LINQPad lets you interactively query databases in a modern query language: LINQ. Kiss goodbye to SQL Management Studio! LINQPad supports everything in C# 3.0 and Framework 3.5, and more: * LINQ to Objects * LINQ to SQL and Entity Framework * LINQ to XML * WCF Data Services & SQL Azure * LINQ to SQLite and MySQL Enterprise Server * Mindscape LightSpeed ORM * (Even old-fashioned SQL!)"

OpenJS Grid is the easiest jQuery Grid ever. With very little work you can have a data grid that can do everything from sorting and searching to complex database queries. Best of all, its open source. So you can learn how it's all done.

STEP1: select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid where d.name = 'YOURDBNAME' STEP 2: kill STEP 3: exec sp_dboption 'YOURDBNAME', 'single user', 'FALSE'

It's hard to find SQL Server 2008 Express files that are not R2 so here's the original DB

MySQL front-end

Details about web.config agents and passing in method parameters and defining class properties

I set AutoGenerated in the LINQ Designer to true which made use of my default values.

Use Batch Update of ADO.NET 2.0 DataAdapter Object

Forgot that connection string? Get it here!