• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

Linq with simple class not Linq to SQL

Will I loose much if I can not use Linq to SQL, but only a simple class of the Table fields with simple get/sets?...

Reason I am asking is I am trying to do a project for VS 2012 Store App,  and it seems it will only use SQLite for a DB rather then CompactSQL or others.. The app store also has added other conditions of needing to be async..

So I only have found one tutorial of using SQLite in a Windows store app with the async, and that uses Linq.. Since I haven't used Linq thought I would learn that, and my course is pushing me to the Linq to SQL..  All other examples for SQLite are for VS2010 or a lower version and could care less about the async requirement. Some of these seem more t-SQl like and I would feel more comfortable using, but if it doesn't use async I can't use.

But as the Video on implementing SQLite does not use Linq to SQL, and since it is not a MS product SQLite is not a choice in VS for either DatabaseExplorer or Linq to SQL.. Other searches says theres a way to get it, but installs of SQLite from these methods do not supply the additional supported features as claimed..

So I have a Video on SQLite in VS using very simple add/upd/delete/select statement examples for Linq with simple class gets/sets for table fields, and I am learning more complex Linq that uses Linq to SQL...   I fear there may be a disconnect and what I am learning I will not be able to use, when simple and complex collide..

Should I worry, or not??
  • 2
2 Solutions
No, you shouldn't worry at all.
Learning linq or anything in that matter should take its time, you learn things as you need to do them.
There are loads of online tutorials for Linq to SQL, LInq to EF and linq in general.
The best thing to do is to learn Linq as the language extension, then you can branch to Linq to SQL or linq to EF.

you can always use EE to post any questions you may have.
moosetrackerAuthor Commented:
Probably why I have not used Linq to date, I had no reason to.. though it seems perhaps if I had known it it would have lightened some very heavy code in my past programs..  

So just so I know what to surf for when I need some answers, is Linq with the tables in very simple class gets/sets  considered Linq to EF or linq in general??

Also what does EE stand for where you say I can post any questions I may have?

Sorry with Linq I am a newbie, so I don't have these acronyms down yet..
EE = experts exchange
Linq is just extension, link to sql is an ORM "object relationship mapping framework"
Linq to EF is the newest ORM made by Microsoft

Hope this helps
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now