Get the result of an sql query?

[janniksam]

Is it possible to get the result of an SQL Query?

I would like to iterate through all my migration scripts (SELECT [Scriptname] FROM [dbo].[_Migrations]), but I can't find a way of getting the result of my ExecuteSqlCommand()-call.