C
C#•5mo ago
mikibanan

Perform BulkInsert with multiple tables in dapper

Hi, I have simple DB with 4 tables. Products, Manufacturers, Databases and ProductsQuantity. I have one csv with Name, Manufacturer and multiple quantities from different databases. How to bulk insert new products with all the relations?
3 Replies
L. MS
L. MS•5mo ago
So you want to read the data out the csv file and put it in the db?
mikibanan
mikibanan•5mo ago
Yes
L. MS
L. MS•5mo ago
you can use ADO.NET for database operations. Use classes like SqlConnection , SqlCommand and SqlBulkCopy for more efficiently inserting large data amounts in the db by minimizing the back and forward communication
Want results from more Discord servers?
Add your server
More Posts
The value '' is invalid. for primary key in MVCI'm practicing MVC with asp.net and building a simple todo app. I have my Model: ```csharp publiDapper UpsertHi, I see in the docs that there is a function called BulkMerge. I have a table called Products withHow can i use ASP.NET CORE Identity with JWTHello guys i'm using Identity Package for authentication,and i want to implement JWT TOKEN to my autProblem with Pokemon Game for schoolHello, I have a problem while creating a pokemon battle game as a school project and I can't figure Dapper problemThis is my code. I'm trying to bulk insert products from csv to my Products table. Unfortunatelly I ✅ would like help to fix my timer for windows formsHi, I’m in college and am working on my final project, I’m experiencing an issue with my timer (“noHello! İ want open form in/on console app. ? how, pls help meVisual Studio 2010 (dont say why you use 2010)Splitting a large class and problems with a field needed in multiple classes as a resultSo one of my classes got too big, so I decided to split it off into multiple classes. But there is a