EF basic operations add, delete, check, modify, paginate, join...... etc

Little scum · Posted on 10/25/2018 10:59:48 AM

1. Add data in batches

Through the above comparison, if you add a new piece of data every time, use EF SaveChanges once, which will consume a lot of performance.

2. Batch deletion

Login is visible.

Query the results to ensure that there is a value in the database before deleting it.

3. EF edits data

The first way is to edit after querying;

The second way is to directly pass in a model entity that needs to be modified, which can be part of the field

Login is visible.

4. How to use join in EF

Login is visible.

5. EF pagination query

Login is visible.

6. Invocation of EF stored procedures

Login is visible.

7. Execute SQL in EF

Login is visible.

8. EF's method of improving query AsNoTracking

Login is visible.

9. Use of Set <T>generic method in EF context container