C# (CSharp) ITenant.RunSql示例

示例#1

 public void DeleteAllDocuments(ITenant factory)
 {
     factory.RunSql(
         $"delete from {Parent.Table.QualifiedName} where {DocumentMapping.DocumentTypeColumn} = '{Alias}'");
 }

示例#2

文件： EventDocumentStorage.cs 项目： rightteaminc/marten

 public void TruncateDocumentStorage(ITenant tenant)
 {
     tenant.RunSql($"truncate table {Events.DatabaseSchemaName}.mt_streams cascade");
 }

示例#3

文件： EventMapping.cs 项目： yovannyr/marten

 public void DeleteAllDocuments(ITenant factory)
 {
     factory.RunSql($"delete from mt_events where type = '{Alias}'");
 }

示例#4

文件： DocumentMapping.cs 项目： jdasilva/marten

        void IDocumentMapping.DeleteAllDocuments(ITenant factory)
        {
            var sql = "truncate {0} cascade".ToFormat(Table.QualifiedName);

            factory.RunSql(sql);
        }

示例#5

        public void TruncateDocumentStorage(ITenant tenant)
        {
            var sql = "truncate {0} cascade".ToFormat(TableName.QualifiedName);

            tenant.RunSql(sql);
        }

示例#6

 public void TruncateDocumentStorage(ITenant tenant)
 {
     tenant.RunSql(
         $"delete from {_parent.TableName.QualifiedName} where {SchemaConstants.DocumentTypeColumn} = '{_mapping.Alias}'");
 }