public void Test1()
{
string con = "Server=localhost,1401;User Id = sa; Password=<YourNewStrong!Passw0rd>";
// var c = new SqlConnection(con);
// using (var cnn = new SqlConnection(con))
// {
// cnn.Open();
// 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 = 0;
// While @i <= 5001
// Begin
// Insert Posts ([Text],CreationDate, LastChangeDate) values (replicate('x', 2000), GETDATE(), GETDATE());
// Set @i = @i + 1;
// End
//End
//";
// cmd.Connection = cnn;
// cmd.ExecuteNonQuery();
// }
var t = new DapperExtensionsBuilder().BuildImplementor(new[] { GetType().Assembly },
new DapperExtensionsConfiguration());
using (var cnn = new SqlConnection(con))
{
var post = t.DapperImplementor.Get <Post>(cnn, 1, null, null);
}
}
public virtual void Setup()
{
var connectionString = string.Format("Data Source=.\\dapperTest_{0}.sqlite", Guid.NewGuid());
var connectionParts = connectionString.Split(';');
var file = connectionParts
.ToDictionary(k => k.Split('=')[0], v => v.Split('=')[1])
.Where(d => d.Key.Equals("Data Source", StringComparison.OrdinalIgnoreCase))
.Select(k => k.Value).Single();
if (File.Exists(file))
{
File.Delete(file);
}
var connection = new SqliteConnection(connectionString);
var config = new DapperExtensionsConfiguration
{
Dialect = new SqliteDialect(),
AutoPopulateKeyGuidValue = true
};
var dapper = new DapperExtensionsBuilder().BuildImplementor(new[] { GetType().Assembly }, config);
Db = new Database(connection, dapper.DapperImplementor);
var files = new List <string>
{
SqlScripts.Animal,
SqlScripts.Foo,
SqlScripts.Multikey,
SqlScripts.Person,
SqlScripts.Car
};
foreach (var setupFile in files)
{
connection.Execute(setupFile);
}
}
