C# ObjectName.ToString方法代码示例

        protected internal override void BulkCopy(DataTable dt, ObjectName destinationTable, SqlBulkCopyOptions options, int? timeout)
        {
            using (SqlConnection con = EnsureConnection())
            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(
                options.HasFlag(SqlBulkCopyOptions.UseInternalTransaction) ? con : (SqlConnection)Transaction.CurrentConnection,
                options,
                options.HasFlag(SqlBulkCopyOptions.UseInternalTransaction) ? null : (SqlTransaction)Transaction.CurrentTransaccion))
            using (HeavyProfiler.Log("SQL", () => destinationTable.ToString() + " Rows:" + dt.Rows.Count))
            {
                bulkCopy.BulkCopyTimeout = timeout ?? Connector.ScopeTimeout ?? this.CommandTimeout ?? bulkCopy.BulkCopyTimeout;

                foreach (DataColumn c in dt.Columns)
                    bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(c.ColumnName, c.ColumnName));

                bulkCopy.DestinationTableName = destinationTable.ToString();
                bulkCopy.WriteToServer(dt);
            }
        }

        public void RemoveNotificationListener(ObjectName name, NotificationCallback callback, NotificationFilterCallback filterCallback, object handback)
        {
            int listenerId;
            NotificationSubscription key = new NotificationSubscription(callback, filterCallback, handback);
            if (_listenerProxys.TryGetValue(key, out listenerId))
            {
                _connection.RemoveNotificationListener(_token, name, listenerId);

                _reverseListenerProxys.Remove(listenerId);
                _listenerProxys.Remove(key);

                List<int> listenerGroup = _listenerGroupProxys[callback];
                listenerGroup.Remove(listenerId);
                if (listenerGroup.Count == 0)
                {
                    _listenerGroupProxys.Remove(callback);
                }
            }
            else
            {
                throw new ListenerNotFoundException(name.ToString());
            }
        }

 public Alias Table(ObjectName name)
 {
     return new Alias(name.ToString());
 }

        private ObjectInstance RegisterMBeanInternal(ObjectName name, IDynamicMBean bean)
        {
            IMBeanRegistration registration = new MBeanRegistrationHelper(bean as IMBeanRegistration);
            name = registration.PreRegister(this, name);

            string className = bean.GetMBeanInfo().ClassName;
            TestPermissions(className, null, name, MBeanPermissionAction.RegisterMBean);
            if (_beans.ContainsKey(name))
            {
                registration.PostRegister(false);
                throw new InstanceAlreadyExistsException(name.ToString());
            }
            _beans[name] = bean;
            registration.PostRegister(true);
            _delegate.SendNotification(new MBeanServerNotification(MBeanServerNotification.RegistrationNotification,
                                                                   null, -1, name));
            _domainSet[name.Domain] = true;

            return new ObjectInstance(name, bean.GetMBeanInfo().ClassName);
        }

 private IDynamicMBean GetMBean(ObjectName name)
 {
     IDynamicMBean bean;
     if (_beans.TryGetValue(name, out bean))
     {
         return bean;
     }
     throw new InstanceNotFoundException(name.ToString());
 }

        public static SqlPreCommandSimple DropPrimaryKeyConstraint(ObjectName tableName)
        {
            DatabaseName db = tableName.Schema.Database;

            var tn = tableName.OnDatabase(null);

            string varName = "PrimaryKey_Constraint_" + tn.Name;

            string command = @"
DECLARE @sql nvarchar(max)
SELECT  @sql = 'ALTER TABLE {Table} DROP CONSTRAINT [' + kc.name  + '];' 
FROM DB.sys.key_constraints kc
WHERE kc.parent_object_id = OBJECT_ID('{FullTable}')
EXEC DB.dbo.sp_executesql @sql"
                .Replace("DB.", db == null ? null : (db.ToString() + "."))
                .Replace("@sql", "@" + varName)
                .Replace("{FullTable}", tableName.ToString())
                .Replace("{Table}", tn.ToString());

            return new SqlPreCommandSimple(command);
        }

        public static SqlPreCommandSimple DropDefaultConstraint(ObjectName tableName, string columnName)
        {
            DatabaseName db = tableName.Schema.Database;

            var tn = tableName.OnDatabase(null);

            string varName = "Constraint_" + tableName.Name + "_" + columnName;

            string command = @"DECLARE @sql nvarchar(max)
SELECT  @sql = 'ALTER TABLE {Table} DROP CONSTRAINT [' + dc.name  + '];' 
FROM DB.sys.default_constraints dc
JOIN DB.sys.columns c ON dc.parent_object_id = c.object_id AND dc.parent_column_id = c.column_id
WHERE c.object_id = OBJECT_ID('{FullTable}') AND c.name = '{Column}'
EXEC DB.dbo.sp_executesql @sql
"
                .Replace("DB.", db == null ? null : (db.ToString() + "."))
                .Replace("@sql", "@" + varName)
                .Replace("{FullTable}", tableName.ToString())
                .Replace("{Table}", tn.ToString())
                .Replace("{Column}", columnName);

            return new SqlPreCommandSimple(command);
        }