There are three methods described:
1) using SQL Statements will be difficult and i guess that the performance will be terrible if i submit a CREATE TABLE followed by a million INSERT INTO SQL Statements.
2) using the ITableDefinition interface: is this even possible in .NET? Can i add rows to the table?
3) using ADOX: seems to be the only reasonable method to create and fill a SAS dataset. Has anybody tried that method yet?
Am i missing something here? Is there really no simple solution provided by SAS to update or create a new SAS dataset when you are using SAS/IT with the SAS data providers in the .NET Framework?
I realize your application is not running within EG, but you could use a similar approach. That is, use the SAS IOM OLE DB provider to read the data, and use the SAS Workspace LanguageService to update the data table using PROC SQL UPDATE.