Tag: ado.net
-
Register for Visual Studio 2010 Beta Exams (.NET 4.0)
Time for (free) Beta Exams again Information can be found from here http://blogs.technet.com/betaexams/archive/2010/03/17/register-for-tools-utilities-2010-beta-exams.aspx Register via http://register.prometric.com For easier reference, exams available are listed below (along with PromoCode) Exam 71-511, TS: Windows Applications Development with Microsoft .NET Framework 4 – 511BC Exam 71-515, TS: Web Applications Development with Microsoft .NET Framework 4 – 515AA Exam 70-513:…
-
MCTS ADO.NET 3.5 Applications results out and passed
A good way to start a day. Just got an email regarding another latest addition to my cert list. Microsoft Certified Technology Specialist : .NET Framework 3.5 ADO.NET Applications [more] The exam I took for this was 71-561 and when going live would become 70-561. I was excited to come up with a new logo…
-
Link: SQL Server 2008: new data types and .Net 2 with and without SP1
Here's an interesting I came across in the recent Simple Talk Newsletter (by Red Gate Software). It talks about issues with new SQL 2008 data types (date/time related) and it's effect on .NET 2.0 datetime data types when SP1 is installed or not. Something to be aware of and one of those times that you're…
-
ADO.NET Review: Multiple Select Queries in one SqlCommand
If you perform multiple select queries inside your stored procedures I believe you actually return all of the result sets to the client. (except when you assign a value to a parameter like SELECT @myVar = [ColumnA] FROM Table1). This is something to be careful of since you might unnecessarily return results sets that you…
-
ADO.NET Review: Multiple Active Result Set (MARS)
Quoting from the SQL Programmability and API Development Team Blog: Multiple Active Result Set or MARS is defined as a new programming interface introduced in SQL Server 2005. It enables multiple result sets to exist at the same time for a given connection. To say it in a simple way, you can make a connection…
-
Issue with System.Transactions, SqlConnection and Timeout
Just recently, a post was made in Microsoft Forums regarding a bug/behavior of Committable Transactions and SqlConnection timeout. The same issue is evident for TransactionScope which was posted in 2006. Good thing there is a fix[more] I have used TransactionScope a number of times including in one of my previous posts on Unit Testing (integration…
-
Link: Entity Framework and ADO.NET Data Services will RTM with Visual Studio 2008 and .NET 3.5 Service Pack 1
The ADO.NET Team has just announced this in their blog. There is no definite release date for SP1 yet though. See the post from the following link: Entity Framework and ADO.NET Data Services will RTM with SP1
-
Unit Testing Data Access with .NET TransactionScope
I was curious how to maintain my database at a consistent state while unit testing (technically integration testing already – but since it uses unit testing framework as they say the lines are terminologies are getting blurry) so I looked around for "database unit testing" write ups. It turns out that [more]mbUnit has [Rollback] which…
-
MDAC, SNAC and ADO.NET (Data Access Technologies)
I've been working with ADO.NET for sometime and so know a thing or two about it but what about MDAC, SNAC? How do they fit in and relate to each other (if at all) Starting off with a few acronyms: MDAC – Microsoft Data Access Components SNAC – SQL Native Client ADO – ActiveX Data…
-
ADO.NET 3.5 MCTS Beta Exam
Just received my MSDN Flash Special Edition regarding Invitation for ADO.NET 3.5 MCTS Exam today. The beta period will run from March 14, 2008 – April 4, 2008 71-561: TS: Microsoft .NET 3.5, ADO.NET Application Development counts as credit towards the following certification(s). Register thru Prometric Promo Code : 561B1 Beta exams are by invitation…