Browse by Tags

Correcting Full Text Search !! like Sql server text Full search

Hi Im ALI AL SALAMI I write very desktop applications with SQlite and C# or VB.NET and I Understand that it's very nice but in full text search has problem Table1 C1 ----------------- MySchool School OurSchool in sql server if you have : MySchool and search SELECT * FROM Table1 WHERE CONTAINS ( C1...

Posted to Feature Requests (Forum) by ali_salami on 08-03-2010
How to read related data from 2 tables into an aggregated collection?

Hello, I have 2 methods. Both work fine for its own... What I want is to retrieve with SQLite the SchoolclassCodeID from every pupil with the current SchoolclassCode and its SchoolclassCodeID property. In the end I want to return a ObservableCollection where each SchoolclassCode object has 1 ObservableCollection...

Posted to How To (Forum) by Eluim on 07-18-2010
Help: Database optimization

I'm new to SQLite, but have been working with SQL Server and mySQL for several years so I'm not entirely blind on this. Trying to figure out how to cut down on the execution time of a query. Situation is I have a relatively simple table, with three fields: id (integer, primary key), hash (text...

Posted to How To (Forum) by MRTrevorF on 05-13-2010
using linq with sqlite.net on mono/linux

Hi, I have a winform.net application that uses Linq to SqlServerCe. The model classes in it have been generated using sqlmetal. I intend to migrate my application to be able to run on linux using the mono runtime. I decided to go ahead with SQLite since SqlServerCe is not planned to be supported in Mono...

Posted to General (Forum) by nutsiepully on 05-12-2010
Re: Embedding System.Data.SQLite.dll in the program executable

Is it possible to embed it as an embedded resource subscirbe to assemblyresolve event and return dll loaded from the executable? Something like this: Embedding one dll inside another as an embedded resource and then calling it from my code It works for normal .Net dlls but I am not sure whether it will...

Posted to General (Forum) by mcnamara on 04-25-2010
.net 4.0 support?

I wanted to convert a couple of my projects using the provider to 4.0 to use some new features, but when I did so, the ctor of my ObjectContext subclass started failing with: System.ArgumentException: The specified store provider cannot be found in the configuration, or is not valid. I'm assuming...

Posted to Feature Requests (Forum) by jamesmanning on 04-18-2010
Changing name of sqlite dll 'System.Data.SQLite.dll'

I am using sqlite dll version 1.0.65.0. i am looking to change original sqlite dll name 'System.Data.SQLite.dll' to 'System.Data.abc.dll' . i made changes in full project along with UnsafeNativeMethods.cs file. but i am getting exception 'unable to find entry point named 'sqlite3_open_interop'...

Posted to General (Forum) by davidjones on 04-12-2010
Re: How can i rename System.Data.SQLite.dll to System.Data.abc.dll and then use ?

I am facing same problem

Posted to General (Forum) by vikaskardode on 03-31-2010
Changing name of sqlite dll

I have original sqlite dll version 1.0.65.0. I am looking to change dll name 'System.Data.SQLite.dll' to 'System.Data.abc.dll' for security purpose I made following changes in SQLite source files AssemblyInfo.cs,UnsafeNativeMethods.cs but i am getting exception 'unable to load entry...

Posted to General (Forum) by vikaskardode on 03-27-2010
Getting Error 'Object reference not set to an instance of an object'

I installed sqlite version 1.0.65.0 & allows design time support to visual studio. sqlite data provider is displayed in server explorer of .net framework. but whenever i try to create new box file or try to browse box file ,shows error 'Object reference not set to an instance of an object'...

Posted to Designer (Forum) by vikaskardode on 03-27-2010

Page 1 of 7 (65 items) 1 2 3 4 5 Next > ... Last »