public void ComplexTypeReader()
{
var user = new TestUser
{
Contact = new Contact { Address = new Address { City = "Tallinn", Country = "Estonia"}, PhoneNumber = "1234567"},
FirstName = "Max",
LastName = "Lego",
Id = Guid.NewGuid()
};
var emptyUser = new TestUser();
using (var ctx = new TestContext())
{
var tableMapping = ctx.Db<TestUser>();
var tableMappings = new Dictionary<Type, IEntityMap>
{
{typeof (TestUser), tableMapping}
};
using (var reader = new MappedDataReader<TestUser>(new[] { user, emptyUser }, tableMappings))
{
Assert.AreEqual(9, reader.FieldCount);
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; ++i)
{
Console.WriteLine("{0}: {1}", i, reader.GetValue(i));
}
}
}
}
}
public void SimpleTableReader()
{
using (var ctx = new TestContext())
{
var tableMapping = ctx.Db<Page>();
var tableMappings = new Dictionary<Type, IEntityMap>
{
{typeof (Page), tableMapping}
};
using (var reader = new MappedDataReader<Page>(new[] {new Page { Title = "test"}}, tableMappings))
{
Assert.AreEqual(6, reader.FieldCount);
}
}
}
public void SimpleTableReader()
{
using (var ctx = new TestContext())
{
var tableMapping = ctx.Db <Page>();
var tableMappings = new Dictionary <Type, IEntityMap>
{
{ typeof(Page), tableMapping }
};
using (var reader = new MappedDataReader <Page>(new[] { new Page {
Title = "test"
} }, tableMappings))
{
Assert.AreEqual(6, reader.FieldCount);
}
}
}
public void TableMapping_ColumnsCount_TableWithComplexType()
{
using (var ctx = new TestContext())
{
var tableMapping = ctx.Db <TestUser>();
var user = new TestUser
{
FirstName = "fn",
LastName = "ln",
Contact =
new Contact
{
PhoneNumber = "123456",
Address =
new Address
{
City = "Tallinn",
Country = "Estonia",
County = "Harju",
PostalCode = "-"
}
}
};
Console.WriteLine("TestUser table should contain 8 columns");
var mappings = new Dictionary <Type, IEntityMap> {
{ typeof(TestUser), tableMapping }
};
using (var dataTable = DataTableHelper.Create(mappings, new[] { user }))
{
foreach (DataColumn column in dataTable.Columns)
{
Console.WriteLine(column.ColumnName);
}
Assert.AreEqual(8, dataTable.Columns.Count);
}
}
}
public void TableMapping_ColumnsCount_TableWithComplexType()
{
using (var ctx = new TestContext())
{
var tableMapping = ctx.Db<TestUser>();
var user = new TestUser
{
FirstName = "fn",
LastName = "ln",
Contact =
new Contact
{
PhoneNumber = "123456",
Address =
new Address
{
City = "Tallinn",
Country = "Estonia",
County = "Harju",
PostalCode = "-"
}
}
};
Console.WriteLine("TestUser table should contain 8 columns");
var mappings = new Dictionary<Type, IEntityMap> { { typeof(TestUser), tableMapping } };
using (var dataTable = DataTableHelper.Create(mappings, new[] {user}))
{
foreach (DataColumn column in dataTable.Columns)
{
Console.WriteLine(column.ColumnName);
}
Assert.AreEqual(8, dataTable.Columns.Count);
}
}
}
public void ComplexTypeReader()
{
var user = new TestUser
{
Contact = new Contact {
Address = new Address {
City = "Tallinn", Country = "Estonia"
}, PhoneNumber = "1234567"
},
FirstName = "Max",
LastName = "Lego",
Id = Guid.NewGuid()
};
var emptyUser = new TestUser();
using (var ctx = new TestContext())
{
var tableMapping = ctx.Db <TestUser>();
var tableMappings = new Dictionary <Type, IEntityMap>
{
{ typeof(TestUser), tableMapping }
};
using (var reader = new MappedDataReader <TestUser>(new[] { user, emptyUser }, tableMappings))
{
Assert.AreEqual(9, reader.FieldCount);
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; ++i)
{
Console.WriteLine("{0}: {1}", i, reader.GetValue(i));
}
}
}
}
}
