|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SqlDataReader 2.0In Ado.Net 1.1 I could only have one open sqldatareader on a sqlcommand. Is
that still the case in ADO.Net 2.0? -- Arne Garvander Certified Geek But failed my Nerd exam AFAIK yes, but you have many readers on the same connection (MARS).
-- Show quoteMiha Markic [MVP C#] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in message news:CCF49F79-B85C-4DC5-8794-9A9DAFD6E56B@microsoft.com... > 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? > -- > Arne Garvander > Certified Geek > But failed my Nerd exam Miha,
I understand your answer, but what is AFAIK and MARS Thanks. -- Show quoteArne Garvander Certified Geek "Miha Markic [MVP C#]" wrote: > 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/ > > "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in message > news:CCF49F79-B85C-4DC5-8794-9A9DAFD6E56B@microsoft.com... > > 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? > > -- > > Arne Garvander > > Certified Geek > > But failed my Nerd exam > > > "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in message AFAIK: as far as I knownews:BE44786F-ADAE-4A25-BA67-BC7AFEA8FC2A@microsoft.com... > Miha, > I understand your answer, but what is AFAIK and MARS MARS: Multiple Active Result Sets (check .net help files). :-) -- Show quoteMiha Markic [MVP C#] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ > Thanks. > -- > Arne Garvander > Certified Geek > > > > "Miha Markic [MVP C#]" wrote: > >> 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/ >> >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in >> message >> news:CCF49F79-B85C-4DC5-8794-9A9DAFD6E56B@microsoft.com... >> > 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? >> > -- >> > Arne Garvander >> > Certified Geek >> > But failed my Nerd exam >> >> >> 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 ---------------------------------------------------------------------------- Show quote "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in message news:BE44786F-ADAE-4A25-BA67-BC7AFEA8FC2A@microsoft.com... > Miha, > I understand your answer, but what is AFAIK and MARS > Thanks. > -- > Arne Garvander > Certified Geek > > > > "Miha Markic [MVP C#]" wrote: > >> 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/ >> >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in >> message >> news:CCF49F79-B85C-4DC5-8794-9A9DAFD6E56B@microsoft.com... >> > 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? >> > -- >> > Arne Garvander >> > Certified Geek >> > But failed my Nerd exam >> >> >> 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. -- Show quoteArne Garvander Certified Geek "Sahil Malik [MVP C#]" wrote: > 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 > ---------------------------------------------------------------------------- > > > > "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in message > news:BE44786F-ADAE-4A25-BA67-BC7AFEA8FC2A@microsoft.com... > > Miha, > > I understand your answer, but what is AFAIK and MARS > > Thanks. > > -- > > Arne Garvander > > Certified Geek > > > > > > > > "Miha Markic [MVP C#]" wrote: > > > >> 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/ > >> > >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in > >> message > >> news:CCF49F79-B85C-4DC5-8794-9A9DAFD6E56B@microsoft.com... > >> > 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? > >> > -- > >> > Arne Garvander > >> > Certified Geek > >> > But failed my Nerd exam > >> > >> > >> > > > Ah, perhaps because the hierarchies are handled much more cleanly by the
DataSet class? -- Show quote____________________________________ 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" <ArneGarvan***@discussions.microsoft.com> wrote in message news:FA6CA55D-52A6-4802-B371-66DADAF8CFAB@microsoft.com... > 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 > > > > "Sahil Malik [MVP C#]" wrote: > >> 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 >> ---------------------------------------------------------------------------- >> >> >> >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in >> message >> news:BE44786F-ADAE-4A25-BA67-BC7AFEA8FC2A@microsoft.com... >> > Miha, >> > I understand your answer, but what is AFAIK and MARS >> > Thanks. >> > -- >> > Arne Garvander >> > Certified Geek >> > >> > >> > >> > "Miha Markic [MVP C#]" wrote: >> > >> >> 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/ >> >> >> >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in >> >> message >> >> news:CCF49F79-B85C-4DC5-8794-9A9DAFD6E56B@microsoft.com... >> >> > 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? >> >> > -- >> >> > Arne Garvander >> >> > Certified Geek >> >> > But failed my Nerd exam >> >> >> >> >> >> >> >> >> 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". :) SMShow quote "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in message news:FA6CA55D-52A6-4802-B371-66DADAF8CFAB@microsoft.com... > 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 > > > > "Sahil Malik [MVP C#]" wrote: > >> 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 >> ---------------------------------------------------------------------------- >> >> >> >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in >> message >> news:BE44786F-ADAE-4A25-BA67-BC7AFEA8FC2A@microsoft.com... >> > Miha, >> > I understand your answer, but what is AFAIK and MARS >> > Thanks. >> > -- >> > Arne Garvander >> > Certified Geek >> > >> > >> > >> > "Miha Markic [MVP C#]" wrote: >> > >> >> 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/ >> >> >> >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in >> >> message >> >> news:CCF49F79-B85C-4DC5-8794-9A9DAFD6E56B@microsoft.com... >> >> > 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? >> >> > -- >> >> > Arne Garvander >> >> > Certified Geek >> >> > But failed my Nerd exam >> >> >> >> >> >> >> >> >> 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. -- Show quoteArne Garvander Certified Geek "Sahil Malik [MVP C#]" wrote: > 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 > > > > > "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in message > news:FA6CA55D-52A6-4802-B371-66DADAF8CFAB@microsoft.com... > > 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 > > > > > > > > "Sahil Malik [MVP C#]" wrote: > > > >> 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 > >> ---------------------------------------------------------------------------- > >> > >> > >> > >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in > >> message > >> news:BE44786F-ADAE-4A25-BA67-BC7AFEA8FC2A@microsoft.com... > >> > Miha, > >> > I understand your answer, but what is AFAIK and MARS > >> > Thanks. > >> > -- > >> > Arne Garvander > >> > Certified Geek > >> > > >> > > >> > > >> > "Miha Markic [MVP C#]" wrote: > >> > > >> >> 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/ > >> >> > >> >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in > >> >> message > >> >> news:CCF49F79-B85C-4DC5-8794-9A9DAFD6E56B@microsoft.com... > >> >> > 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? > >> >> > -- > >> >> > Arne Garvander > >> >> > Certified Geek > >> >> > But failed my Nerd exam > >> >> > >> >> > >> >> > >> > >> > >> > > > 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 don't mind getting sucked in to a legacy app, if I get a pay raise every I LOVE your attitude, are you looking for a job?> time. I don't mind straightening out bad apps and making them into good > apps. - Sahil Malik [MVP] ADO.NET 2.0 book - http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx __________________________________________________________ Show quote "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in message news:5855428F-822F-4294-B2E7-AC4BAC69E1CF@microsoft.com... > 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 [MVP C#]" wrote: > >> 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 >> >> >> >> >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in >> message >> news:FA6CA55D-52A6-4802-B371-66DADAF8CFAB@microsoft.com... >> > 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 >> > >> > >> > >> > "Sahil Malik [MVP C#]" wrote: >> > >> >> 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 >> >> ---------------------------------------------------------------------------- >> >> >> >> >> >> >> >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in >> >> message >> >> news:BE44786F-ADAE-4A25-BA67-BC7AFEA8FC2A@microsoft.com... >> >> > Miha, >> >> > I understand your answer, but what is AFAIK and MARS >> >> > Thanks. >> >> > -- >> >> > Arne Garvander >> >> > Certified Geek >> >> > >> >> > >> >> > >> >> > "Miha Markic [MVP C#]" wrote: >> >> > >> >> >> 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/ >> >> >> >> >> >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in >> >> >> message >> >> >> news:CCF49F79-B85C-4DC5-8794-9A9DAFD6E56B@microsoft.com... >> >> >> > 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? >> >> >> > -- >> >> >> > Arne Garvander >> >> >> > Certified Geek >> >> >> > But failed my Nerd exam >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> You can always try the nerd exam.
-- Show quoteArne Garvander Certified Geek "Sahil Malik [MVP C#]" wrote: > 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 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 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" <ArneGarvan***@discussions.microsoft.com> wrote in message > news:5855428F-822F-4294-B2E7-AC4BAC69E1CF@microsoft.com... > > 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 [MVP C#]" wrote: > > > >> 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 > >> > >> > >> > >> > >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in > >> message > >> news:FA6CA55D-52A6-4802-B371-66DADAF8CFAB@microsoft.com... > >> > 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 > >> > > >> > > >> > > >> > "Sahil Malik [MVP C#]" wrote: > >> > > >> >> 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 > >> >> ---------------------------------------------------------------------------- > >> >> > >> >> > >> >> > >> >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in > >> >> message > >> >> news:BE44786F-ADAE-4A25-BA67-BC7AFEA8FC2A@microsoft.com... > >> >> > Miha, > >> >> > I understand your answer, but what is AFAIK and MARS > >> >> > Thanks. > >> >> > -- > >> >> > Arne Garvander > >> >> > Certified Geek > >> >> > > >> >> > > >> >> > > >> >> > "Miha Markic [MVP C#]" wrote: > >> >> > > >> >> >> 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/ > >> >> >> > >> >> >> "Arne Garvander" <ArneGarvan***@discussions.microsoft.com> wrote in > >> >> >> message > >> >> >> news:CCF49F79-B85C-4DC5-8794-9A9DAFD6E56B@microsoft.com... > >> >> >> > 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? > >> >> >> > -- > >> >> >> > Arne Garvander > >> >> >> > Certified Geek > >> >> >> > But failed my Nerd exam > >> >> >> > >> >> >> > >> >> >> > >> >> > >> >> > >> >> > >> > >> > >> > > >  |
|||||||||||||||||||||||
Other interesting topics