public void CheckContainsWhenUsingHardCodedValueWithPorcentageSymbol()
{
using (SakilaDb db = new SakilaDb())
{
var result = db.actors.Where(e => e.last_name.Contains("%")).ToArray();
Assert.Equal(0, result.Count());
}
}
public void CheckStartsWithWhenUsingValue()
{
#if DEBUG
Debug.WriteLine(new StackTrace().GetFrame(0).GetMethod().Name);
#endif
using (SakilaDb db = new SakilaDb())
{
var result = db.actors.Where(e => e.last_name.StartsWith("Astaire")).ToArray();
Assert.Equal(1, result.Count());
}
}
public void CheckContainsWhenUsingVariable()
{
#if DEBUG
Debug.WriteLine(new StackTrace().GetFrame(0).GetMethod().Name);
#endif
string str = "stai";
using (SakilaDb db = new SakilaDb())
{
var result = db.actors.Where(e => e.last_name.Contains(str)).ToArray();
Assert.Equal(1, result.Count());
}
}
public void NestedTransactionsUniqueKey()
{
using (SakilaDb context = new SakilaDb())
{
var store = new store
{
manager_staff_id = 1
};
context.stores.Add(store);
for (int i = 0; i < 10; i++)
{
Assert.Throws <DbUpdateException>(() => context.SaveChanges());
}
}
}
public void DisposeNestedTransactions()
{
using (SakilaDb context = new SakilaDb())
{
using (var trans = context.Database.BeginTransaction())
{
Assert.Throws <MySqlException>(() => context.Database.ExecuteSqlCommand("update abc"));
}
}
// new second transaction
using (SakilaDb context = new SakilaDb())
{
using (var trans = context.Database.BeginTransaction())
{
Assert.Throws <MySqlException>(() => context.Database.ExecuteSqlCommand("update abc"));
}
}
}