Solved

Linq with simple class not Linq to SQL

Posted on 2013-06-21
3
466 Views
Last Modified: 2013-06-26
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??
0
Comment
Question by:moosetracker
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
Sammy earned 500 total points
ID: 39265600
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.
0
 
LVL 1

Author Comment

by:moosetracker
ID: 39266647
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..
0
 
LVL 27

Assisted Solution

by:Sammy
Sammy earned 500 total points
ID: 39278065
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
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question