Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 5th, 2012  |  syntax: None  |  size: 0.67 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Cross database query, looping through databases
  2. foreach(var r in master.sysdatabases)
  3. {
  4. from b from r.chicken
  5. select b.age;
  6. }
  7.        
  8. var builder = new SqlConnectionStringBuilder (Connection.ConnectionString);
  9.  
  10. foreach (var db in sys.Databases)
  11. {
  12.    builder.InitialCatalog = db.Name;
  13.    var dc = new TypedDataContext (builder.ToString());
  14.    try
  15.    {
  16.       var query =
  17.          from b in dc.Chickens
  18.          select b.Age;
  19.  
  20.       query.Dump();
  21.    }
  22.    catch { ... }
  23. }
  24.        
  25. var r = (from b in Sysdatabases select b.Name).ToList();
  26. foreach(var i in r)
  27. {
  28. try{
  29.     var o = ExecuteQuery<string>("select urls from "+i+".dbo.website_setting");
  30.     Console.WriteLine(o);
  31. }
  32. catch(Exception){}
  33. }