Wednesday, December 19, 2007

LINQ, and not that Nintendo Elf

So our current design requires us to pull data from either a database or an XML file. Because I am interested in the latest schwag from MS, I thought I would learn about LINQ and see if it could be useful. Our database design requires us to not necessarily know which tables exist on the system. Each tool has a separate logTable and each one of those tables has only one column that we can count on. It is a foreign key to our general log table. In our general log table we have the table name to retrieve detailed information from.
Can we use LINQ for this? It would require Dynamic Table binding and abstract classes, or at least thats what I think after doing a cursory glance at some LINQ faqs. Rick Strahl identified this issue in August and didnt' think it was possible. Luckily, some commenters think it can be done. Here is that link: http://www.west-wind.com/WebLog/posts/134706.aspx I also stumbled onto another site that, honestly, is over my head, but I am trying to figure it out. It is aptly named "Being Ignorant With LINQ To SQL" Here is that link : http://iancooper.spaces.live.com/blog/cns!844BD2811F9ABE9C!397.entry

Ok, that is all I have now. As the day progresses and I keep diving in I will probably add more.

Thursday, December 6, 2007

Not a blogger

I am not a blogger, nor do I have any intention of becoming one. I am planning on using this space as a sort of lessons learned or a reference for myself and others ?maybe? as I take the plunge in .NET 3.5.