//TODO: Replace this with MEF so Core doesn't need to know about the providers
 public static ISPLoader GetInstance(ConnectionInfo connection)
 {
     switch(connection.ConnectionType.ToLowerInvariant())
     {
         case "sqlserver": return new SqlServer.SPLoader(connection.ConnectionString);
         default: throw new NotImplementedException();
     }
 }
 public StoredProcGroupVM(string connectionString)
 {
     _cnn = new ConnectionInfo { DisplayName = "Default", ConnectionType = "sqlserver", ConnectionString = connectionString };
     Load();
 }
 public StoredProcGroupVM()
 {
     var cstr = @"Data Source=.\dev;Initial Catalog=NORTHWND;Integrated Security=True";
     _cnn = new ConnectionInfo{DisplayName="Default", ConnectionType = "sqlserver", ConnectionString=cstr};
     Load();
 }