public void Mapping_can_get_set_property_value()
{
const string connectionString = "Data Source=:memory:";
var options = new DataContextOptionsBuilder().UseSqlite(connectionString).Options;
using (var context = new SimpleDataContext(options))
{
Assert.Single(context.Model.EntityMappings);
var entityMapping = context.Model.EntityMappings.First();
Assert.IsType <EntityMapping <Address> >(entityMapping);
var addressEntityMapping = (EntityMapping <Address>)entityMapping;
var testAddress = new Address()
{
AddressId = 1,
Street = "123 Banana Seat",
City = "Somewhere",
Country = "Canada"
};
var country = addressEntityMapping.GetColumn(testAddress, "Country");
Assert.Equal("Canada", country);
addressEntityMapping.SetColumn(testAddress, "Country", "USA");
var newCountry = addressEntityMapping.GetColumn(testAddress, "Country");
Assert.Equal("USA", newCountry);
}
}
public void Mapping_has_valid_configuration_entity_mapping()
{
const string connectionString = "Data Source=:memory:";
var options = new DataContextOptionsBuilder().UseSqlite(connectionString).Options;
using (var context = new SimpleDataContext(options))
{
Assert.Single(context.Model.EntityMappings);
var entityMapping = context.Model.EntityMappings.First();
Assert.IsType <EntityMapping <Address> >(entityMapping);
var addressEntityMapping = (EntityMapping <Address>)entityMapping;
Assert.Equal("Address", addressEntityMapping.TableName);
Assert.Equal(4, addressEntityMapping.ColumnMappings.Count);
var idPropertyMapping = addressEntityMapping.ColumnMappings.First(p => p.PropertyName == "AddressId");
Assert.IsType <ColumnMapping>(idPropertyMapping);
Assert.True(idPropertyMapping.IsKey);
var streetPropertyMapping = addressEntityMapping.ColumnMappings.First(p => p.PropertyName == "Street");
Assert.IsType <ColumnMapping>(streetPropertyMapping);
Assert.False(streetPropertyMapping.IsKey);
var cityPropertyMapping = addressEntityMapping.ColumnMappings.First(p => p.PropertyName == "City");
Assert.IsType <ColumnMapping>(cityPropertyMapping);
Assert.False(cityPropertyMapping.IsKey);
Assert.Equal("City", cityPropertyMapping.ColumnName);
}
}
public ActionResult Install()
{
System.Diagnostics.Debug.Listeners.Add(new HttpTraceListener());
SimpleDataContext ctx = new SimpleDataContext();
ctx.Database.Initialize(true);
return(Content("End"));
}
private void SimpleDataContext_Click(object sender, RoutedEventArgs e)
{
if (IsWindowOpen <SimpleDataContext>())
{
MessageBox.Show("This window is already open!", "Error", MessageBoxButton.OK);
}
else
{
SDC_window = new Windows.SimpleDataContext();
SDC_window.Show();
}
}
static void Main(string[] args)
{
Console.WriteLine("Simple select #1");
using (var db = new SimpleDataContext())
foreach (var item in (from i in db.SimpleDatas
where i.Name.EndsWith("1")
select i))
{
Console.WriteLine(item.Name);
}
Console.WriteLine("\nSimple select #2");
using (var db = new SimpleDataContext())
foreach (var item in db.SimpleDatas.Where(x => x.Name.Contains("2")))
{
Console.WriteLine(item.Name);
}
Console.WriteLine("Firs load all data then filter.");
using (var db = new SimpleDataContext())
{
IEnumerable <SimpleData> datas = db.SimpleDatas;
foreach (var item in datas.Where(x => x.Id % 2 == 0).ToList())
{
Console.WriteLine(item.Name);
}
}
Console.WriteLine("Load partial data by filter.");
using (var db = new SimpleDataContext())
{
IQueryable <SimpleData> datas = db.SimpleDatas;
foreach (var item in datas.Where(x => x.Id % 3 == 0).ToList())
{
Console.WriteLine(item.Name);
}
}
Console.WriteLine("AsNoTracking");
using (var db = new SimpleDataContext())
{
IQueryable <SimpleData> datas = db.SimpleDatas.AsNoTracking();
foreach (var item in datas.Where(x => x.Id % 33 == 0).ToList())
{
Console.WriteLine(item.Name);
}
}
Console.Read();
}
