linq?

[reven]

anyone using linq with a database? ive used linq with sql server 2005 quite a lot, but i cant expect everyone to install sql server to use a plugin. so was hoping someone has any recommendations for a portable database (like sqlite) that supports linq?

i really dont want to give up using queries like

Code:

Video v = (from v in db.Videos where v.ID = id select v);

its just so much nicer than handling the connection/command/datareader etc

[steveum]

SQLite recently announced support for Entity Framework. It is the technology that allows LINQ to work with ADO.NET providers. See http://sqlite.phxsoftware.com

[reven]

has anyone had any success with this? sqlite required the entity framework, but i could never get it to connect to the database using this.

i tried using sqlce and had similar issues, so i was wondering if any one had any success using linq and a portable database (using sql server 2005/8 would be easiest solution for me, but cant really expect everyone to install sql server now can we )

[bgowland]

(using sql server 2005/8 would be easiest solution for me, but cant really expect everyone to install sql server now can we )

I work on the principle of adapting my code for the end user and not expecting the end user to adapt to my code. I went for SQLite for the dvbt radio plugin because that's what gbpvr uses.

Then again I don't use linq but I'm quite happy with the drag'n'drop design of datasets and tableadapters in Visual Studio - 99% of the code is auto-generated for me and I can tweak it easily in design view.

Cheers,
Brian

[reven]

Then again I don't use linq but I'm quite happy with the drag'n'drop design of datasets and tableadapters in Visual Studio - 99% of the code is auto-generated for me and I can tweak it easily in design view.

believe me once you've used linq you never want to go back to datasets.

im trying to use sqlite or sqlce (both just a file and no installation needed by end user) but as i said, having trouble getting them to work with the entity framework.