public void DefaultCommandTimeOutNotWorking()
{
string connectionString = String.Format(
"metadata=res://*/TestModel.csdl|res://*/TestModel.ssdl|res://*/TestModel.msl;provider=MySql.Data.MySqlClient; provider connection string=\"{0};Use Default Command Timeout For EF=true; Default Command Timeout=5;\"", GetConnectionString(true));
//EntityConnection connection = new EntityConnection(connectionString);
using (testEntities context = new testEntities(connectionString))
{
Author a = new Author();
a.Id = 66; // special value to indicate the routine should take 30 seconds
a.Name = "Test name";
a.Age = 44;
context.AddToAuthors(a);
try
{
context.SaveChanges();
Assert.Fail("This should have timed out");
}
catch (Exception ex)
{
Exception innerException = ex.InnerException;
Assert.AreEqual("Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.", innerException.Message);
}
}
}
public void Insert()
{
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Authors", st.conn);
DataTable dt = new DataTable();
da.Fill(dt);
int count = dt.Rows.Count;
using (testEntities context = new testEntities())
{
Author a = new Author();
a.Id = 23;
a.Name = "Test name";
a.Age = 44;
context.AddToAuthors(a);
context.SaveChanges();
}
dt.Clear();
da.Fill(dt);
Assert.Equal(count + 1, dt.Rows.Count);
Assert.Equal(23, dt.Rows[count]["id"]);
}
public void CommandTimeout()
{
string connectionString = String.Format(
"metadata=res://*/TestModel.csdl|res://*/TestModel.ssdl|res://*/TestModel.msl;provider=MySql.Data.MySqlClient; provider connection string=\"{0};default command timeout=5\"", st.GetConnectionString(true));
EntityConnection connection = new EntityConnection(connectionString);
using (testEntities context = new testEntities(connection))
{
Author a = new Author();
a.Id = 66; // special value to indicate the routine should take 30 seconds
a.Name = "Test name";
a.Age = 44;
context.AddToAuthors(a);
try
{
context.SaveChanges();
//Assert.Fail("This should have timed out");
}
catch (Exception ex)
{
string s = ex.Message;
}
}
}