Browse by Tags

Musings on the database formerly known as Sql Everywhere

Published Thu, Nov 2 2006 2:53 | William

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...

Filed under: Compact Framework, Data Access, Visual Studio .NET 2005, Coding Techniques

Transferring data around with ADO.NET 2.0 - SqlBulkCopy

Published Sat, Aug 26 2006 17:03 | William

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...

Filed under: Data Access, Visual Studio .NET 2005, Coding Techniques

Using the SqlConnectionStringBuilder to guard against Connection String Injection Attacks

Published Sun, Jan 15 2006 14:40 | William

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...

Filed under: Data Access, .NET General, Visual Studio .NET 2005

Pimping RowState in ADO.NET 2.0

Published Sat, Jan 14 2006 23:20 | William

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...

Filed under: Data Access, .NET General, Visual Studio .NET 2005

SqlBulkCopy

Published Sun, Aug 21 2005 17:33 | William

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...

Filed under: Data Access, Visual Studio .NET 2005

System.Data.FillLoadOption

Published Fri, Jul 29 2005 21:18 | William

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...

Filed under: Data Access, .NET General, Visual Studio .NET 2005

Oracle 10g Lite ADO.NET Adapter

Published Mon, Jul 18 2005 22:36 | William

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...

Filed under: Compact Framework, Data Access, Visual Studio .NET 2005

System.Transactions/TransactionScope in ADO.NET 2.0 B2

Published Thu, Apr 28 2005 14:24 | William

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 ;-)

Filed under: Data Access, Visual Studio .NET 2005

Structured Exceptions in ADO.NET 2.0/Yukon

Published Thu, Apr 21 2005 1:47 | William

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...

Filed under: Data Access, Visual Studio .NET 2005

What's wrong with this Transaction?

Published Fri, Apr 15 2005 18:55 | William

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...

Filed under: Data Access, Visual Studio .NET 2005, Coding Techniques

Typed DataSet Enhancements in ADO.NET 2.0

Published Tue, Mar 29 2005 17:24 | William

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...

Filed under: Data Access, Visual Studio .NET 2005

Yukon Induced Insomnia

Published Tue, Mar 29 2005 1:49 | William

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...

Filed under: Data Access, Visual Studio .NET 2005

The Welcomed Demise of Access

Published Mon, Feb 7 2005 20:14 | William

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...

Filed under: Data Access, .NET General, Visual Studio .NET 2005

http://www.everythingado.net

Published Sun, Jan 30 2005 2:45 | William

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...

Filed under: News, Humor, Compact Framework, Data Access, MVP Stuff, Me, .NET General, Visual Studio .NET 2005, Coding Techniques, Mindless Babbling

Requests for Content

Published Sun, Jan 23 2005 22:40 | William

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...

Filed under: Compact Framework, Data Access, Remoting, MVP Stuff, .NET General, Visual Studio .NET 2005, Coding Techniques

BinaryFormatter in ADO.NET 2.0

Published Sun, Jan 23 2005 22:26 | William

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...

Filed under: Data Access, Remoting, Visual Studio .NET 2005, Coding Techniques

The Middle Tier isn't going anywhere.

Published Mon, Jan 17 2005 22:54 | William

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...

Filed under: News, Data Access, Visual Studio .NET 2005

Data Design Time Changes Beta1 to Beta2 from the VB.NET Team

Published Fri, Jan 14 2005 18:55 | William

Definitely looks interesting...

Filed under: Data Access, .NET General, Visual Studio .NET 2005

SqlConnectionStringBuilder

Published Mon, Jan 3 2005 19:03 | William

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...

Filed under: Data Access, .NET General, Visual Studio .NET 2005

DataSet.GetDataReader() in ADO.NET 2.0

Published Sat, Dec 11 2004 15:32 | William

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...

Filed under: Data Access, Visual Studio .NET 2005