[sqlite] Sql.Data.Sqlite BLOB Type Mismatch

2017-02-27 Thread Steven M. McNeese
I have a table called Media with an Media column of type BLOB and a Annotation column of type BLOB. The Annotation column can be null. In my Winform application, I have a dataset for this table and the Media and Annotation columns are defined as System.Byte[]. When I fill the dataset, I am

[sqlite] Sql.Data.Sqlite BLOB Type Mismatch

2017-02-27 Thread Steven M. McNeese
I have a table called Media with an Media column of type BLOB and a Annotation column of type BLOB. The Annotation column can be null. In my Winform application, I have a dataset for this table and the Media and Annotation columns are defined as System.Byte[]. When I fill the dataset, I am

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

2016-02-09 Thread Steven M. McNeese
On Tue, Feb 9, 2016 at 1:47 PM, Steven M. McNeese < steven.mcneese at freedomparkdfw.com> wrote: > Chris, > > What are you using in c# for SQLite back end? Ado.net? Linq. Let me > know and I can help you with bulk inserts. > > Sent from my iPhone > > > On Feb 9

[sqlite] C# + SQLite - Update/Insert using Transaction is slower than without.

2016-02-09 Thread Steven M. McNeese
Chris, What are you using in c# for SQLite back end? Ado.net? Linq. Let me know and I can help you with bulk inserts. Sent from my iPhone > On Feb 9, 2016, at 6:13 AM, Chris Prakoso wrote: > > Ok. Got it. > Now, if only I can get that multiple rows update working on my code, it > would be

[sqlite] Slow real world performance - Any suggestions please (warning long)

2015-07-03 Thread Steven M. McNeese
This was one of the best posts I have read. No ego chest thumping - just knowledgable experience-based support. Shout out to the original poster for providing such thorough detail on the problem. This allowed the experts to quickly identify the possible problem and potential solution quickly.

[sqlite] AUTOINC vs. UUIDs

2015-05-20 Thread Steven M. McNeese
gt; At 23:24 20/05/2015, you wrote: > >> On Wed, May 20, 2015 at 2:20 PM, Steven M. McNeese >> wrote: >> > Often times people will use GUIDs as primary keys when different systems >> > need to generate >> > rows and then merge together. Like an appli

[sqlite] AUTOINC vs. UUIDs

2015-05-20 Thread Steven M. McNeese
Often times people will use GUIDs as primary keys when different systems need to generate rows and then merge together. Like an application that works with offline clients that push the data to a server when the connect. However there are other ways of accomplishing the same thing. Sent from

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-04 Thread Steven M. McNeese
Another admin tool is SQLite Analyzer by Kraslabs.com -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jim Callahan Sent: Monday, May 4, 2015 9:14 AM To: General Discussion of SQLite Database

[sqlite] building SQLite DLL with Visual C++

2015-04-27 Thread Steven M. McNeese
Jay, I don't do VB.Net development but it should be very similar to C#.Net in Visual Studio. Try to follow these steps: 1. Add a Dataset Item to your project. I think you have done this already. Once the Dataset is created you will get a blank dataset designer, create a connection to your

[sqlite] Upgraded 1.0.60.0 to 1.0.96.0

2015-04-24 Thread Steven M. McNeese
-users-bounces at mailinglists.sqlite.org] On Behalf Of Steven M. McNeese Sent: Friday, April 24, 2015 10:30 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Upgraded 1.0.60.0 to 1.0.96.0 Thanks for the reply Joe. I am just confused at what could be different between the two version

[sqlite] Upgraded 1.0.60.0 to 1.0.96.0

2015-04-24 Thread Steven M. McNeese
, April 24, 2015 10:23 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Upgraded 1.0.60.0 to 1.0.96.0 Steven M. McNeese wrote: > > I upgraded an old .net 2.0 application using System.Data.Sqlite v > 1.0.60.0 to .net 4.5 using system.data.sqlite v 1.0.96.0. The >

[sqlite] Thoughts on storing arrays of complex numbers

2015-04-24 Thread Steven M. McNeese
I would serialize to JSON and store as a string. -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Drago, William @ CSG - NARDA-MITEQ Sent: Friday, April 24, 2015 8:38 AM To: General Discussion of

[sqlite] Upgraded 1.0.60.0 to 1.0.96.0

2015-04-24 Thread Steven M. McNeese
I upgraded an old .net 2.0 application using System.Data.Sqlite v 1.0.60.0 to .net 4.5 using system.data.sqlite v 1.0.96.0. The application started getting random exceptions when access the database using datsets. See below: System.ApplicationException: Cannot access a disposed object.