system.data.sqlite

相关标签：javascript jquery android 多少钱 iPhone

How do I create and persist a SQLite DB from scratch in code using System.Data.SQLite and C#?

I have a datab开发者_如何学Goase creation tool and am creating a database from scratch. This is done the same way as mentioned Here. It creates a temporary DB and I can add data to it.[详细]

2023-04-12 17:14 分类：问答
Error : "Cannot set commandtext while a datareader is active" with ExecuteNonQuery()

I listen a data stream and store data as insert statements in a ConcurrentQueue and insert the data with bulk insertion using a System.Threading.Timer with an interval of 1000 . The whole scenario run[详细]

2023-04-09 01:00 分类：问答
Can I use sqllite with a mySQL backup file?

If i wanted to use a mySQL database offline, could i download it from a server and SELECT from it when i am offline? That way I could us开发者_JS百科e the version on the server when online, and use th[详细]

2023-04-03 04:25 分类：问答
What is a mixed mode assembly?

I am looking at the System.Data.SQLite download page, and it lists mixed mode assembly for .NET 4 and a regular (I assume).My project that is going to use this library is all .NET 4 which will be comp[详细]

2023-04-01 21:22 分类：问答
Starting an NServiceBus Host project throws an error when trying to setup the SQLite DB for sagas

The Init() method on my IWantCustomInitialization implementor is public void Init() { NServiceBus.Configure.With()[详细]

2023-04-01 15:19 分类：问答
sqlite: Fastest way to get all rows (consecutive disk access)

I want to read all rows in a table using system.data.sqlite. As I have a very bi开发者_开发技巧g Table (>450GB, with > 6 billion rows) I want to be sure that sqlite will use consequtive disk access. A[详细]

2023-03-31 00:30 分类：问答
In memory database wrapper for system.data.sqlite

I am using system.data.sqlite for in memory testi开发者_运维问答ng, and i wanted to know if any of you got a link or knowledge for a open source project that simply create database and tables ?[详细]

2023-03-29 09:29 分类：问答
Problem with SQLiteConnection in C# WPF

I am developing a C# WPF project with an embedded SQLite Database. I have used SQLite before without problems but for some reason when I call:[详细]

2023-03-26 09:39 分类：问答
SQLite: 'Unable to open the database file' exception with transaction with multiple commands

I have the following (simplified) code: IDbConnection connection = new SQLiteConnection(GetConnectionString());[详细]

2023-03-20 19:43 分类：问答
How to know when/what exceptions are thrown by System.Data.Sqlite objects?

I\'m having trouble finding out, for the Sqlite.Net data provider (System.Data.Sqlite.dll) (new development has forked here), what exceptions are thrown by the various classes and their methods. I kno[详细]

2023-03-14 22:21 分类：问答