public void TraceTest()
{
var traceService = new TestTraceService();
using (Db.EnterTransaction())
{
Db.T($"SELECT * FROM testTable").WithTraceService(traceService).ExecuteDataTable();
var tracing = traceService.Last();
var logs = tracing.TraceEvents;
Assert.AreEqual(logs.Count, 3);
Assert.AreEqual(logs[0].EventName, "OnExecuting");
Assert.AreEqual(logs[1].EventName, "OnLoadingData");
Assert.AreEqual(logs[2].EventName, "OnComplete");
try
{
Db.T($"SELECT * FROM Nothing").WithTraceService(traceService).ExecuteDynamics();
}
catch
{
}
tracing = traceService.Last();
logs = tracing.TraceEvents;
Assert.AreEqual(logs.Count, 2);
Assert.AreEqual(logs[0].EventName, "OnExecuting");
Assert.AreEqual(logs[1].EventName, "OnException");
}
}
public void TraceTest()
{
var traceService = new TestTraceService();
using (Db.Enter(configure => configure.Services.AddService <IDbTraceService>(traceService)))
{
Db.T($"SELECT * FROM testTable").ExecuteDataTable();
var tracing = traceService.Last();
var logs = tracing.TraceEvents;
Assert.AreEqual(logs.Length, 3);
Assert.AreEqual(logs[0].EventName, "OnExecuting");
Assert.AreEqual(logs[1].EventName, "OnLoadingData");
Assert.AreEqual(logs[2].EventName, "OnComplete");
try
{
Db.T($"SELECT * FROM Nothing").ExecuteDynamics();
}
catch
{
}
tracing = traceService.Last();
logs = tracing.TraceEvents;
Assert.AreEqual(logs.Length, 2);
Assert.AreEqual(logs[0].EventName, "OnExecuting");
Assert.AreEqual(logs[1].EventName, "OnException");
}
}
public MySqlTest()
{
traceService = new TestTraceService();
db = MySqlDb.Connect("localhost", "Test", "root", "", configuration: new MySqlDbConfiguration()
{
TraceService = traceService
});
db.T("DROP TABLE IF EXISTS testTable").ExecuteNonQuery();
db.T(@"
CREATE TABLE testTable(
Id int(11) NOT NULL,
Name varchar(50) DEFAULT NULL,
Content text,
PRIMARY KEY (Id)
)").ExecuteNonQuery();
}
public SqlServerTest()
{
SqlServerExpress.Configuration.TraceService = traceService = new TestTraceService();
db = SqlServerExpress.Connect("TestDatabase");
db.T("IF OBJECT_ID(N'[dbo].[Test1]') IS NOT NULL DROP TABLE [dbo].[Test1]").ExecuteNonQuery();
db.T(@"
CREATE TABLE [dbo].[Test1]
(
[ID] INT NOT NULL IDENTITY,
[Name] NVARCHAR(50) NOT NULL ,
[Content] NTEXT NULL,
[XmlContent] XML NULL,
[Index] INT NOT NULL,
CONSTRAINT [PK_Test1] PRIMARY KEY ([ID])
)").ExecuteNonQuery();
}
public void Enter()
{
scope = Db.Enter(builder => builder
.UseSqlServer("Data Source=(localdb)\\ProjectsV13;Initial Catalog=Test;")
.Services.AddService <IDbTraceService>(traceService = new TestTraceService())
);
Db.T($"IF OBJECT_ID(N'[dbo].[Test1]') IS NOT NULL DROP TABLE [dbo].[Test1]").ExecuteNonQuery();
Db.T($@"
CREATE TABLE [dbo].[Test1]
(
[ID] INT NOT NULL IDENTITY,
[Name] NVARCHAR(50) NOT NULL ,
[Content] NTEXT NULL,
[XmlContent] XML NULL,
[Index] INT NOT NULL,
CONSTRAINT [PK_Test1] PRIMARY KEY ([ID])
)").ExecuteNonQuery();
}
