473,326 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Linq or not Linq

I am a bit conservative type and usually give some time for technology to
mature before starting to try it.
Today my question is Linq. To start using it or not.

So here is the voting questions.

1. It speeds up development. Yes or No?
2. It makes programs easier to code and read. Yes or No?
3. Perfomance is the same (or comparable) comparing Linq with MsSql and
ADO.NET

Thanks.
George.

Nov 4 '08 #1
4 2508
On 4 Nov, 16:35, "George" <noem...@comcast.netwrote:
I am a bit conservative type and usually give some time for technology to
mature before starting to try it.
Today my question is Linq. To start using it or not.

So here is the voting questions.

1. It speeds up development. Yes or No?
2. It makes programs easier to code and read. Yes or No?
3. Perfomance is the same (or comparable) comparing Linq with MsSql and
ADO.NET

Thanks.
George.
1)It definatly speeds up development time. Reason being that you are
writing queries in c#, which more developers are familiar with and
they get executed on the database
2)Makes coding easier to read, if writtn correctly and documented
3)I have several apps in productions with Linq and havent noticed any
perfromance problems. Saying that you do need to pay attention to how
you write your queries (just as you would if you were writing direct
sql)

I would say, go for it. Linq really is very useful
Nov 4 '08 #2
<snip />
1. It speeds up development. Yes or No?
maybe
2. It makes programs easier to code and read. Yes or No?
maybe
3. Perfomance is the same (or comparable) comparing Linq with MsSql and
maybe

Go to the blogs to find and read about what "maybe" really implies as like
every other construct LINQ has a sweet spot where its use has been
discovered to be well suited for the task.

Nov 4 '08 #3
there are 3 general linq libraries

Linq for objects (IEnumerable):

this is a great replacement for the bad performing foreach. Not only is it
faster, but gives a full query language for seaching and joinging
collections. you should switch.

Linq for Xml:

coding here is probably simpler than dom and xpath coding. the performance
seem to be close to using compiled xpaths, and it uses an xmlreader under the
covers. there is less Linq code to write, and its probably (for those that
know linq) easier to read. look at switching.

Linq for SQL

this is a library that takes a compiled linq parse tree and converts to
dynamic sql at runtime. it you are doing dynamic sql, this may be a good
replacement, but should not replace stored procedures or calling prepared
statements. there are also sql features that can not be accessed from linq to
sql.
-- bruce (sqlwork.com)
"George" wrote:
I am a bit conservative type and usually give some time for technology to
mature before starting to try it.
Today my question is Linq. To start using it or not.

So here is the voting questions.

1. It speeds up development. Yes or No?
2. It makes programs easier to code and read. Yes or No?
3. Perfomance is the same (or comparable) comparing Linq with MsSql and
ADO.NET

Thanks.
George.

Nov 4 '08 #4

"Hillbilly" <so******@somewhere.coma écrit dans le message de news:
uq*************@TK2MSFTNGP05.phx.gbl...
<snip />
>1. It speeds up development. Yes or No?
maybe
>2. It makes programs easier to code and read. Yes or No?
maybe
>3. Perfomance is the same (or comparable) comparing Linq with MsSql and
maybe

Go to the blogs to find and read about what "maybe" really implies as like
every other construct LINQ has a sweet spot where its use has been
discovered to be well suited for the task.
What if in the blogs they say "maybe, maybe, maybe, go to some experts
forums and ask those who use it everyday"?

?
Nov 5 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Dave Johnson | last post by:
Greetings, i want to be able to use linq new technology with sql server. the senario i am not able to do so far is as follow: 1- i program with linq 2- be able to generate and manipulate...
4
by: cj | last post by:
Can I use LINQ in VB .Net 2008 to get to a Visual FoxPro Table? I've seen demos of it with SQL Server but they've used it with a server browser and I don't think that'd work when I need to see VFP...
9
by: =?Utf-8?B?cmF1bGF2aQ==?= | last post by:
Hi all: after reading different places/sites about linq... I ran into these questions: 1. What framework do we need to run linq ? (does it depend on what version of visual studio we have?) how...
0
by: =?Utf-8?B?SHlwZXJjb2Rlcg==?= | last post by:
I'm encountering some strange behavior after deploying a ASP.net 3.5 website to production, i'm unable to reproduce these in my dev environment. This error seems to occur very randomly but it's...
4
by: =?Utf-8?B?RXJpYyBGYWxza2Vu?= | last post by:
We’re storing our main entity in an insert only table which stores the history of past revisions, but we’re facing problems with storing this history as LINQ will only update the entity, and...
14
by: thj | last post by:
Hi, I was wondering what you guys are using and why? LINQ to SQL or NHibernate? Thanks in advance, Tommy
9
by: Cirene | last post by:
I'm about to begin a brand new, big, ASP.NET project (using 3.5 .net fw), VS 2008. I'm using MySQL as the backend (customer request.) I have absolutely no experience with LINQ and/or the Entity...
3
by: =?Utf-8?B?UGF1bCBQcmV3ZXR0?= | last post by:
I'm attempting to use LINQ to insert a record into a child table and I'm receiving a "Specified cast is not valid" error that has something to do w/ the keys involved. The stack trace is: ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.