Execute scripts in the database

[themustela]

Hi!!! I've created some templates, that generate sql server scripts. I would like to know if it is possible to execute this scripts inside MyGeneration, in order not to execute the .sql by myselft.

Thanks!!

[mike.griffin]

On the IDatabase MyMeta interface there is an ExcuteSQL() method I believe, but remember, you can also use ADO.NET directly in your templates too.

[themustela]

Yes, i tried that , i try to use ado.net in a template, but without luck
Can you give me an example please? or a link?

Thanks in advantage!