public void Create_AutoMap_Sql_SpecifyFunc()
{
User user = null;
using (var reader = GetSqlDataReader())
{
reader.Read();
var addressMap = new DataReaderAutoMap <Address>()
.Specify("PostCode", t => t.PostCode.Code);
var map = new DataReaderAutoMap <User>()
.Specify("UserId", t => t.Id)
.Specify((s, t) => t.Address = addressMap.Create(s));
user = map.Create(reader);
}
AssertFirstUser(user, true, true);
}
public void Create_WithLegacyNameMatching()
{
var id = RandomGuid();
var firstName = RandomGuidString();
var lastName = RandomGuidString();
var stubReader = GetLegacyStubReader(id, firstName, lastName);
var map = new DataReaderAutoMap <User>().Matching <LegacyNameMatchingStrategy>();
User user = map.Create(stubReader);
Assert.IsNotNull(user);
Assert.AreEqual(id, user.Id);
Assert.AreEqual(firstName, user.FirstName);
Assert.AreEqual(lastName, user.LastName);
}
public void Create_WithLegacyNameMatching()
{
var id = RandomGuid();
var firstName = RandomGuidString();
var lastName = RandomGuidString();
var stubReader = GetLegacyStubReader(id, firstName, lastName);
var map = new DataReaderAutoMap<User>().Matching<LegacyNameMatchingStrategy>();
User user = map.Create(stubReader);
Assert.IsNotNull(user);
Assert.AreEqual(id, user.Id);
Assert.AreEqual(firstName, user.FirstName);
Assert.AreEqual(lastName, user.LastName);
}
public void Performance_AutoMap_Sql()
{
using (var reader = GetSqlDataReader())
{
reader.Read();
var addressMap = new DataReaderAutoMap <Address>()
.Specify((s, t) => t.PostCode.Code = (string)s["PostCode"]);
var map = new DataReaderAutoMap <User>()
.Specify("UserId", t => t.Id)
.Specify((s, t) => t.Address = addressMap.Create(s));
for (int i = 0; i < PerformanceIterations; i++)
{
var user = map.Create(reader);
}
}
}
public void Create_NestedMaps_WithConversion()
{
Address address = null;
using (var addressReader = GetAddressSqlDataReader())
{
addressReader.Read();
var addressMap = new DataReaderAutoMap <Address>()
.Specify <string, string>("PostCode", t => t.PostCode.Code, c => c.ToLower());
address = addressMap.Create(addressReader);
}
using (var sourceUsers = GetSqlDataReader())
{
Assert.IsTrue(sourceUsers.Read());
Assert.IsNotNull(address);
Assert.IsNotNull(address.PostCode);
Assert.AreEqual((string)sourceUsers["PostCode"].ToString().ToLower(), address.PostCode.OriginalCode);
}
}
public void Create_NestedMaps()
{
User user = null;
using (var addressReader = GetAddressSqlDataReader())
{
addressReader.Read();
using (var userReader = GetUserSqlDataReader())
{
userReader.Read();
var addressMap = new DataReaderAutoMap <Address>()
.Specify("PostCode", t => t.PostCode.Code);
var map = new DataReaderAutoMap <User>()
.Specify("UserId", t => t.Id)
.Specify((s, t) => t.Address = addressMap.Create(addressReader));
user = map.Create(userReader);
}
}
AssertFirstUser(user, true, true);
}
public void FromSqlCe_AutoMap()
{
var stopwatch = Stopwatch.StartNew();
var count = 0;
var userMap = new DataReaderAutoMap<User>()
.Specify("UserId", t => t.Id)
.Specify("Line1", t => t.Address.Line1)
.Specify("Line2", t => t.Address.Line2)
.Specify("PostCode", t => t.Address.PostCode.Code);
using (var reader = GetSqlDataReader())
{
while (reader.Read() && count < PerformanceIterations)
{
count++;
var user = userMap.Create(reader);
AssertUser(reader, user, true, true);
}
}
Debug.WriteLine("FromSqlCe_AutoMap -Mapped: {0} objects and asserted 0 failures in: {1}ms", PerformanceIterations, stopwatch.ElapsedMilliseconds);
}
public void FromSqlCe_AutoMap()
{
var stopwatch = Stopwatch.StartNew();
var count = 0;
var userMap = new DataReaderAutoMap <User>()
.Specify("UserId", t => t.Id)
.Specify("Line1", t => t.Address.Line1)
.Specify("Line2", t => t.Address.Line2)
.Specify("PostCode", t => t.Address.PostCode.Code);
using (var reader = GetSqlDataReader())
{
while (reader.Read() && count < PerformanceIterations)
{
count++;
var user = userMap.Create(reader);
AssertUser(reader, user, true, true);
}
}
Debug.WriteLine("FromSqlCe_AutoMap -Mapped: {0} objects and asserted 0 failures in: {1}ms", PerformanceIterations, stopwatch.ElapsedMilliseconds);
}
public void Performance_AutoMap_Sql()
{
using (var reader = GetSqlDataReader())
{
reader.Read();
var addressMap = new DataReaderAutoMap<Address>()
.Specify((s, t) => t.PostCode.Code = (string)s["PostCode"]);
var map = new DataReaderAutoMap<User>()
.Specify("UserId", t => t.Id)
.Specify((s, t) => t.Address = addressMap.Create(s));
for (int i = 0; i < PerformanceIterations; i++)
{
var user = map.Create(reader);
}
}
}
public void Create_NestedMaps_WithConversion()
{
Address address = null;
using (var addressReader = GetAddressSqlDataReader())
{
addressReader.Read();
var addressMap = new DataReaderAutoMap<Address>()
.Specify<string, string>("PostCode", t => t.PostCode.Code, c => c.ToLower());
address = addressMap.Create(addressReader);
}
using (var sourceUsers = GetSqlDataReader())
{
Assert.IsTrue(sourceUsers.Read());
Assert.IsNotNull(address);
Assert.IsNotNull(address.PostCode);
Assert.AreEqual((string)sourceUsers["PostCode"].ToString().ToLower(), address.PostCode.OriginalCode);
}
}
public void Create_NestedMaps()
{
User user = null;
using (var addressReader = GetAddressSqlDataReader())
{
addressReader.Read();
using (var userReader = GetUserSqlDataReader())
{
userReader.Read();
var addressMap = new DataReaderAutoMap<Address>()
.Specify("PostCode", t => t.PostCode.Code);
var map = new DataReaderAutoMap<User>()
.Specify("UserId", t => t.Id)
.Specify((s, t) => t.Address = addressMap.Create(addressReader));
user = map.Create(userReader);
}
}
AssertFirstUser(user, true, true);
}
public void Create_AutoMap_Sql_SpecifyFunc()
{
User user = null;
using (var reader = GetSqlDataReader())
{
reader.Read();
var addressMap = new DataReaderAutoMap<Address>()
.Specify("PostCode", t => t.PostCode.Code);
var map = new DataReaderAutoMap<User>()
.Specify("UserId", t => t.Id)
.Specify((s, t) => t.Address = addressMap.Create(s));
user = map.Create(reader);
}
AssertFirstUser(user, true, true);
}