DataReaders, LINQ to XML and Range Generation

I’m doing a bunch of database / XML stuff @ work, so I decided to use to VS08 beta 2 so I can use LINQ. For reasons I don’t want to get into, I needed a way to convert arbitrary database rows, read using a SqlDataReader, into XML. LINQ to SQL was out, since the code has to work against arbitrary tables (i.e. I have no compile time schema knowledge). But XLinq LINQ to XML helped me out a ton. Check out this example:

const string ns = "{http://some.sample.namespace.schema}";

while (dr.Read())
{
    XElement rowXml = new XElement(ns + tableName,
        from i in GetRange(0, dr.FieldCount)
        select new XElement(ns + dr.GetName(i), dr.GetValue(i)));
}

That’s pretty cool. The only strange thing in there is the GetRange method. I needed an easy way to build a range of integers from zero to the number of fields in the data reader. I wasn’t sure of any standard way, so I wrote this little two line function:

IEnumerable<int> GetRange(int min, int max)
{
    for (int i = min; i < max; i++)
        yield return i;
}

It’s simple enough, but I found it strange that I couldn’t find a standard way to generate a range with a more elegant syntax. Ruby has standard range syntax that looks like (1..10), but I couldn’t find the equivalent C#. Did I miss something, or am I really on my own to write a GetRange function?

Update: As expected, I missed something. John Lewicki pointed me to the static Enumerable.Range method that does exactly what I needed.

This entry was posted by DevHawk on August 17, 2007. It was posted in Development. It was tagged ADO.NET, Database, LINQ, Ruby and XML.

Comments:

AFAIK there's no standard way of doing it, but you could add an extension method to 'Int32' public static IEnumerable RangeFromZero(this int number) { for (int i = 0; i < number; i++) { yield return i; } } and have something like from i in dr.FieldCount.RangeFromZero() or from i in dr.FieldCount.Range(0) with a 'Range' extension method, which is the same that you wrote but a little cooler ;).
This comment was posted by Andres Aguiar on August 17, 2007 at 5:56 PM.
Even better is to add an Extension method to IDataReader to make it enumerable of IDataRecord, I mean semantically it is anyway... public static IEnumerable Enumerate(this IDataReader reader) { using (reader) { while (reader.Read()) yield return reader; } } Then you can do from r in reader.Enumerate() from i in GetRange(...) etc....
This comment was posted by Alex James on August 17, 2007 at 10:04 PM.
I believe System.Linq.Enumerable.Range() is exactly the same as your GetRange method.
This comment was posted by John Lewicki on August 18, 2007 at 5:22 AM.
Another minor improvement: XNamespace ns = "http://some.sample.namespace.schema"; while (dr.Read()) { XElement rowXml = new XElement(ns + tableName, from i in Enumerable.Range(0, dr.FieldCount) select new XElement(ns + dr.GetName(i), dr.GetValue(i))); }
This comment was posted by Anonymous on August 21, 2007 at 10:16 AM.

Categories

Tags

Series

Disclaimer

The information in this weblog is provided "AS IS" with no warranties, and confers no rights. This weblog does not represent the thoughts, intentions, plans or strategies of my employer. It is solely my opinion. Inappropriate comments will be deleted at the authors discretion.