zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

4 results for: in tag: sqlite

Import data from SQLite to SQL Server with SqlBulkCopy class

I'm trying to transfer the data from SQLite to SQL Server. The schema of target and destination table are just the same:...SQL Server:...CREATE TABLE [dbo].[Shop] ( [ShopID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](128) NOT NULL, [Url] ...
sqlbulkcopy sqlite
asked by Jeffrey Zhao

Connecting to a SQLLite db with SqlBulkCopy

I'm writing a unit test in c# for a function that is responsible for using System.Data.SqlClient.SqlBulkCopy to copy a DataTable to a database server....I use SQLLite for unit tests, and wanted to connect to my SQLLite in memory database with SqlBulkCopy,...
c# sqlbulkcopy sqlite unit-testing
asked by Mattkwish

Problem with Entity Framework extensions .BulkSaveChanges - Saving Guid

I'm using EF extension to do ...BulkSaveChanges..., and I'm using SQLite, everything works perfectly, fast saving, etc. The problem I'm having is that when saving Guids, it's as if ...BulkSaveChanges... is converting the Guids to TEXT first before saving,...
.net-core entity-framework-core sqlbulkcopy sqlite
asked by Mac

EFCore Bulk Insert & SQLite In Memory: no such table: INFORMATION_SCHEMA.COLUMNS"

I'm using ...EFCore BulkExtensions... 2.5.0 with Entity Framework Core 2.2.3 and EFCore.SQLite 2.2.6....I have code like this:...// Repo that throws exception on BulkInsert public class UserRepository { private readonly IDbContextProvider<ReportContext...
c# entity-framework-core in-memory-database sqlbulkcopy sqlite
asked by Philip Pittle

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...