コード例 #1
0
        public static List <SqlScript> DeleteByPKScript(this iPrimaryKey obj, string paramchar)
        {
            Type      type      = obj.GetType();
            SqlScript sqlscript = new SqlScript();

            string where = "";
            deletesql(type, paramchar, obj, ref where, ref sqlscript.dbparameters);
            if (type.Name.IndexOf('`') > 0)
            {
                sqlscript.sql = $"DELETE FROM {type.Name.Remove(type.Name.IndexOf('`')).Replace("PK_","")} WHERE {where}";
            }
            else
            {
                sqlscript.sql = $"DELETE FROM {type.Name.Replace("`1", "").Replace("PK_", "")}  WHERE {where}";
            }
            return(new List <SqlScript>()
            {
                sqlscript
            });
        }