Entity Framework is very useful when dealking with many data classes. I am finding that when dealing with a large amount of records, Entity Framework is not the fastes solution. There is BulkInsert feature in Entity Framework but I have not seen anything faster than SQL BulkCopy yet. I will explain how to use it using an example below: The example will be in two different steps. PRE-REQUISITE: H..

개발 (Development & Coding)/영문본 (English) 2023. 3. 29. 06:00

Entity Framework (엔티티 프레임워크)는 데이터를 클래스 화 하여주어 ADO를 썼을 때 보다 코딩을 쉽게 도와줍니다. 하지만 데이터의 양이 많아지게 되면 데이터를 처리하는 속도가 느려지는 것이 단점이라고 할 수 있습니다. 아래의 설명을 통해 기억하기 쉽게 보통 데이터의 수가 10000개 이상이 되면 Entity Framework의 SaveChanges 나 BulkInsert를 쓰는 것보다 SQL Bulk Copy (SQL 벌크 카피)를 쓰는 게 훨씬 효율적인 것을 알게 되실 겁니다. 속도 비교 아래의 차트는 인서트를 처리하는 데이터의 수에 따른 속도를 보여줍니다. 차트에서와 같이 1000개 정도가 넘어가면 그 후로는 Add Range가 확연히 느려진다는 것을 보실 수 있습니다. Bulk In..

개발 (Development & Coding)/한글본 (Korean) 2023. 3. 29. 06:00

SThis article will show several best practice cases for using Entity Framework Core (aka EF Core). EF was an innovative technology to convert data to classes when ADO or even DAO were mainly used for data transformation in C#. It made developers' lives easier by not having to memorize and frequently refer which column included what kind of information. EF had evolved from EF to EF Core since .NE..

개발 (Development & Coding)/영문본 (English) 2023. 3. 15. 06:00

While you are creating numerous classes during development, there are numerous cases where you have to convert from one to another classes. For example, you may want to convert classes generated by Entity Framework to a class for use with Web API or client application. Many cases you may include same property names. During this process, you may be writing extra codes to convert from one to anoth..

개발 (Development & Coding)/영문본 (English) 2023. 2. 26. 06:00

Table Valued Function (TVF) in T-SQL (Transact-SQL) returns a table. Especially this feature is useful with Entity Framework because EF exposes this table class, whereas the Stored Procedure requires a manual extension to the database context by creating an additional class that Stored Procedure returns so that your .NET code can consume it when you call the Stored Procedure. There are two types..

개발 (Development & Coding)/영문본 (English) 2023. 2. 19. 14:15