static void Main(string[] args)
{
//Add an interceptor to force a fake db connection issue
//so we can see the connection retry at work. This intercepts
//ReaderExecuting to force the exception.
DbInterception.Add(new InterceptorForceTransientErrors());
//Add an interceptor to log our details so we can log
//out the details each step of the way
DbInterception.Add(new InterceptorForLogging());
using (var context = new MusicContext())
{
Console.WriteLine("Adding album");
context.Albums.Add(new Album()
{
Title = "My Album",
Price = 9.99m
});
context.SaveChanges();
Console.WriteLine("Attempting query (Interceptor will now fake a connection error to trigger retry)");
//To force our exception, one of our parameters needs to have
//the word Throw. Thats how our connection interceptor knows to fake an error
try
{
var count = context.Albums.Where(o => o.Title.Contains("FakeAnError")).Count();
}
catch (RetryLimitExceededException)
{
Console.WriteLine("Caught RetryLimitExceededException, connection retry worked.");
Console.WriteLine("Press enter to continue...");
Console.ReadLine();
return;
}
//Shouldn't get here :)
foreach (var album in context.Albums.ToList())
{
Console.WriteLine(
string.Format("Id:{0}\nTitle:{1}\nPrice:{2}\n\n",
album.AlbumId, album.Title, album.Price));
}
}
Console.WriteLine("Press enter to continue...");
Console.ReadLine();
}
static void Main(string[] args)
{
//Add an interceptor to force a fake db connection issue
//so we can see the connection retry at work. This intercepts
//ReaderExecuting to force the exception.
DbInterception.Add(new InterceptorForceTransientErrors());
//Add an interceptor to log our details so we can log
//out the details each step of the way
DbInterception.Add(new InterceptorForLogging());
using (var context = new MusicContext())
{
Console.WriteLine("Adding album");
context.Albums.Add(new Album()
{
Title = "My Album",
Price = 9.99m
});
context.SaveChanges();
Console.WriteLine("Attempting query (Interceptor will now fake a connection error to trigger retry)");
//To force our exception, one of our parameters needs to have
//the word Throw. Thats how our connection interceptor knows to fake an error
try
{
var count = context.Albums.Where(o => o.Title.Contains("FakeAnError")).Count();
}
catch (RetryLimitExceededException)
{
Console.WriteLine("Caught RetryLimitExceededException, connection retry worked.");
Console.WriteLine("Press enter to continue...");
Console.ReadLine();
return;
}
//Shouldn't get here :)
foreach (var album in context.Albums.ToList())
{
Console.WriteLine(
string.Format("Id:{0}\nTitle:{1}\nPrice:{2}\n\n",
album.AlbumId, album.Title, album.Price));
}
}
Console.WriteLine("Press enter to continue...");
Console.ReadLine();
}