-
Notifications
You must be signed in to change notification settings - Fork 1
Performing SQL queries
Eros Stein edited this page Jan 8, 2017
·
1 revision
To execute SQL queries we use the method ExecuteQuery<T>(string query, SqlParameters[] parameters)
.
Example:
using (var ctx = new AppContext(new AppConfiguration()))
{
var query = ctx.ExecuteQuery<string>(
"SELECT Column_Name FROM MYDB.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @param",
new SqlParameter("@param", "tbDbVersion"));
dbVersion = query.FirstOrDefault();
}