public void GetCustomerCountSecondCallExecutesNonQueryTest()
{
var listener = new TestTraceListener();
Trace.Listeners.Add(listener);
var db = DatabaseHelper.Open();
db.GetCustomerCount();
Assert.IsFalse(listener.Output.Contains("ExecuteNonQuery"));
db.GetCustomerCount();
Assert.IsTrue(listener.Output.Contains("ExecuteNonQuery"));
Trace.Listeners.Remove(listener);
}
public void GetCustomerCountSecondCallExecutesNonQueryTest()
{
SimpleDataTraceSources.TraceSource.Switch.Level = SourceLevels.All;
var listener = new TestTraceListener();
SimpleDataTraceSources.TraceSource.Listeners.Add(listener);
var db = DatabaseHelper.Open();
db.GetCustomerCount();
Assert.IsFalse(listener.Output.Contains("ExecuteNonQuery"));
db.GetCustomerCount();
Assert.IsTrue(listener.Output.Contains("ExecuteNonQuery"));
SimpleDataTraceSources.TraceSource.Listeners.Remove(listener);
}
public void GetCustomerCountSecondCallExecutesNonQueryTest()
{
SimpleDataTraceSources.TraceSource.Switch.Level = SourceLevels.All;
var listener = new TestTraceListener();
SimpleDataTraceSources.TraceSource.Listeners.Add(listener);
var db = DatabaseHelper.Open();
db.GetCustomerCount();
Assert.IsFalse(listener.Output.Contains("ExecuteNonQuery"));
db.GetCustomerCount();
Assert.IsTrue(listener.Output.Contains("ExecuteNonQuery"));
SimpleDataTraceSources.TraceSource.Listeners.Remove(listener);
}
public void OrderByOnJoinedColumnShouldUseJoinedColumn()
{
var traceListener = new TestTraceListener();
Trace.Listeners.Add(traceListener);
var db = DatabaseHelper.Open();
var q = db.Employees.Query().LeftJoin(db.Employees.As("Manager"), Id: db.Employees.ManagerId);
q = q.Select(db.Employees.Name, q.Manager.Name.As("Manager"));
List <dynamic> employees = q.OrderBy(q.Manager.Name).ToList();
Trace.Listeners.Remove(traceListener);
Assert.Greater(traceListener.Output.IndexOf("order by [manager].[name]", StringComparison.OrdinalIgnoreCase), 0);
}
public void OrderByOnJoinedColumnShouldUseJoinedColumn()
{
var traceListener = new TestTraceListener();
Trace.Listeners.Add(traceListener);
var db = DatabaseHelper.Open();
var q = db.Employees.Query().LeftJoin(db.Employees.As("Manager"), Id: db.Employees.ManagerId);
q = q.Select(db.Employees.Name, q.Manager.Name.As("Manager"));
List<dynamic> employees = q.OrderBy(q.Manager.Name).ToList();
Trace.Listeners.Remove(traceListener);
Assert.Greater(traceListener.Output.IndexOf("order by [manager].[name]", StringComparison.OrdinalIgnoreCase), 0);
}