
Untitled
By: a guest on
Aug 5th, 2012 | syntax:
None | size: 0.67 KB | hits: 12 | expires: Never
Cross database query, looping through databases
foreach(var r in master.sysdatabases)
{
from b from r.chicken
select b.age;
}
var builder = new SqlConnectionStringBuilder (Connection.ConnectionString);
foreach (var db in sys.Databases)
{
builder.InitialCatalog = db.Name;
var dc = new TypedDataContext (builder.ToString());
try
{
var query =
from b in dc.Chickens
select b.Age;
query.Dump();
}
catch { ... }
}
var r = (from b in Sysdatabases select b.Name).ToList();
foreach(var i in r)
{
try{
var o = ExecuteQuery<string>("select urls from "+i+".dbo.website_setting");
Console.WriteLine(o);
}
catch(Exception){}
}