G
Guest
In Ado.Net 1.1 I could only have one open sqldatareader on a sqlcommand. Is
that still the case in ADO.Net 2.0?
that still the case in ADO.Net 2.0?
M
Miha Markic [MVP C#]
AFAIK yes, but you have many readers on the same connection (MARS).
G
Guest
Miha,
I understand your answer, but what is AFAIK and MARS
Thanks.
--
Arne Garvander
Certified Geek
I understand your answer, but what is AFAIK and MARS
Thanks.
--
Arne Garvander
Certified Geek
Miha Markic said:
M
Miha Markic [MVP C#]
AFAIK: as far as I knowArne Garvander said:
MARS: Multiple Active Result Sets (check .net help files).
--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
S
Sahil Malik [MVP C#]
Miha is right, but when using MARS you have to be careful of a zillion
things. Check out my book for a detailed treatise on it - or if you want
the short story - don't base your architecture that requires you to have
multiple datareaders on one connection. MARS has 2 good uses
a) Cleaner code in a very specific situation - updating on the same
connection based on what you read.
b) Updating on the same isolation level as the select was done on.
Besides that - stay away from MARS.
- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
----------------------------------------------------------------------------
things. Check out my book for a detailed treatise on it - or if you want
the short story - don't base your architecture that requires you to have
multiple datareaders on one connection. MARS has 2 good uses
a) Cleaner code in a very specific situation - updating on the same
connection based on what you read.
b) Updating on the same isolation level as the select was done on.
Besides that - stay away from MARS.
- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
----------------------------------------------------------------------------
Arne Garvander said:
G
Guest
Dear expert,
Do you know why hierarchical recordsets, that we had in ADO, doesn't exist
in ADO.Net.
I am currently supporting a legacy app that is sprinkled with SHAPE commands.
--
Arne Garvander
Certified Geek
Do you know why hierarchical recordsets, that we had in ADO, doesn't exist
in ADO.Net.
I am currently supporting a legacy app that is sprinkled with SHAPE commands.
--
Arne Garvander
Certified Geek
Sahil Malik said:
W
William \(Bill\) Vaughn
Ah, perhaps because the hierarchies are handled much more cleanly by the
DataSet class?
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
DataSet class?
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Arne Garvander said:
S
Sahil Malik [MVP C#]
I'm not an expert , you're the expert.
Secondly, the kind of support you want .. well .. it just isn't there. I
know it sucks, but sorry I don't work for Microsoft so I can't say "Yeah
we'll make it work".
The SHAPE command was hella sucky anyway, I'm personally not too sad to see
it go. But yeah it sucks when you get sucked into a legacy app where someone
thought "WOW thats a cool thing to use, just like MARS".
SM
, you're the expert.Secondly, the kind of support you want .. well .. it just isn't there. I
know it sucks, but sorry I don't work for Microsoft so I can't say "Yeah
we'll make it work".
The SHAPE command was hella sucky anyway, I'm personally not too sad to see
it go. But yeah it sucks when you get sucked into a legacy app where someone
thought "WOW thats a cool thing to use, just like MARS".
SM
Arne Garvander said:
G
Guest
Oh, I thought you had to be an expert to publish a book. I guess any old
sucker can write a book and pay for its printing.
I don't mind getting sucked in to a legacy app, if I get a pay raise every
time. I don't mind straightening out bad apps and making them into good apps.
I do mind old junky computers. The only thing you can do with them is to
apply some dynamite.
--
Arne Garvander
Certified Geek
sucker can write a book and pay for its printing.
I don't mind getting sucked in to a legacy app, if I get a pay raise every
time. I don't mind straightening out bad apps and making them into good apps.
I do mind old junky computers. The only thing you can do with them is to
apply some dynamite.
--
Arne Garvander
Certified Geek
Sahil Malik said:I'm not an expert
Secondly, the kind of support you want .. well .. it just isn't there. I
know it sucks, but sorry I don't work for Microsoft so I can't say "Yeah
we'll make it work".
The SHAPE command was hella sucky anyway, I'm personally not too sad to see
it go. But yeah it sucks when you get sucked into a legacy app where someone
thought "WOW thats a cool thing to use, just like MARS".
SM
Arne Garvander said:
S
Sahil Malik [MVP C#]
Uhh yeah I did write a book, and it's doin' pretty well based on it's
reviews - but that still doesn't make me an expert, heck I'm not even a
certified geek yet.
I LOVE your attitude, are you looking for a job?
- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________
reviews - but that still doesn't make me an expert, heck I'm not even a
certified geek yet.
I LOVE your attitude, are you looking for a job?
- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________
Arne Garvander said:Oh, I thought you had to be an expert to publish a book. I guess any old
sucker can write a book and pay for its printing.
I don't mind getting sucked in to a legacy app, if I get a pay raise every
time. I don't mind straightening out bad apps and making them into good
apps.
I do mind old junky computers. The only thing you can do with them is to
apply some dynamite.
--
Arne Garvander
Certified Geek
Sahil Malik said:I'm not an expert
Secondly, the kind of support you want .. well .. it just isn't there. I
know it sucks, but sorry I don't work for Microsoft so I can't say "Yeah
we'll make it work".
The SHAPE command was hella sucky anyway, I'm personally not too sad to
see
it go. But yeah it sucks when you get sucked into a legacy app where
someone
thought "WOW thats a cool thing to use, just like MARS".
SM
message
G
Guest
You can always try the nerd exam.
--
Arne Garvander
Certified Geek
--
Arne Garvander
Certified Geek
Sahil Malik said:Uhh yeah I did write a book, and it's doin' pretty well based on it's
reviews - but that still doesn't make me an expert, heck I'm not even a
certified geek yet.
I LOVE your attitude, are you looking for a job?
- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________
Arne Garvander said:Oh, I thought you had to be an expert to publish a book. I guess any old
sucker can write a book and pay for its printing.
I don't mind getting sucked in to a legacy app, if I get a pay raise every
time. I don't mind straightening out bad apps and making them into good
apps.
I do mind old junky computers. The only thing you can do with them is to
apply some dynamite.
--
Arne Garvander
Certified Geek
Sahil Malik said:I'm not an expert
Secondly, the kind of support you want .. well .. it just isn't there. I
know it sucks, but sorry I don't work for Microsoft so I can't say "Yeah
we'll make it work".
The SHAPE command was hella sucky anyway, I'm personally not too sad to
see
it go. But yeah it sucks when you get sucked into a legacy app where
someone
thought "WOW thats a cool thing to use, just like MARS".
SM
message
Dear expert,
Do you know why hierarchical recordsets, that we had in ADO, doesn't
exist
in ADO.Net.
I am currently supporting a legacy app that is sprinkled with SHAPE
commands.
--
Arne Garvander
Certified Geek
:
Miha is right, but when using MARS you have to be careful of a zillion
things. Check out my book for a detailed treatise on it - or if you
want
the short story - don't base your architecture that requires you to
have
multiple datareaders on one connection. MARS has 2 good uses
a) Cleaner code in a very specific situation - updating on the same
connection based on what you read.
b) Updating on the same isolation level as the select was done on.
Besides that - stay away from MARS.
- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
----------------------------------------------------------------------------
message
Miha,
I understand your answer, but what is AFAIK and MARS
Thanks.
--
Arne Garvander
Certified Geek
:
AFAIK yes, but you have many readers on the same connection (MARS).
--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
message
In Ado.Net 1.1 I could only have one open sqldatareader on a
sqlcommand.
Is
that still the case in ADO.Net 2.0?