dir.by  
Поиск >>

Компьютер, программы
→
Entity Framework (EF5, EF6) for working with a C database#
 Удаление данных в Entity Framework 
посмотрели 10453 раз
обновлено: 1 Augusta 2018
Для удаления записи в Entity Framework использется метод Remove класса DbSet
Шаг 1. Создаем новое приложение
Шаг 2. Напишем код
  C#     В файле Program.cs напишем код:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Data.Entity;

namespace ConsoleApplication1
{
     public class Book
     {
          public int Id { get; set; }
          public string Name { get; set; }
          public int Price { get; set; }
     }

     class UserContext : DbContext
     {
          public UserContext() : base("MyConnection1")
          { }

          public DbSet<Book> Books { get; set; }
     }

     class Program
     {
          static void Main(string[] args)
          {
               // create context
               using (UserContext db = new UserContext())
               {
                    // ключ по которому будем удалять данные
                    int key = 5;

                    // Вариант 1. Удаление записи.
                    var item = db.Books.Find(key); // найдем запись
                    if (item!=null)
                    {
                         db.Books.Remove(item);
                         db.SaveChanges();
                    }

                    // Вариант 2. Удаление записи.
                    // Book book = new Book { Id = key };
                    // db.Entry(book).State = EntityState.Deleted;
                    // db.SaveChanges();
               }
          }
     }
}
 
← Previous topic
Modifying (editing) data in the Entity Framework
 
Next topic →
Initialize the database in the Entity Framework. DropCreateDatabaseAlways allows you to repopulate the database with each new run
 
Your feedback ... Comments ...
   
Your Name
Your comment (www links can only be added by a logged-in user)

Новость "Черная пятница" Dreame в Беларуси – две недели скидок до 3400 рублей
 
• What is Entity Framework?
Types in Entity Framework
• Entity Framework Type Conversion, Table Naming Conventions
• Foreign Key and Cascade Deletion
• DateTime & Date & Time Only in the Entity Framework
Code First
• Code First. We"re writing a C# class. Entity Framework uses our C# class → to create and populate a table in the database
• Auto Code First. Entity Framework creates a C# class from an existing table in the → database
Database First
• Database First. Entity Framework creates a C# class from an existing table in the → database
Model First
• Model First. We create a model in Visual Studio. Using the Entity Framework model, → creates C# classes and a Database
Working with data
• Iterating over data in the Entity Framework
• Adding Data to the Entity Framework
• Modifying (editing) data in the Entity Framework
• Deleting data in the Entity Framework
Database initialization and migration
• Initialize the database in the Entity Framework. DropCreateDatabaseAlways allows you to repopulate the database with each new run
• Performing a Database Migration to Entity Framework (if someone has already made a cs migration file, and I want to update the database on my computer, I perform the migration, that is, call EntityFramework\Update-Database)
• Creating and performing a Database migration to Entity Framework (I changed the c# class, then call EntityFramework\add-migration, i.e. the cs file with the migration code is automatically added to the project, then call EntityFramework\Update-Database, i.e. the migration file is executed and the database is changed)
SQL in Entity Framework
• SQL Commands in Entity Framework
Transactions in the Entity Framework
• Managing Transactions in the Entity Framework
Additional topics, questions
• What is <connectionStrings> a .config file for Entity Framework (EF5, EF6)
• When EntityFrameworkUpdate-Database is called, the error "System.Data.SqlClient.SqlException (0x80131904) is thrown. A network-related or instance-specific error occurred while establishing a connection to SQL Server. "
• When calling EntityFrameworkUpdate-Database, the error "Your startup project "..." doesn"t reference Microsoft.EntityFrameworkCore.Design"
WWW Sites to Learn Entity Framework
• Sites to learn Entity Framework

  Ваши вопросы присылайте по почте: info@dir.by