Browse Blog Posts by Tags

All Tags » Data Access » Visual Studio .NET 2005 (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Musings on the database formerly known as Sql Everywhere

The IM volume I received today about the Rollback to SqlCE issue was enough to border on overwhelming. Between PMs and some lazy SOB CRM guy trying to get me to do all his work for him, it was hard focusing on work today. (And seriously, if you are a CRM professional, telling me you don't know how...

Posted to The Coding Cuckoo by William on Wed, Nov 1 2006
Filed under: Filed under: Compact Framework, Data Access, Visual Studio .NET 2005, Coding Techniques
Transferring data around with ADO.NET 2.0 - SqlBulkCopy

I'm working at a client on a data migration and found some results that were surprising. I expected there to be a difference but not one quite this large... Synopsis of Problem: Right now I'm working on a rather complex migration from a bunch of disparate data sources into a consolidated Sql Server database...

Posted to The Coding Cuckoo by William on Sat, Aug 26 2006
Filed under: Filed under: Data Access, Visual Studio .NET 2005, Coding Techniques
Using the SqlConnectionStringBuilder to guard against Connection String Injection Attacks

One new object in the ADO.NET 2.0 Library worth taking a look at is the SqlConnectionStringBuilder . Considering how late it is in the game, you are probably aware of the dangers of Sql Injection Attacks . One the off chance you aren't, let me throw in my two cents and recommend that you familiarize...

Posted to The Coding Cuckoo by William on Sun, Jan 15 2006
Filed under: Filed under: Data Access, .NET General, Visual Studio .NET 2005
Pimping RowState in ADO.NET 2.0

There are two new methods for the DataRow object in ADO.NET 2.0 that haven't gotten much coverage but can be quite useful. The two methods are SetAdded and SetModified . I consider myself to be an ADO.NET afficionado and until last week, I wasn't aware of these (yes, lame on my part). I was eating lunch...

Posted to The Coding Cuckoo by William on Sat, Jan 14 2006
Filed under: Filed under: Data Access, .NET General, Visual Studio .NET 2005
SqlBulkCopy

Kim just got a new Media Center PC and I loaded the latest Visual Studio 2005 bits on it. Got a little frustrated with XPath so I took a little while away to see what's going on with the ADO.NET 2.0 Library. When I had played with the SqlBulkCopy before, I'm not sure if I just missed it or if they weren...

Posted to The Coding Cuckoo by William on Sun, Aug 21 2005
Filed under: Filed under: Data Access, Visual Studio .NET 2005
System.Data.FillLoadOption

System.Data.FillLoadOption is one of the cool new features of the ADO.NET 2.0 SqlDataAdapter. In the new framework, we have a lot more control over the inner workings of the DataAdapter and hopefully it will shed it's stereotype of being a “Black Box”. Below is the basic workings of it -...

Posted to The Coding Cuckoo by William on Fri, Jul 29 2005
Filed under: Filed under: Data Access, .NET General, Visual Studio .NET 2005
Oracle 10g Lite ADO.NET Adapter

Ok, so I read about it on Mike's as well as the Compact Framework Team but I sure can't find it anywhere. I'm probably just having a case of idiocy flare up, but I've been trying to find it for 30 minutes now. If you know where I can grab it, please let me know.

Posted to The Coding Cuckoo by William on Mon, Jul 18 2005
Filed under: Filed under: Compact Framework, Data Access, Visual Studio .NET 2005
System.Transactions/TransactionScope in ADO.NET 2.0 B2

Even though he's a real jerk when it comes to hooking a brotha up with a Cobra, Sahil is the man and this post in particular kicks a33. Especially the example content ;-)

Posted to The Coding Cuckoo by William on Thu, Apr 28 2005
Filed under: Filed under: Data Access, Visual Studio .NET 2005
Structured Exceptions in ADO.NET 2.0/Yukon

Well, tonight I just pretty much finished up the first chapter of one of the two books I'm working on . Anyway, one of the Chapters I'm wriitng is on the T-SQL Enhancements and I got to wondering. How are Exceptions that you raise in T-SQL handled from the client side. My first guess was that “It...

Posted to The Coding Cuckoo by William on Thu, Apr 21 2005
Filed under: Filed under: Data Access, Visual Studio .NET 2005
What's wrong with this Transaction?

I've seen this come up in newsgroups quite a bit and figured that although it's not exactly hot news, it's worth mentioning. Let's say that you have a DataSet and you want your updates to work transactionally [meaining that they all succeed or fail together]. It's been a while since I've come across...

Posted to The Coding Cuckoo by William on Fri, Apr 15 2005
Filed under: Filed under: Data Access, Visual Studio .NET 2005, Coding Techniques
Typed DataSet Enhancements in ADO.NET 2.0

One other really nice thing about the 2.0 Framework is the enhancements with DataSets. Going to the designer, you can actually drag out a DataTable object and then add columns to it. I know this seems like a total “Duhh” feature, but previously, I think that creating typed datasets was pretty...

Posted to The Coding Cuckoo by William on Tue, Mar 29 2005
Filed under: Filed under: Data Access, Visual Studio .NET 2005
Yukon Induced Insomnia

Since I bought my http://www.selectcomfort.com - it's hard to really describe the friggin difference. I really can't describe it. About 4 weeks ago I was telling one of my co-workers that I was really lucky we have such flexible schedules b/c if I actually had to be at work at 8:00, I'd be in a lot of...

Posted to The Coding Cuckoo by William on Tue, Mar 29 2005
Filed under: Filed under: Data Access, Visual Studio .NET 2005
The Welcomed Demise of Access

It's only Monday and it's already been one of those weeks... Anyway, I needed to just come home and distract myself but my ADD was kicking in hard. If you are unfamiliar with ADD - it's a fancy term “I can't f***cking concentrate on anything and my brain feels like it's going to explode because...

Posted to The Coding Cuckoo by William on Mon, Feb 7 2005
Filed under: Filed under: Data Access, .NET General, Visual Studio .NET 2005
http://www.everythingado.net

Well, I finally bit the bullet and purchased my site from Brinkster. I'm going to be hosting blogs for a few of my disaffected DNJ friends - but well, due to the nature of the site - I'm not handing them out to everyone - If I know you, or you can convince me your not a dork, or if you're a dork and...

Posted to The Coding Cuckoo by William on Sun, Jan 30 2005
Filed under: Filed under: News, Humor, Compact Framework, Data Access, MVP Stuff, Me, .NET General, Visual Studio .NET 2005, Coding Techniques, Mindless Babbling
Requests for Content

I've finally started to get a little free time these days and I'm going to be doing some quality Travelling in the next few weeks - if you're interested in something in particular, I'm taking requests. Anything ADO.NET, Anything Compact Framework, (Not that I'm qualified on these two - but I'll give...

Posted to The Coding Cuckoo by William on Sun, Jan 23 2005
Filed under: Filed under: Compact Framework, Data Access, Remoting, MVP Stuff, .NET General, Visual Studio .NET 2005, Coding Techniques
BinaryFormatter in ADO.NET 2.0

This is hardly hot off of the press, but I had a few questions about it and figured I'd post it. There is a new RemotingFormat property w/ DataSets in ADO.NET 2.0 - and depending on how you are trying to work things, the differences can be profound. Note that when I use 10 records, the XML version is...

Posted to The Coding Cuckoo by William on Sun, Jan 23 2005
Filed under: Filed under: Data Access, Remoting, Visual Studio .NET 2005, Coding Techniques
The Middle Tier isn't going anywhere.

Sahil turned me on to Kiss the Middle-tier Goodbye with SQL Server Yukon . I thought this was the Onion . Look, I'm not dogging XML or Yukon - I love them both, but this is pure nonsense. Here are a few of the Limitations mentioned in the article: XML can't be casted to text or ntext. An XML column can...

Posted to The Coding Cuckoo by William on Mon, Jan 17 2005
Filed under: Filed under: News, Data Access, Visual Studio .NET 2005
Data Design Time Changes Beta1 to Beta2 from the VB.NET Team

Definitely looks interesting...

Posted to The Coding Cuckoo by William on Fri, Jan 14 2005
Filed under: Filed under: Data Access, .NET General, Visual Studio .NET 2005
SqlConnectionStringBuilder

You know, working with connection strings has never been 'hard' but it's always been a pain in the ass- especially when you know all the information but you don't remember the exact order. This is hardly the most impressive thing I've come across in ADO.NET 2.0 - but I really like it - and if you're...

Posted to The Coding Cuckoo by William on Mon, Jan 3 2005
Filed under: Filed under: Data Access, .NET General, Visual Studio .NET 2005
DataSet.GetDataReader() in ADO.NET 2.0

Originally I was having some trouble using .NextResult with nested while Reader.Reads() in the middle of it. http://msmvps.com/williamryan/archive/2004/12/11/23376.aspx that was giving me the trouble. Alas, thanks to my friend Sahil - I got it running. using (SqlConnection cn = new SqlConnection(ConnectString...

Posted to The Coding Cuckoo by William on Sat, Dec 11 2004
Filed under: Filed under: Data Access, Visual Studio .NET 2005

Page 1 of 2 (27 items) 1 2 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.