public void Can_Update_Dependent_Alone()
{
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
context.Students.AddRange(GenerateData());
context.SaveChanges();
}
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var address = context.Addresses.FirstOrDefault(a => a.City == "Utah");
Assert.IsNotNull(address);
address.City = "New York City";
context.SaveChanges();
}
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var address = context.Addresses.FirstOrDefault(a => a.City == "New York City");
Assert.IsNotNull(address);
var student = context.Students.Include(s => s.Address).FirstOrDefault(s => s.Name == "Julia");
Assert.IsNotNull(student);
Assert.IsNotNull(student.Address);
Assert.AreEqual("New York City", student.Address.City);
}
}
public void TearDown()
{
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
context.Database.EnsureDeleted();
}
}
public void SetUp()
{
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
context.Database.EnsureCreated();
}
}
public void FillGrid()
{
OtoContext otoContext = new OtoContext();
object query2 = (from arac in otoContext.Arac
join marka in otoContext.Marka
on arac.MarkaId equals marka.MarkaId
join aracmodel in otoContext.AracModel
on arac.ModelId equals aracmodel.ModelId
join vites in otoContext.Vites
on arac.VitesId equals vites.VitesId
join yakit in otoContext.Yakit
on arac.YakitId equals yakit.YakitId
select new
{
AracSaseNo = arac.AracSaseNo,
MarkaAdi = marka.MarkaAdi,
ModelAdi = aracmodel.ModelAdi,
Yakit = yakit.YakitTuru,
Vites = vites.VitesTuru,
AracYil = arac.AracYil,
AracKm = arac.AracKm,
AracRenk = arac.AracRenk
}).ToList();
dataGridView1.DataSource = query2;
}
public ActionResult Duzenle(int?id)
{
using (OtoContext ptx = new OtoContext())
{
var prc = ptx.Parcalar.Find(id);
return(View(prc));
}
}
public ActionResult Duzenle(int?id)
{
using (OtoContext ctx = new OtoContext())
{
var ato = ctx.Otomobil.Find(id);
return(View(ato));
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
OtoContext context = new OtoContext();
context.Database.CreateIfNotExists();
context.Database.Initialize(true);
Application.Run(new Form2());
}
public ActionResult Sil(int?id)
{
using (OtoContext ptx = new OtoContext())
{
var prc = ptx.Parcalar.Find(id);
ptx.Parcalar.Remove(prc);
ptx.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Sil(int?id)
{
using (OtoContext ctx = new OtoContext())
{
var ato = ctx.Otomobil.Find(id);
ctx.Otomobil.Remove(ato);
ctx.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Index()
{
using (OtoContext ctx = new OtoContext())
{
OtoViewModel ovm = new OtoViewModel
{
Otomobil = ctx.Otomobil.ToList()
};
return(View(ovm));
}
}
public ActionResult PrcIndex()
{
using (OtoContext ptx = new OtoContext())
{
ParcaViewModel ovm = new ParcaViewModel
{
Parcalar = ptx.Parcalar.ToList()
};
return(View(ovm));
}
}
public void Can_NOT_Create_Dependent_Without_Principal()
{
//Throws
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var address = new Address {
City = "Los Angeles"
};
context.Addresses.Add(address);
Assert.That(() => context.SaveChanges(), Throws.Exception);
}
}
public ActionResult Duzenle(Oto ato)
{
using (OtoContext ctx = new OtoContext())
{
ctx.Entry(ato).State = EntityState.Modified;
int sonuc = ctx.SaveChanges();
if (sonuc > 0)
{
return(RedirectToAction("Index"));
}
return(View());
}
}
private void Form2_Load(object sender, EventArgs e)
{
OtoContext otoContext = new OtoContext();
UrunDetay urunDetay = new UrunDetay {
UrunMarka = "Deneme", UrunModel = "Deneme", UrunUretimTarihi = DateTime.Now
};
Stok stok = new Stok {
UrunDetayId = urunDetay, Adet = 10, Birimi = "Tane"
};
otoContext.UrunDetay.Add(urunDetay);
otoContext.Stok.Add(stok);
otoContext.SaveChanges();
}
public void Updating_Dependent_Through_Principal_FAILS_Without_Include()
{
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
context.Students.AddRange(GenerateData());
context.SaveChanges();
}
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var student = context.Students.FirstOrDefault(s => s.Name == "Julia");
Assert.IsNotNull(student);
Assert.IsNull(student.Address);
}
}
public void Deleting_Principal_FAILS_Without_Including_Dependent()
{
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
context.Students.AddRange(GenerateData());
context.SaveChanges();
}
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var student = context.Students.FirstOrDefault(s => s.Name == "John");
context.Students.Remove(student);
Assert.That(() => context.SaveChanges(), Throws.Exception);
}
}
public void FillGridUrun()
{
OtoContext otoContext = new OtoContext();
object query2 = (from stok in otoContext.Stok join urun in otoContext.UrunDetay on stok.UrunDetayId equals urun.UrunDetayId
select new
{
urunmarka = urun.UrunMarka,
urunmodel = urun.UrunModel,
urunuretimtarihi = urun.UrunUretimTarihi,
urunadet = comboBoxUrunadet.SelectedItem,
faturatarihi = dateTimePickerFaturatarihi.Value,
satistürü = comboBoxFaturatip.SelectedItem
}).ToList();
dataGridView2.DataSource = query2;
}
public void Can_Create_Dependent_Without_Principal()
{
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var address = new Address {
City = "Los Angeles"
};
context.Addresses.Add(address);
context.SaveChanges();
}
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var address = context.Addresses.FirstOrDefault(a => a.City == "Los Angeles");
Assert.IsNotNull(address);
}
}
public void Can_Create_Principal_Without_Dependent()
{
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var student = new Student {
Name = "Earvin"
};
context.Students.Add(student);
context.SaveChanges();
}
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var student = context.Students.FirstOrDefault(s => s.Name == "Earvin");
Assert.IsNotNull(student);
}
}
public void FillGrid()
{
OtoContext otoContext = new OtoContext();
object query2 = (from stok in otoContext.Stok
join urundetay in otoContext.UrunDetay
on stok.UrunDetayId equals urundetay.UrunDetayId
select new
{
StokID = stok.UrunId,
//UrunMarka = urundetay.UrunMarka,
UrunModel = urundetay.UrunModel,
UrunUretimTarihi = urundetay.UrunUretimTarihi,
Adet = stok.Adet,
Birimi = stok.Birimi,
}).ToList();
dataGridView1.DataSource = query2;
}
public void FillGrid()
{
OtoContext otoContext = new OtoContext();
object query2 = (from cari in otoContext.Cari
select new
{
cariID = cari.cariID,
cariad = cari.ad,
carisoyad = cari.soyad,
carimail = cari.email,
caritel = cari.tel,
cariadresdetay = cari.adresdetay,
cariil = cari.ilAdi,
cariilce = cari.ilceAdi,
carirol = cari.rolAdi
}).ToList();
dataGridView1.DataSource = query2;
}
public bool Ekle(Parca p)
{
if (ModelState.IsValid)
{
using (OtoContext ptx = new OtoContext())
{
ptx.Parcalar.Add(p);
int sonuc = ptx.SaveChanges();
if (sonuc > 0)
{
return(true);
}
}
}
else
{
ModelState.AddModelError("ParcaId", "Bos");
}
return(false);
}
public bool Ekle(Oto o)
{
if (ModelState.IsValid)
{
using (OtoContext ctx = new OtoContext())
{
ctx.Otomobil.Add(o);
int sonuc = ctx.SaveChanges();
if (sonuc > 0)
{
return(true);
}
}
}
else
{
ModelState.AddModelError("AracId", "Bos");
}
return(false);
}
public void FillGrid()
{
OtoContext otoContext = new OtoContext();
object query2 = (from servis in otoContext.Servis
join cari in otoContext.Cari
on servis.CariId equals cari.cariID
join durum in otoContext.Durum
on servis.DurumId equals durum.DurumId
join calisan in otoContext.Cari
on servis.CalisanNo equals calisan.cariID
select new
{
ServisKayitNo = servis.ServisKayitNo,
AracSaseNo = servis.AracSaseNo,
CariAdi = cari.ad,
Durum = durum.Aciklama,
CalisanAdi = calisan.ad,
GirisTarihi = servis.GirisTarihi,
CikisTarihi = servis.CikisTarihi
}).ToList();
dataGridView1.DataSource = query2;
}
public void Updating_Dependent_Through_Principal_Requires_Include()
{
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
context.Students.AddRange(GenerateData());
context.SaveChanges();
}
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var student = context.Students.Include(s => s.Address).FirstOrDefault(s => s.Name == "Julia");
Assert.IsNotNull(student);
Assert.IsNotNull(student.Address);
student.Address.City = "New York City";
context.SaveChanges();
}
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var address = context.Addresses.FirstOrDefault(a => a.City == "New York City");
Assert.IsNotNull(address);
}
}
public void Deleting_DEPENDENT_Has_No_Effect_On_Principal()
{
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
context.Students.AddRange(GenerateData());
context.SaveChanges();
}
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var address = context.Addresses.FirstOrDefault(a => a.City == "Tacoma");
context.Addresses.Remove(address);
context.SaveChanges();
}
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var city = context.Addresses.FirstOrDefault(a => a.City == "Tacoma");
Assert.IsNull(city);
var student = context.Students.FirstOrDefault(s => s.Name == "John");
Assert.IsNotNull(student);
}
}
public void Deleting_Principal_With_Include_SUCCEED_Will_Remove_Dependent()
{
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
context.Students.AddRange(GenerateData());
context.SaveChanges();
}
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var student = context.Students.Include(s => s.Address).FirstOrDefault(s => s.Name == "John");
context.Students.Remove(student);
context.SaveChanges();
}
using (var context = new OtoContext(ContextOptions, Principal, IsRequired))
{
var student = context.Students.FirstOrDefault(s => s.Name == "John");
Assert.IsNull(student);
var city = context.Addresses.FirstOrDefault(a => a.City == "Tacoma");
Assert.IsNull(city);
}
}
public GenericRepository(OtoContext otoContext)
{
_otoContext = otoContext;
}
public static void Run(DbContextOptions options, PrincipalType type = PrincipalType.Address, bool isRequired = false)
{
Console.WriteLine("---- One-to-One Relationship -----");
Console.WriteLine(string.Format("Principal: {0}", type == PrincipalType.Student ? "Student" : "Address"));
Console.WriteLine();
using (var context = new OtoContext(options, type, isRequired))
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
#region CREATE
// Create
Console.WriteLine("----- CREATE -----");
Console.Write("Creating a student w/o address");
var student1 = new Student {
Name = "Micheal"
};
context.Students.Add(student1);
try
{
context.SaveChanges();
Console.WriteLine(" ==> Done");
}
catch (Exception e)
{
context.Students.Remove(student1);
Console.WriteLine(" ==> FAILED: Can not add student w/o address: \n", e.Message);
}
//
Console.Write("Creating a student w/ address");
var student2 = new Student {
Name = "John", Address = new Address {
City = "LA"
}
};
context.Students.Add(student2);
try
{
context.SaveChanges();
Console.WriteLine(" ==> Done");
}
catch (Exception e)
{
context.Students.Remove(student2);
Console.WriteLine(" ==> FAILED: Can not add student w/ address: \n ", e.Message);
}
//
Console.Write("Creating an address w/ Student");
var address3 = new Address {
City = "Chicago", Student = new Student {
Name = "Karl"
}
};
context.Addresses.Add(address3);
try
{
context.SaveChanges();
Console.WriteLine(" ==> Done");
}
catch (Exception e)
{
context.Addresses.Remove(address3);
Console.WriteLine(" ==> FAILURE: Can not add student w/ address: \n ", e.Message);
}
//
Console.Write("Creating an address w/o Student");
var address4 = new Address {
City = "Istanbul"
};
context.Addresses.Add(address4);
try
{
context.SaveChanges();
Console.WriteLine(" ==> Done");
}
catch (Exception e)
{
// Transaction rollback or catching exception through transaction commit
// does not clean up the context so you have to manually remove it.
//context.ChangeTracker.Entries<OneToZero.Address>()
// .Where(e => e.State == EntityState.Added).ToList()
// .ForEach(e => e.State = EntityState.Detached);
//context.Addresses.Remove(address4);
context.Entry(address4).State = EntityState.Detached;
Console.WriteLine(" ==> FAILED: Can not insert address4. Address4 instance should have required Student reference defined.");
}
#endregion
#region QUERY
Console.WriteLine("----- QUERY -----");
Console.WriteLine("Students.Count: {0}", context.Students.Count());
Console.WriteLine("Addresses.Count: {0}", context.Addresses.Count());
Console.Write("Querying for Student");
var foundStudent = context.Students.FirstOrDefault(u => u.Name == "Micheal");
if (foundStudent != null)
{
Console.WriteLine("==> Done: Student found: {0}", foundStudent.Name);
}
else
{
Console.WriteLine("==> FAILED: Student not found");
}
//
Console.Write("Querying for address");
var foundAd4 = context.Addresses.FirstOrDefault(ad => ad.City == "Chicago");
if (foundAd4 != null)
{
Console.WriteLine("==> Done: Address found: {0}", foundAd4.City);
}
else
{
Console.WriteLine("==> FAILED: Address not found");
}
//
// No need to use .Include() as stated in Microsoft documentation. The navigation properies are already loaded since we didn't change contexts
Console.Write("Querying for student w/ address");
var foundStwAddress = context.Students.FirstOrDefault(s => s.Name == "John");
if (foundStwAddress == null)
{
Console.WriteLine(" ==> FAILED: Can not find student with Name John");
}
else
{
Console.WriteLine(" ==> Done: City for John is : {0}", foundStwAddress.Address.City);
}
//
Console.Write("Querying for address w/ student");
var foundAddwStudent = context.Addresses.FirstOrDefault(s => s.City == "Chicago");
if (foundAddwStudent == null)
{
Console.WriteLine(" ==> FAILED: Can not find student with Name John");
}
else
{
Console.WriteLine(" ==> Done: Student for city Chicago is : {0}", foundAddwStudent.Student.Name);
}
#endregion
}
#region UPDATE
Console.WriteLine();
using (var context = new OtoContext(options, type, isRequired))
{
Console.WriteLine("----- UPDATE -----");
//
Console.Write("Update name for a student");
var foundStudent1 = context.Students.FirstOrDefault(u => u.Name == "John"); // Always exist
foundStudent1.Name = "Julia";
try
{
context.SaveChanges();
Console.WriteLine(" ==> Done");
}
catch (Exception)
{
context.Entry(foundStudent1).State = EntityState.Unchanged;
Console.WriteLine("==> FAILED: Can not update the name for the student");
}
//
Console.Write("Update city for an address");
var foundAddress1 = context.Addresses.FirstOrDefault(a => a.City == "Chicago"); // Always exist
foundAddress1.City = "New York";
try
{
context.SaveChanges();
Console.WriteLine(" ==> Done");
}
catch (Exception)
{
context.Entry(foundAddress1).State = EntityState.Unchanged;
Console.WriteLine("==> FAILED: Can not update the city for the address");
}
//
Console.Write("Query a student w/o address and update Address");
var foundStudent2 = context.Students.FirstOrDefault(u => u.Name == "Micheal");
if (foundStudent2 == null)
{
Console.WriteLine(" ==> Student: Micheal can not be found");
}
else
{
foundStudent2.Address = new Address {
City = "London"
};
try
{
context.SaveChanges();
Console.WriteLine(" ==> Done");
}
catch (Exception e)
{
context.Entry(foundStudent2).State = EntityState.Unchanged;
Console.WriteLine("==> FAILED: Can not update the student w new Address.");
}
}
//
Console.Write("Query an address w/o student and Update Student");
var foundAddress2 = context.Addresses.FirstOrDefault(a => a.City == "Istanbul");
if (foundAddress2 == null)
{
Console.WriteLine("\n ==> FAILED: Can not find Istanbul");
}
else
{
foundAddress2.Student = new Student {
Name = "Mert"
};
try
{
context.SaveChanges();
Console.WriteLine(" ==> Done");
}
catch (Exception)
{
context.Entry(foundAddress2).State = EntityState.Unchanged;
Console.WriteLine("==> FAILED: Can not update the address with adding student.");
}
}
}
#endregion
#region QUERY NAVIGATION PROPERTIES
Console.WriteLine();
// For querying navigation properties
// Created this context to make use of .Include() during query
using (var context = new OtoContext(options, type, isRequired))
{
Console.WriteLine("----- QUERY FOR NAVIGATION PROPERTIES AFTER UPDATES -----");
Console.WriteLine("Students.Count: {0}", context.Students.Count());
Console.WriteLine("Addresses.Count: {0}", context.Addresses.Count());
Console.Write("Query for the student record with the new address");
var student = context.Students.Include(s => s.Address).FirstOrDefault(u => u.Name == "Micheal");
if (student == null)
{
Console.WriteLine(" ==> FAILED: Can not find the student with Name Micheal");
}
else
{
Console.WriteLine(" ==> Done: City for Micheal is: {0}", student.Address.City);
}
Console.Write("Query for the address record with new student info");
var address = context.Addresses.Include(a => a.Student).FirstOrDefault(a => a.City == "Istanbul");
if (address == null)
{
Console.WriteLine(" ==> FAILED: Can not find the address with city name Istanbul");
}
else
{
Console.WriteLine(" ==> Done: Student for Istanbul is: {0}", address.Student.Name);
}
}
#endregion
#region DELETE
Console.WriteLine();
using (var context = new OtoContext(options, type, isRequired))
{
Console.WriteLine("----- DELETE -----");
Console.Write("Deleting student w/ address");
Student student = null;
if (!isRequired && type == PrincipalType.Student)
{
student = context.Students.Include(s => s.Address).FirstOrDefault(s => s.Name == "Karl");
}
else
{
student = context.Students.FirstOrDefault(s => s.Name == "Karl");
}
context.Remove(student);
context.SaveChanges();
Console.WriteLine(" ==> Done");
Console.Write("Deleting address w/ student");
Address address = null;
if (!isRequired && type == PrincipalType.Address)
{
address = context.Addresses.Include(a => a.Student).FirstOrDefault(a => a.City == "LA");
}
else
{
address = context.Addresses.FirstOrDefault(a => a.City == "LA");
}
context.Addresses.Remove(address);
context.SaveChanges();
Console.WriteLine(" ==> Done");
}
#endregion
}
