Comparison of Linq to Sql and Orasis Generated Data Access Code

home
linq
view story

6 Kicks

Comparison of Linq to Sql and Orasis Generated Data Access Code(orasissoftware.com)

submitted by neophytos(60) 3 years ago

This is a very good and fair comparison. What does not show here is the difference in performance which I suspect LinQ to SQL must be slower.

11 comments |category: Linq |Views: 303
Tweet

tags: LINQ another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

More who kicked this story...

Comments:

posted by johnsheehan(4785) 3 years ago 0

Oh how I wish I could delete this. Not only is it a pointless article, the description here on DNK makes performance claims not even discussed in the article.

posted by DamienG(1405) 3 years ago 0

There is nothing here about performance - there isn't even a show as to what TSQL LINQ to SQL is generating. Poor summary.

[)amien

posted by DamienG(1405) 3 years ago 0

Hmm. Amusingly many of the Orasis API calls take lists of objects to insert/delete rather than a single instance so there is an overhead of creating a new list for every call even when you only want to send one item.

[)amien

posted by ahmadadnan(30) 3 years ago 0

@johnsheehan: "There is nothing here about performance "

The title of the article does not emphasise the performance factor, it is a comparison of the API to call Orasis and Linq to SQL code, both of which follow the Object Oriented Data Access paradigm. The Developer only accesses the layer through pure dot net objects and it returns pure dot net objects. The difference is that through using Orasis the Data Access API is actually generated through the tool and you can see all the code that is generated. The code is absolutely free of any third party dependencies and is pure ADO.NET 2.0 code. It executes much faster compared to other technologies that generate SQL statements internally and use reflecton to populate the layers such as Linq to SQL, NHibernate, etc. You will be seeing articles about performance comparisons in the future. You can read more about performance in this article here: http://forums.orasissoftware.com/comments.php?DiscussionID=2&page=1#Item_0 which talks about other factors including performance.

@Damien: "Hmm. Amusingly many of the Orasis API calls take lists of objects to insert/delete rather than a single instance so there is an overhead of creating a new list for every call even when you only want to send one item. "

The reason for usings Lists is to keep the method signature to update and retrieve a single object versus multiple objects consisent. You could pass a list of ten objects, all which need to be inserted, updated or deleted or just one. The overhead of creating a List is negligible compared to the gain in code and API consistency. Also, the loss of performance overhead in LINQ to SQL due to configuration, reflection, and unoptimized generated SQL is way more costly than creating a List.

posted by johnsheehan(4785) 3 years ago 0

"You will be seeing articles about performance comparisons in the future" then submit those articles in the future with accurate descriptions. You provided an inaccurate description for this article by including the performance claim.

Your company continues to act like a spammer. First the StackOverflow spam disguised as questions (which you can deny happening all you want), then the coordinated kicking incident here and now this. I will never try or buy your products because I just can't trust your company, and you apparently have no desire to stop acting the way you do.

posted by pjacobs(375) 3 years ago 0

johnsheehan - you need to get a life. you have badgered the orasis guys enough. this isn't your personal site. it's a place to discuss .net related topics. and for some reason you have tried very to put your foot on their throats since day one.

I bought their product and I want to discuss it along with competing technologies. If you don't want to then go away or just shut up. Rest assured that if this wasn't the internet and we were in a room discussing it and you acted this way I would beat you until the police came. keep that in mind if you want to post more negative attacks against other well meaning developers.

posted by pjacobs(375) 3 years ago 0

Minnesota isn't that far away... Just get on a southwest flight and I will meet you for lunch.

posted by neophytos(60) 3 years ago 0

Waooo, they still keep you around, even after this?? ... johnsheehan are you for real? Since you never downloaded the technology then why do you have such a strong opinion? At this time you have lost credibility to the eyes of every possible blogger on this site. Like I stated before you should not be allowed to be here but I hope after these comments you made nobody will ever take you seriously ( I am sure nobody does anyway). Again something that you should know and I will state here in public, we will not advertise here unless you are removed from this site. I will personally seek that you will get removed from here for ever ( Unless you are hooked in somehow in a strange way but again you do not strike me as a business man). I mentioned this to you before but you did not take me seriously. But we will see I guess.

posted by b_russell(0) 3 years ago 0

@orasis: It's great if orasis is making a tool for the .NET developer community. But do you really think it's smart to offend that community by spamming on DNK and StackOverflow? And by threats of physical violence? I mean how old are you? 12?? Do you really think you can convince potential customers to buy your product with _that_ behavior?

posted by pjacobs(375) 3 years ago 0

I do not have anything to do with orasis. I simply own their product and wanted to write about it. Just like so many others have written about nhibernate or linq to sql.

And no one has spammed anything. Spam isn't posting an article on a .net community board about a .net product or service. Spam is posting "get your viagra here" on it. I don't see anyone saying it is spam when a post about Castle Windsor, NHibernate, linq to sql, silverlight, or any other .net technology gets posted. It is pretty simple... It isn't spam.

posted by SemiNormal(2) 3 years ago 0

@neophytos: Your post was alright until your childish threats to not advertise until a person who badmouthed your product is removed. Do you treat your customers in the same unprofessional manor?

@pjacobs: Spam is not just posting "get your viagra here". Spam can also be posting a link to your product and disguising it as a news article.
Castle , NHibernate, linq to sql, and silverlight are not commercial products, so the same rules of spam do not apply.

Most Active Users

What's this?