Entity Framework Code First : Dasar (2)

[P]ada tulisan sebelumnya kita sudah bisa menyimpan data ke database menggunakan Entity Framework Code First. Selanjutnya yang akan saya lakukan di tutorial ini adalah menunjukkan cara untuk melakukan proses yang wajib ada pada operasi dengan database yaitu membaca data, update dan juga hapus.

Untuk blog post kali ini saya tidak akan banyak ngomong melainkan langsung menunjukkan kode program disertai dengan screen shot hasilnya. Silahkan dinikmati dan dipelajari

Read All Data

MyContext context = new MyContext();
List<Student> students = context.Students.ToList();

foreach (var student in students)
{
    Console.WriteLine("Id : " + student.StudentId);
    Console.WriteLine("First Name : " + student.FirstName);
    Console.WriteLine("Last Name : " + student.LastName);
    Console.WriteLine("Major : " + student.Major);
    Console.WriteLine("Address : " + student.Address);
    Console.WriteLine("=============================");
}

MyContext context = new MyContext();

List<Student> students = context.Students.ToList();

foreach (var student in students)

{

Console.WriteLine("Id : " + student.StudentId);

Console.WriteLine("First Name : " + student.FirstName);

Console.WriteLine("Last Name : " + student.LastName);

Console.WriteLine("Major : " + student.Major);

Console.WriteLine("Address : " + student.Address);

Console.WriteLine("=============================");

}

Read One Data

MyContext context = new MyContext();
Student student = context.Students.SingleOrDefault(s => s.StudentId == 1);
Console.WriteLine("Id : " + student.StudentId);
Console.WriteLine("First Name : " + student.FirstName);
Console.WriteLine("Last Name : " + student.LastName);
Console.WriteLine("Major : " + student.Major);
Console.WriteLine("Address : " + student.Address);

MyContext context = new MyContext();

Student student = context.Students.SingleOrDefault(s => s.StudentId == 1);

Console.WriteLine("Id : " + student.StudentId);

Console.WriteLine("First Name : " + student.FirstName);

Console.WriteLine("Last Name : " + student.LastName);

Console.WriteLine("Major : " + student.Major);

Console.WriteLine("Address : " + student.Address);

Update

MyContext context = new MyContext();
Student student = context.Students.SingleOrDefault(s => s.StudentId == 1);
student.Address = "Kuta, Bali";

context.Entry(student).State = EntityState.Modified;
context.SaveChanges();

student = context.Students.SingleOrDefault(s => s.StudentId == 1);
Console.WriteLine("Address after updated : " + student.Address);

MyContext context = new MyContext();

Student student = context.Students.SingleOrDefault(s => s.StudentId == 1);

student.Address = "Kuta, Bali";

context.Entry(student).State = EntityState.Modified;

context.SaveChanges();

student = context.Students.SingleOrDefault(s => s.StudentId == 1);

Console.WriteLine("Address after updated : " + student.Address);

Delete

MyContext context = new MyContext();
Student student = context.Students.SingleOrDefault(s => s.StudentId == 2);
context.Students.Remove(student);
context.SaveChanges();

int shouldBeOne = context.Students.ToList().Count;
Console.WriteLine("Length of Student List now should be 1 after deletion : " + shouldBeOne);

MyContext context = new MyContext();

Student student = context.Students.SingleOrDefault(s => s.StudentId == 2);

context.Students.Remove(student);

context.SaveChanges();

int shouldBeOne = context.Students.ToList().Count;

Console.WriteLine("Length of Student List now should be 1 after deletion : " + shouldBeOne);

Conclusion

So. what is your conclusion?
Entity Framework sangat memudahkan para developer untuk berurusan dengan operasi-operasi pada database, membuat pengembangan sebuah aplikasi menjadi Rapid.

Facebook Comments

One thought on “Entity Framework Code First : Dasar (2)”

amin vincent says:

July 14, 2017 at 1:59 am

EF setup koneksi ketika menggunakan database seperti MySql atau Oracle belum ada tutorialnya ya mas? saya tunggu soalnya sangat bermanfaat, mungkin bisa di tambahkan untuk crud menggunakan relational database sebagai sampling… suwun

Agung Setiawan

Software Engineer

Entity Framework Code First : Dasar (2)

Read All Data

Read One Data

Update

Delete

Conclusion

One thought on “Entity Framework Code First : Dasar (2)”

Leave a Reply Cancel reply