Yesterday I decided to fiddle around with MS Visio for Enterprise Architects database modelling tools. After drawing up and validating a pretty straight-forward use case i created a new Database Model Diagram Template from visio. After telling Visio to use the Sql Server ODBC driver I got all the Sql...

I just killed a System.StackOverflowException that occured when calling the GetChanges() method on my typed Dataset. I have a couple of tables in the typed dataset that are defined with self relations to represent hierarchies in the data. This relation is also defined in the XSD schema of the typed dataset...

Yup. That's right. You've been a good boy (or girl) and annotated your typed dataset XSD with codegen:nullValue attributes to instruct the codegenerator in how to handle DBNull values. And you actually thought the MSDataSetGenerator would care? Well it does, if you add the minOccurs="0" aswell. Otherwise...

Ever wondered how to construct multitable DataSets in a proper manner? Whether to use one dataadapter or several? Just found this one on MSDN: Navigation Multiple Related Tables in an ADO.NET Dataset To make it even better use Annotations in the XSD file to improve the syntax of the generated code. Explained...

Andres stepped up quickly with some hints to my previous blogentry . I tried out the ADO.NET Powertoys which contained several features. Because it was poorly documented, and I just needed one of the features, I think I'll wait for a later release. I could have given DeKlarit a shot, but I simply like...

Roy found the xsd tool recently and got the typed datasets to scale . I still don't like them. What is really the difference in beeing dependant on the xsd schema than a dll reference? If you do the Service Oriented approach on this problem you'll come down to what Clemens and Steve predicates these...

Another exiting Java based project is going .NET. I've done a lot of reading on persitance frameworks and OR mapping lately and Hibernate is definately getting a go. Firstly in Java, but hopefully the guys at the NHibernate project can get something going aswell.. Read more at Edgar Sanchez's blog Still...