Browse by Tags

How to Add a new Property in a Entity?

How to add a property to an entity that is not mapped to the DB. Ex: The entity Person has 2 properties extrapolated from the structure of the DB. The ID, which is the primary key, and Name. I must add a third property, which will be valued in a second time during program execution. If I add a scalar...

Posted to How To (Forum) by abramo on 10-06-2011
.Net 4.0 & SQLite 1007000 sample

I created a .net 4.0 WinForm appi with SQLite embedded and want to share the source code.. So here it is [ MyBlog ] [ Code Project ] So have fun and enjoy...

Posted to How To (Forum) by Kribo on 05-02-2011
VS2010 Pro & SQLite 3.6.23.1

My PC here at work is a Windows 7 64-bit version, but I have this project set to x86. I have my SQLite database displayed in Visual Studio 2010's Server Explorer of a new WinForm Application - so I know I have it installed correctly and I know my tables are there. Now to the code. I tried going into...

Posted to How To (Forum) by jp2code on 02-11-2011
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
Questions from novice getting aquainted with sqlite

Hi, I have decided to rewrite an Access db I wrote several years ago into C# using system.data.sqlite. Other than the Access db and its light VBA coding, my only experience is a C++ class I took a few years ago in college. So, I'm really a beginner, and will have to learn as I go. I came here to...

Posted to General (Forum) by hamyer on 03-15-2010
Basic help - select query result...

Hi, I'm a newbiz in sqlite (and in C#)... and I try to find an answer on google and this fourm before posting. Since some months (when I have time) I try to learn C#. I give myself a goal to learn the language : write a text gui game, I was thinking that a database would be too heavy to manipulate...

Posted to How To (Forum) by nicodevil on 03-08-2010
How to retrieve the last autoincremented ID from a table when using a typed dataset?

[Noob alert!] I constructed a typed dataset inside VS 2008. I am using the prefabricated datadapters to fill and update its tables. How can I retrieve the last autoincremented ID from a table? I understand that in SQL it is:Select last_insert_rowid(). But how do I call this SQL from C# ADO.Net? Thanks...

Posted to How To (Forum) by aner on 01-25-2010
Visual C++2008 Express

Does anyone have a good easy to follow tutorial on getting System.Data.SQLite working with Visual C++ 2008 Express (free edition)? I went through the setup.exe, and added the .lib as a reference to the project, but it doesn't seem to recognize the library. Thanks, Bill using System.Data.SQLite; void...

Posted to How To (Forum) by billgates on 01-17-2010
Help Getting Started

Hi, I am a newbie in regards to System.Data.SQLite and .NET, so bear with me. I can't seem to get System.Data.SQLite even installed correctly. The self-installer completed and everything seemed to be kosher, but nothing seems to be working. In VC# Express, I tried to create a little sample program...

Posted to How To (Forum) by deftonix on 12-22-2009
Insert multiple values in one column that references another's table primary key?

Hi I'm pretty green when it comes down to db relationships so please don't be mad at me if this is a dumb question, i swear i spent 2 days searching for some way to do this and i can't find anything useful, even on google. I have two very simple tables, each has a primary key and a column...

Posted to How To (Forum) by r41n on 09-10-2009

Page 1 of 2 (12 items) 1 2 Next >