mirror of
https://github.com/DapperLib/Dapper.git
synced 2026-10-18 22:31:08 +08:00
Nick Craver
ae7a29a9f1
Due to the way VS test works (by injecting an executable entry point), the performance tests needed to be factored out. I also organized all of our existing tests better along the way. Actual code changes to Dapper itself are very minor, only formatting and documentation fixes (which we need many more of). The build.ps1 script is upated to work, but note that <frameworkAssemblies> is not working in .nuspec inside the packages in the new .csproj system. I consider this to be a blocker. Issue is here: https://github.com/NuGet/Home/issues/4853
84 lines
2.2 KiB
C#
84 lines
2.2 KiB
C#
using System;
|
|
using System.Threading.Tasks;
|
|
|
|
namespace Dapper.Tests.Performance
|
|
{
|
|
// Note: VSTest injects an entry point in .NET Core land...so we have to split this out into
|
|
// a separate project...so here we are.
|
|
// See https://github.com/Microsoft/vstest/issues/636 for details
|
|
public static class Program
|
|
{
|
|
public static void Main()
|
|
{
|
|
#if DEBUG
|
|
var fg = Console.ForegroundColor;
|
|
Console.ForegroundColor = ConsoleColor.Red;
|
|
Console.WriteLine("Warning: DEBUG configuration; performance may be impacted");
|
|
Console.ForegroundColor = fg;
|
|
Console.WriteLine();
|
|
#endif
|
|
Console.WriteLine("Using ConnectionString: " + PerformanceTests.ConnectionString);
|
|
|
|
EnsureDBSetup();
|
|
RunPerformanceTestsAsync().GetAwaiter().GetResult();
|
|
}
|
|
|
|
private static void EnsureDBSetup()
|
|
{
|
|
using (var cnn = PerformanceTests.GetOpenConnection())
|
|
{
|
|
var cmd = cnn.CreateCommand();
|
|
cmd.CommandText = @"
|
|
if (OBJECT_ID('Posts') is null)
|
|
begin
|
|
create table Posts
|
|
(
|
|
Id int identity primary key,
|
|
[Text] varchar(max) not null,
|
|
CreationDate datetime not null,
|
|
LastChangeDate datetime not null,
|
|
Counter1 int,
|
|
Counter2 int,
|
|
Counter3 int,
|
|
Counter4 int,
|
|
Counter5 int,
|
|
Counter6 int,
|
|
Counter7 int,
|
|
Counter8 int,
|
|
Counter9 int
|
|
)
|
|
|
|
set nocount on
|
|
|
|
declare @i int
|
|
declare @c int
|
|
|
|
declare @id int
|
|
|
|
set @i = 0
|
|
|
|
while @i <= 5001
|
|
begin
|
|
|
|
insert Posts ([Text],CreationDate, LastChangeDate) values (replicate('x', 2000), GETDATE(), GETDATE())
|
|
set @id = @@IDENTITY
|
|
|
|
set @i = @i + 1
|
|
end
|
|
end
|
|
";
|
|
cmd.Connection = cnn;
|
|
cmd.ExecuteNonQuery();
|
|
}
|
|
}
|
|
|
|
private static async Task RunPerformanceTestsAsync()
|
|
{
|
|
var test = new PerformanceTests();
|
|
const int iterations = 500;
|
|
Console.WriteLine("Running {0} iterations that load up a post entity", iterations);
|
|
await test.RunAsync(iterations).ConfigureAwait(false);
|
|
}
|
|
}
|
|
}
|