public void UpdateSimple()
{
var sb = new MySqlConnectionStringBuilder(st.ConnectionString);
sb.Logging = true;
using (DefaultContext ctx = new DefaultContext(sb.ToString()))
{
MySqlTrace.Listeners.Clear();
MySqlTrace.Switch.Level = SourceLevels.All;
GenericListener listener = new GenericListener();
MySqlTrace.Listeners.Add(listener);
Product p = new Product()
{
Name = "Acme"
};
ctx.Products.Add(p);
ctx.SaveChanges();
p.Name = "Acme 2";
ctx.SaveChanges();
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)
{
st.CheckSqlContains(m.Groups["item"].Value,
@"UPDATE `Products` SET `Name`='Acme 2' WHERE `Id` = 1;
SELECT `CreatedDate` FROM `Products` WHERE row_count() > 0 and `Id` = 1");
}
}
}
}
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)
{
st.CheckSql(m.Groups["item"].Value, MySql.Data.Entity.Tests.Properties.SQLSyntax.UpdateWithSelect);
//TODO:check assert.fail commented.
//Assert.Pass();
}
}
//Assert.Fail();
}
}
