Solved

Linq with simple class not Linq to SQL

Posted on 2013-06-21
3
469 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
c#, datatable, aspx 4 47
Read top line from CSV file 14 56
VS C# how to design libary of functions 7 31
How does this modal gets closed? 6 40
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
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…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

737 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