Page 1 of 1

Create Temporary DB with Linq?

Posted: Thu 21 Jan 2010 12:26
by Zero-G.
Hey

Using dotConnect for mySQL.
Is it possible to create and delete temporary tables with LinQ?
Or do I have to make this through the DataReader?

THX

Posted: Thu 21 Jan 2010 13:58
by AndreyR
First of all, you have an opportunity to execute SQL queries using the DataContext.ExecuteCommand method.
You also can use DataContext.CreateDatabase and DataContext.DeleteDatabase to create/delete the whole database corresponding to the context.