what is suitable for Point of sale sytem?LINQ to SQL or ADO.Net?

Question

4.00/5 (1 vote)

See more:

, +

Hi i am new to ORM .I am little confusing about advantages of ADO.NET and LINQ to SQL.What is the very suitable technology for a big Point of sale system? ,The system is using SQL Server as db server , C# .net with framework 3.5 and also have some kind of XML integration.please ,can any one suggest the technology(LINQ to SQL or ADO.NET)?

Posted 27-May-11 9:26am

Thabo@Codeproject

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tarun.K.S · Accepted Answer · 2011-05-27T09:47:00

Solution 2

Have a look at this discussion : http://stackoverflow.com/questions/593808/what-are-the-advantages-of-linq-to-sql[^]

Update :

Regarding performance, Linq to SQL implements <i>Deferred Execution</i> in which the results are only loaded into the memory when requested. Hence it saves Network bandwidth and also minimizes the memory consumption.
Yes Linq to SQL does use the disconnected architecture. Yes it also supports the use of Stored Procedure which is considered as a good practice.
I hope I was able to resolve your queries. :)

Posted 27-May-11 9:47am

Tarun.K.S

Updated 28-May-11 7:22am

v2

Comments

Thabo@Codeproject 27-May-11 16:45pm

Thanks .I have just looked that discussion.The actual problem is i am new to LINQ to SQL.I got some problem while using LINQ to SQL in my application. The confusion is ,using LINQ queries do
have similar performance to accessing data set in ADO .Net?I was thinking both are using disconnected architecture .Am i correct?Other problem is ,Is their any method to write stored procedures in linq query?

Tarun.K.S 28-May-11 13:23pm

Hi Thabo, I have updated the answer to answer your queries.

Thabo@Codeproject 29-May-11 13:54pm

Thanks Tarun. Your explanation resolved my doubt.Thanks again.

Tarun.K.S 29-May-11 13:55pm

You're welcome Thabo. Have a good day. :)

Abhinav S · Accepted Answer · 2011-05-27T09:34:00

Solution 1

There is really nothing to choose between the two (ADO.Net versus LINQ to SQL) in terms of a POS system. I would suggest you pick the one you are more familiar with.

Posted 27-May-11 9:34am

Abhinav S

Updated 27-May-11 9:35am

v2

Comments

Thabo@Codeproject 27-May-11 16:30pm

Thank you.But one question.My system have two application one is workstation application(running on the till) other one is Back offices solution(running on administrator machine)..Does Using LINQ to SQL at the work station application ,make my application to slow?