in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » sqlite (RSS)

Browse by Tags

  • Reading large quantity of data

    Hello, currently I am working on a solution to speed up calculations on a sqlite database via .net-application. First i have run through the data by two for-loops which resulted in round about 3.600.000 queries to the database which does not provide feasible results in an acceptable time. To speed up...
    Posted to Entity Framework (Forum) by cblack on 12-08-2011

  • Any Crystal Reports working example with SQLite?

    Is there ANY working example of Crystal Reports and SQLite.. i cannot find any...everybody talks about ADO bla bla bla..but nobody gives any real working example... or just some code to connect CR with SQlite.
    Posted to General (Forum) by tommix on 12-05-2011

  • SQLite database locked by using .NET Control (PasswordRecovery)

    Here is my situation with code and error. I have developed an asp.net 4.0 website with SQLite3 using visual studio and I am running TechInfoSystems.Data.SQLiteProvider.dll and System.Data.SQLite.dll 1.0.66.0 I just recently decided I can't save passwords for user login as clear text in my database...
    Posted to General (Forum) by JohnJohn on 11-12-2011

  • Re: Data Provider for SQLite ERRORS

    can anyone solve this issues? I also having the same problem with vs2005(full editions) and it show exactly like that image connection string and same error
    Posted to Designer (Forum) by rose on 10-28-2011

  • Re: Attempt to write to read-only database

    Hi seinkraft! I have this same problem. I tried what you are suggesting and it doesn't help - have you seen any other ways to fix this problem since? (you were saying to run the app using SQLite as admin to alleviate the "attempt to write to readonly database". I did set my app as run as...
    Posted to General (Forum) by thready on 10-17-2011

  • SQLITE_MAX_COLUMN

    Question: Is it possible to create a table with more than 3000 columns/fields? I found this environment variable (SQLITE_MAX_COLUMN) on the SQLite site and it appears to default to 2000 max columns but can be changed. However, I don't see any reference to it here so I'm not sure how to change...
    Posted to How To (Forum) by precipios on 09-12-2011

  • Re: strange Error : no such table : ....

    The same error occurs in the following situation too: You add .db file to your project. Then when you run your c# project with debugger, empty db. file is copied into bin/debug folder of the project folder. Your running application looks for tables in the empty database and returns error: "no such...
    Posted to General (Forum) by sevenkul on 08-19-2011

  • Re: How to Insert Blob Image to SQLite in C#

    Hi there, After reading the forum ran into your question and decided to take it up as a small project and thus writing an article. I created a WinForm appi based on C# - .NET4.0 - System.Data.SQLite 1007000 (.net provider) with an embedded SQLite database. And I want to share the source code.. So here...
    Posted to How To (Forum) by Kribo on 05-15-2011

  • Sorting

    Apologies if I am posting to the wrong forum, but I am hoping I can get an answer to my question. I want to sort a column in ascending order, but I want null values to sort to the bottom. A simple ORDER BY ColumnA ASC sorts the column in ascending order with null vales appearing on top. The following...
    Posted to How To (Forum) by Caureus on 04-10-2011

  • Model-first ADO.NET POCO objects with SQLite

    A demo code sample showing this can be found at Microsoft Code Samples I've created this demo using tips & tricks gathered from all around the web.
    Posted to Entity Framework (Forum) by MennoSquared on 03-31-2011
Page 1 of 9 (82 items) 1 2 3 4 5 Next > ... Last ยป
Powered by Community Server (Commercial Edition), by Telligent Systems