Solved

Linq with simple class not Linq to SQL

Posted on 2013-06-21
3
471 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
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…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

707 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