A much needed SchemaHelper class

6 Comments

• You write that this functionality does exist for sqlconnection ...
  
  could you provide an example?
  
  What i want to achieve is to get a dataset that holds the complete database in memory.
  

• You could of let the helper get a connection thus having it support any kind of db
  
  
  
  Great idea!
  
  
  
  It fits great to my dbHelper that auto-generage insert,update,delete statments.
  
  
  
  

• I have run the exact thing, But I am getting a Blank Page, wonder whats wrong !
  

• Thanks for this great helper. I think when you actually add a relation in CreateDataRelation the parameters ara inverted and should read
  
  ds.Relations.Add(RelationName,PKDataCol,FKDataCol);
  
  cheers!
  

• Well, it's all nice and easy for the OleDB provider, but the Sql Server support it's just useless. In order to build the relations within the dataset you still have to querry the database metadata instead of using the SqlConnection.
  

• The SqlHelper class should be modified in order to include multiple column foreign keys