public RancherController()
{
string connectionString = "Server=tcp:lasmargaritas.database.windows.net,1433;Initial Catalog=LasMargaritasDBDev;Persist Security Info=False;User ID=LasMargaritasDbUser;Password=LasMargaritasPassw0rd!;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
if (ConfigurationManager.ConnectionStrings["LasMargaritasDb"] != null)
{
connectionString = ConfigurationManager.ConnectionStrings["LasMargaritasDb"].ConnectionString;
}
rancherBL = new RancherBL(connectionString);
}
private static void MigrateRanchers()
{
List <string> exceptions = new List <string>();
List <Rancher> ranchers = RancherOld.GetRanchers();
RancherBL rancherBL = new RancherBL(connectionString);
foreach (Rancher rancher in ranchers)
{
try
{
rancherBL.InsertRancher(rancher);
}
catch (Exception ex)
{
exceptions.Add(rancher.Name + ". Error " + ex.Message);
}
}
foreach (string ex in exceptions)
{
Console.WriteLine(ex);
}
Console.ReadLine();
}
