Questions tagged [dapper-plus]
12 questions
6
votes
1 answer
Is SqlBulkCopy still faster than Dapper?
I found an article by Sam Saffron on bulk inserting with Dapper (That annoying insert problem getting data into the db using dapper) where he ends the article with the statement:
For example, if you need an ultra fast way to insert lots of stuff…
toadflakz
- 7,764
- 1
- 27
- 40
5
votes
1 answer
Error when Dapper Bulk. "You must explicity set the Provider"
I'm making a synchronization application, from Firebird to SQL Server.
And I'm using BulkInsert from Dapper Plus.
var fbClient = new FirebirdConnect();
using (var source = fbClient.GetConnection())
{
if (source.State == ConnectionState.Closed)
…
Pedro Franco
- 1,926
- 1
- 15
- 37
1
vote
1 answer
DapperPlus and Oracle, know which row is throwing an error when inserting to DB
We are currently facing an issue with our code, which is used to push thousands (sometimes more) of entries in our database at a time.
The technologies we are using for this are :
C#
Entity Framework (latest version)
Oracle 12c
Dapper Plus (latest…
user3399
- 235
- 2
- 11
0
votes
1 answer
Dapper.Plus BulkInsert exception Invalid Object when Object exist
Trying to insert records using Dapper.Plus Bulk Insert operation for SQL database following their guide.
I can create my List and add my results to it so it is populated. But then I am catching an Inner Exception: Invalid object name…
Frank M
- 1,379
- 9
- 18
0
votes
1 answer
Dapper .net, Bulk insert, how to enforce referencial integrity, when inserting master and detail table simultaneusly
I am doing bulk insert into a SQL table using Dapper plus. I am facing challenge in maintaining referential integrity between master table and detail table.
Here is the code.
var userName = Environment.UserName;
…
santubangalore
- 796
- 1
- 12
- 25
0
votes
0 answers
How to configure multiple keys combined with bulkMerge using DapperPlus?
I'm using Dapper plus to migrate data from DB to DB.
I use bulkMerge to insert and update the number of records data.
In this case I have a table with multiple keys like UserId, RoleId as a combined key
The code like this
The multiplePrimaryKey is…
jack.pop
- 683
- 2
- 6
- 21
0
votes
1 answer
Dapper-Plus BulkInsert - How to return number of rows affected?
In Dapper-Plus, is there a way to return the number of rows affected in the database? This is my code:
using (SqlConnection connection = new SqlConnection(Environment.GetEnvironmentVariable("sqldb_connection")))
{
…
solarissf
- 1,199
- 2
- 23
- 58
0
votes
1 answer
Dapperplus add round to bulkinsert
We switched from dapper to dapper plus for performance in bulk inserts.
Now I am converting all the existing queries but I found some functionality that I apparently cannot do with dapper plus (or I don't know how yet)
In my previous query I round…
kevingoos
- 3,785
- 4
- 36
- 63
0
votes
1 answer
Dapper.plus get tablename and key column name from DapperPlusManager
I'm using Dapper.Plus with DapperPlusManager to map objects from database.
I map my class like this:
DapperPlusManager.Entity()
.Key(order => order.OrderID)
.Table("zzz.customers");
I would like to receive the table name and the column…
Sheinar
- 362
- 3
- 14
0
votes
1 answer
Why Dapper faster than Dapper plus?
Given a simple test:
Using Dapper:
for (int i = 0; i < 10000; i++)
{
Connection.Execute("UPDATE User SET Name = 'Max'");
}
The duration of this operation is as follows measured with a StopWatch:
RunTime 00:00:37.51 Duration: 00:00:37.5150734…
Rans
- 569
- 7
- 14
0
votes
1 answer
Dapper Bulk Delete how to report progress
I am using Dapper Plus to do a bulk insert using a query from another table my question is here how does one report progress. As you see I am using the background worker process to run my code which works fine however as the bulk delete method does…
Dave
- 233
- 2
- 12
-1
votes
1 answer
Error handling with Dapper Plus BulkInsert
I am using BulkInsert API from Z.Dapper.Plus and it is failing due to bad data and the message is Parameter value '7900000000000000.000000' is out of range.
Is there a way to improve this message so I can readily identity the specific row causing…
Anand
- 1,387
- 2
- 26
- 48