Changing a Database Schema Programmatically
Hi guys,
first post here, have read many articles, including ones that relate to my question
Just wondering if there is a class or wrapper class or 3rd party control that any of you may have heard of that will allow me to change a databases schema through .NET.
From what I understand, Dataset.WriteXMLSchema or .ReadXMLSchema don't actually send any changes back to the database. N e ideas on how I would do this like this
[pseudo code]
Open Database
if(Database.GetCurrentSchema() != NewSchema)
{
Database.CurrentSchema = NewSchema
}
Database.Update()
[/pseudo code]
or is that impossible, do I need to do the ExecuteNonQuery("ALTER TABLE...... stuff?
Thanks for the help Impulse 7