Solved

Linq with simple class not Linq to SQL

Posted on 2013-06-21
3
462 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
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…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

762 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now