Browse by Tags

Re: using Active Record design pattern in C# on an sqlite database

ok. thanks for being honnest. I think there's a lot of crap with ORM out there.esp if you end up wasting hourstrying o understand what the thing does. However, working on an old project a few years ago, I found myself wrinting code that would read db structure and generate php code to do the low...

Posted to How To (Forum) by fourchu on 01-23-2010
using Active Record design pattern in C# on an sqlite database

Hi all, First of all, thanks Robert for this excellent piece of code of yours. I've been a big fan of sqlite for small/medium projects. I've loved using it with ruby & ror. I have a java and mostly php background. I am not a big fan of microsoft products but for some reason i just have to...

Posted to How To (Forum) by fourchu on 01-23-2010
LINQPad Now Supports Sqlite

Joseph Albahari has added Sqlite support to his fabulous LINQPad tool: http://www.linqpad.net/Beta.aspx. It works with databases I've created with System.Data.Sqlite, including encrypted ones! LINQPad also includes Entity Framework support, but I haven't tried it yet with Sqlite. LINQPad is incredibly...

Posted to General (Forum) by epower on 01-11-2010
Re: SQLite support for Silverlight

You can use siaqodb ( http://siaqodb.com) as Silverlight client side database.You can save objects with one line of code and retrieve back via LINQ

Posted to Feature Requests (Forum) by cristoph2009 on 12-12-2009
what simple/robust data access approach can I use in C# Visual Studio 2008?

Hi, What are the current reliable data access approaches that are available in VS2008 using this ADO.net sqlite integration for a small project with only a handful of tables? For example: * base sqlite classes * Dataset / DataAdapter * LINQ (supported?, robust?) * Entity Framework (supported?, robust...

Posted to General (Forum) by callagga on 10-10-2009
LINQ generating inappropriate SQL???

I am trying to use LINQ with System.Data.SQLite (version 1.0.64.0) in VS2008 (no SP), and am unable to insert a row into a table. The code below generates the error I am seeing. Besides the two columns that appear in the code and log, there is one more named CustomerKey which is the integer primary key...

Posted to General (Forum) by Steve Reynolds on 07-23-2009
EF and/or LINQ for Compact Framework

Hello, EF and/or LINQ is supported for Compact Framework? Is there a sample for it? Thanks, Zoltan

Posted to Entity Framework (Forum) by korbai on 06-26-2009
Get "cannot rollback - no transaction active" when trying to use a context on which there was a failure

Hi, First off: Thanks for doing this and making it available for free. I appreciate it. I get a failure when I try to execute context.SaveChanges() (using Entity Framework) A little bit of background: I create a database connect to it via entity framework and sqlite ado.net provider. I cause a failure...

Posted to Entity Framework (Forum) by pwab on 06-25-2009
Entity Framework: Include() not working with a "let" sub query

Hi, I'm having a spot of trouble with the Linq-To-Entities version of SQLite. If I use the "Include()" method to eager fetch a related property, it normally works fine. However, if I include a "let" statement in the query, the "Include()" call is ignored (and this can...

Posted to Bugs (Forum) by trevhunter on 06-01-2009
Is it possible to create a user defined function like MSSQL's scope_identity

I'm busy with a program which is build in C# with LINQ and it works fine as long as I select data but when I'm trying to store data in it I get a SELECT error. Now I've found out this is because of a select query who looks like this SELECT CONVERT(Int,SCOPE_IDENTITY()) AS [value]. My question...

Posted to How To (Forum) by DJohn001 on 03-20-2009

Page 1 of 3 (23 items) 1 2 3 Next >