public bool Create(MySQLConnector conn) { using (var sb = new MySQLQueryBuilder(SqlPermissions.SQLSafeName)) { var proc = PluginContent.GetResource("TDSM.Data.MySQL.Procedures.Files." + Name + ".sql"); sb.CommandType = System.Data.CommandType.Text; sb.CommandText = proc; return(((IDataConnector)conn).Execute(sb)); } }
public static bool Create(MySQLConnector conn) { using (var sb = new MySQLQueryBuilder(SqlPermissions.SQLSafeName)) { var proc = PluginContent.GetResource("TDSM.Data.MySQL.IsPermitted.sql"); // sb.ProcedureCreate("SqlPermissions_IsPermitted", proc, // new ProcedureParameter("prmNode", typeof(String), 50), // new ProcedureParameter("prmIsGuest", typeof(Boolean)), // new ProcedureParameter("prmAuthentication", typeof(String), 50) // ); sb.CommandType = System.Data.CommandType.Text; sb.CommandText = proc; return(((IDataConnector)conn).Execute(sb)); } }