public static DbCommand ConvertStoreCommandToDbCommand(DatabaseEngine db, StoreCommand storeCommand)
{
Regex regex = new Regex(@"\{(\d+)\}");
string cmdText = regex.Replace(storeCommand.CommandText, db.GetParameterPrefix() + "Para$1");
DbCommand dbCmd = db.DatabaseSession.Database.GetSqlStringCommand(cmdText);
for (int i = 0; i < storeCommand.Parameters.Length; i++)
{
SqlParameter par = new SqlParameter("Para" + i.ToString(), storeCommand.Parameters[i]);
db.AddParameter(dbCmd, par);
}
return(dbCmd);
}
