Posted
by Deveti Putnik
on Stack Overflow
See other posts from Stack Overflow
or by Deveti Putnik
Published on 2010-05-28T08:09:18Z
Indexed on
2010/05/28
8:21 UTC
Read the original article
Hit count: 176
What are the pro's and con's of using "Linq to SQL" and core ADO.NET technology for access databases?
© Stack Overflow or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
Remembering MySQL could use the instruction "limit" to indicate where I was starting my result set and how many wanted to have included.
Select * FROM Users Limit [start], [Length]
How can I do this in LinqToSql
>>> More
as seen on West-Wind
- Search for 'West-Wind'
Ran into an odd behavior today with a many to many mapping of one of my tables in LINQ to SQL. Many to many mappings aren’t transparent in LINQ to SQL and it maps the link table the same way the SQL schema has it when creating one. In other words LINQ to SQL isn’t smart about many to many mappings…
>>> More
as seen on Dot net Slackers
- Search for 'Dot net Slackers'
tweetmeme_url = 'http://alpascual.com/blog/comparing-linq-to-sql-vs-the-classic-sqlcommand/';tweetmeme_source = 'alpascual';When you are coming from using SqlCommand and SqlConnection is difficult to move to another library for your database needs. For those people still in the limbo to make the decision…
>>> More
as seen on Dot net Slackers
- Search for 'Dot net Slackers'
tweetmeme_url = 'http://alpascual.com/blog/comparing-linq-to-sql-vs-the-classic-sqlcommand/';tweetmeme_source = 'alpascual';When you are coming from using SqlCommand and SqlConnection is difficult to move to another library for your database needs. For those people still in the limbo to make the decision…
>>> More
as seen on Dot net Slackers
- Search for 'Dot net Slackers'
In this article we will be taking a look at the new LINQ to SQL Profiler from HibernatingRhinos. This tool gives you a view into the goings on of LINQ to SQL. Not only does it allow you to see the SQL that is generated by your LINQ queries but it also shows you information about your connections…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm starting a new project based on ASP.NET and Windows server.
The application is planned to be pretty big and serve large amount of clients pulling and updating high freq. changing data.
I have previously created projects with Linq-To-Sql or with Ado.Net.
My plan for this project is to use VS2010…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm starting a new project based on ASP.NET and Windows server.
The application is planned to be pretty big and serve large amount of clients pulling and updating high freq. changing data.
I have previously created projects with Linq-To-Sql or with Ado.Net.
My plan for this project is to use VS2010…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm currently in the process of creating a Silverlight 3 data driven application. To access the database, 2 common approaches are used: RIA Services and ADO.NET Data Services. Does anyone have any guidance on when/why to choose each approach? Here is what I've gathered from my research / experience…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
We have an ado.net dataservices 1.0 call that is being passed to a [WebGet] service operation as a batch through BeginExecuteBatch.
Everything works perfectly on our development server - we have the project configured to use IIS instead of the cassini web server to make it as close to our production…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am using C# to write a method that returns the following information about a table:
column names, column types, column sizes, foreign keys.
Can someone point me in the right direction on how to accomplish this ?
>>> More
