public void UpdateSimple()
{
using (testEntities context = new testEntities())
{
MySqlTrace.Listeners.Clear();
MySqlTrace.Switch.Level = SourceLevels.All;
GenericListener listener = new GenericListener();
MySqlTrace.Listeners.Add(listener);
Product pc = null;
try
{
pc = new Product();
pc.Name= "Acme";
context.AddToProducts(pc);
context.SaveChanges();
pc.Name = "Acme 2";
context.SaveChanges();
}
finally
{
#if CLR4
context.Products.DeleteObject(pc);
#endif
}
// Check sql
Regex rx = new Regex(@"Query Opened: (?<item>UPDATE .*)", RegexOptions.Compiled | RegexOptions.Singleline);
foreach( string s in listener.Strings )
{
Match m = rx.Match(s);
if (m.Success)
{
CheckSql(m.Groups["item"].Value, SQLSyntax.UpdateWithSelect);
Assert.Pass();
}
}
Assert.Fail();
}
}
public void CanInsertRowWithDefaultTimeStamp()
{
using (testEntities context = new testEntities())
{
// The default timestamp is in the CreatedDate column.
Product product = new Product();
product.Name = "Coca Cola";
context.AddToProducts(product);
context.SaveChanges();
Assert.AreEqual(DateTime.Today.Day, product.CreatedDate.Day);
}
}
public void UpdateAllRows()
{
MySqlCommand cmd = new MySqlCommand("SELECT COUNT(*) FROM toys", conn);
object count = cmd.ExecuteScalar();
using (testEntities context = new testEntities())
{
foreach (Toy t in context.Toys)
t.Name = "Top";
context.SaveChanges();
}
cmd.CommandText = "SELECT COUNT(*) FROM Toys WHERE name='Top'";
object newCount = cmd.ExecuteScalar();
Assert.AreEqual(count, newCount);
}
public void SimpleDeleteAllRows()
{
using (testEntities context = new testEntities())
{
foreach (Toy t in context.Toys)
context.DeleteObject(t);
context.SaveChanges();
EntityConnection ec = context.Connection as EntityConnection;
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM toys",
(MySqlConnection)ec.StoreConnection);
DataTable dt = new DataTable();
da.Fill(dt);
Assert.AreEqual(0, dt.Rows.Count);
}
}
public void SimpleDeleteRowByParameter()
{
using (testEntities context = new testEntities())
{
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM toys WHERE minage=3", conn);
DataTable dt = new DataTable();
da.Fill(dt);
Assert.IsTrue(dt.Rows.Count > 0);
ObjectQuery<Toy> toys = context.Toys.Where("it.MinAge = @age", new ObjectParameter("age", 3));
foreach (Toy t in toys)
context.DeleteObject(t);
context.SaveChanges();
dt.Clear();
da.Fill(dt);
Assert.AreEqual(0, dt.Rows.Count);
}
}
public void TimeType()
{
using (testEntities context = new testEntities())
{
TimeSpan birth = new TimeSpan(11,3,2);
Child c = new Child();
c.Id = 20;
c.EmployeeID = 1;
c.FirstName = "first";
c.LastName = "last";
c.BirthTime = birth;
context.AddToChildren(c);
context.SaveChanges();
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM EmployeeChildren WHERE id=20", conn);
DataTable dt = new DataTable();
da.Fill(dt);
Assert.AreEqual(birth, dt.Rows[0]["birthtime"]);
}
}
public void InsertSingleRow()
{
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM companies", conn);
DataTable dt = new DataTable();
da.Fill(dt);
DataRow lastRow = dt.Rows[dt.Rows.Count - 1];
int lastId = (int)lastRow["id"];
DateTime dateBegan = DateTime.Now;
using (testEntities context = new testEntities())
{
Company c = new Company();
c.Id = 23;
c.Name = "Yoyo";
c.NumEmployees = 486;
c.DateBegan = dateBegan;
c.Address.Address = "212 My Street.";
c.Address.City = "Helena";
c.Address.State = "MT";
c.Address.ZipCode = "44558";
context.AddToCompanies(c);
int result = context.SaveChanges();
DataTable afterInsert = new DataTable();
da.Fill(afterInsert);
lastRow = afterInsert.Rows[afterInsert.Rows.Count - 1];
Assert.AreEqual(dt.Rows.Count + 1, afterInsert.Rows.Count);
Assert.AreEqual(lastId + 1, lastRow["id"]);
Assert.AreEqual("Yoyo", lastRow["name"]);
Assert.AreEqual(486, lastRow["numemployees"]);
DateTime insertedDT = (DateTime)lastRow["dateBegan"];
Assert.AreEqual(dateBegan.Date, insertedDT.Date);
Assert.AreEqual("212 My Street.", lastRow["address"]);
Assert.AreEqual("Helena", lastRow["city"]);
Assert.AreEqual("MT", lastRow["state"]);
Assert.AreEqual("44558", lastRow["zipcode"]);
}
}
public void Update()
{
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Authors", conn);
DataTable dt = new DataTable();
da.Fill(dt);
int count = dt.Rows.Count;
using (testEntities context = new testEntities())
{
var q = from a in context.Authors
where a.Name == "Don Box"
select a;
foreach (Author a in q)
a.Name = "Dummy";
context.SaveChanges();
}
da.SelectCommand.CommandText = "SELECT * FROM Authors WHERE name='Dummy'";
dt.Clear();
da.Fill(dt);
Assert.AreEqual(1, dt.Rows.Count);
}
public void Insert()
{
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Authors", 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.AreEqual(count + 1, dt.Rows.Count);
Assert.AreEqual(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\"", 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;
}
}
}
public void Delete()
{
using (testEntities context = new testEntities())
{
foreach (Book b in context.Books)
context.DeleteObject(b);
context.SaveChanges();
}
MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Books", conn);
DataTable dt = new DataTable();
da.Fill(dt);
Assert.AreEqual(0, dt.Rows.Count);
}
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 DoubleValuesNonEnglish()
{
CultureInfo curCulture = Thread.CurrentThread.CurrentCulture;
CultureInfo curUICulture = Thread.CurrentThread.CurrentUICulture;
CultureInfo newCulture = new CultureInfo("da-DK");
Thread.CurrentThread.CurrentCulture = newCulture;
Thread.CurrentThread.CurrentUICulture = newCulture;
try
{
using (testEntities context = new testEntities())
{
Child c = new Child();
c.Id = 20;
c.EmployeeID = 1;
c.FirstName = "Bam bam";
c.LastName = "Rubble";
c.BirthWeight = 8.65;
context.AddToChildren(c);
context.SaveChanges();
}
}
finally
{
Thread.CurrentThread.CurrentCulture = curCulture;
Thread.CurrentThread.CurrentUICulture = curUICulture;
}
}
public void TimestampColumn()
{
DateTime now = DateTime.Now;
using (testEntities context = new testEntities())
{
Child c = context.Children.First();
DateTime dt = c.Modified.DateTime;
c.Modified = now;
context.SaveChanges();
c = context.Children.First();
dt = c.Modified.DateTime;
Assert.AreEqual(now, dt);
}
}