Exemple #1
0
 private void IdInsertOff(SqlCeTransaction localTrans, int idOrdinal)
 {
     if (_keepIdentity && idOrdinal >= 0)
     {
         using (var idCmd = AdoNetUtils.CreateCommand(_conn, localTrans, string.Format(CultureInfo.InvariantCulture, "SET IDENTITY_INSERT [{0}] OFF", DestinationTableName)))
         {
             idCmd.ExecuteNonQuery();
         }
     }
 }
 internal static long GetAutoIncNext(SqlCeConnection conn, string destinationTableName)
 {
     using (var ainCmd = AdoNetUtils.CreateCommand(conn, null,
                                                   string.Format(CultureInfo.InvariantCulture,
                                                                 "SELECT AUTOINC_NEXT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '{0}' AND AUTOINC_INCREMENT IS NOT NULL", destinationTableName)))
     {
         object res = ainCmd.ExecuteScalar();
         if (res != null)
         {
             return((long)res);
         }
         return(0);
     }
 }
Exemple #3
0
 private void IdInsertOn(SqlCeTransaction localTrans, int idOrdinal)
 {
     if (_keepIdentity && idOrdinal >= 0)
     {
         using (var idCmd = AdoNetUtils.CreateCommand(_conn, localTrans, string.Format(CultureInfo.InvariantCulture, "SET IDENTITY_INSERT [{0}] ON", DestinationTableName)))
         {
             idCmd.ExecuteNonQuery();
         }
         if (_trans == null)
         {
             _autoIncNext = SqlCeBulkCopyTableHelpers.GetAutoIncNext(_conn, DestinationTableName);
         }
     }
 }
        internal static int IdentityOrdinal(SqlCeConnection conn, SqlCeTransaction transaction, string tableName)
        {
            int ordinal = -1;

            using (var ordCmd = AdoNetUtils.CreateCommand(conn, transaction, string.Format(CultureInfo.InvariantCulture,
                                                                                           "SELECT ORDINAL_POSITION FROM information_schema.columns WHERE TABLE_NAME = N'{0}' AND AUTOINC_SEED IS NOT NULL", tableName)))
            {
                object val = ordCmd.ExecuteScalar();
                if (val != null)
                {
                    ordinal = (int)val - 1;
                }
            }
            return(ordinal);
        }
Exemple #5
0
        public static List <DestinationTableDefaultMetadata> GetDataForTable(SqlCeConnection conn, SqlCeTransaction transaction, string tableName)
        {
            var retVal = new List <DestinationTableDefaultMetadata>();

            using (var ordCmd = AdoNetUtils.CreateCommand(conn, transaction, string.Format(CultureInfo.InvariantCulture,
                                                                                           "SELECT Column_Name, Is_Nullable, Column_HasDefault FROM information_schema.columns WHERE TABLE_NAME = N'{0}' ORDER BY Ordinal_Position;", tableName)))
            {
                using (var val = ordCmd.ExecuteReader(CommandBehavior.SingleResult | CommandBehavior.SequentialAccess))
                {
                    while (val.Read())
                    {
                        retVal.Add(new DestinationTableDefaultMetadata(val));
                    }
                }
            }

            return(retVal);
        }
Exemple #6
0
        private void ResetSeed(int totalRows)
        {
            if (totalRows == 0)
            {
                return;
            }

            if (!_keepIdentity)
            {
                return;
            }

            //Cannot run re-seed when using user supplied transaction, so fail silently
            if (_keepIdentity && _trans != null)
            {
                return;
            }

            var newAutoIncNext = SqlCeBulkCopyTableHelpers.GetAutoIncNext(_conn, DestinationTableName);

            if (_autoIncNext != newAutoIncNext)
            {
                return;
            }

            using (var transact = _conn.BeginTransaction())
            {
                // Get Identity column
                string idCol = null;
                using (var ainCmd = AdoNetUtils.CreateCommand(_conn, transact, string.Format(CultureInfo.InvariantCulture,
                                                                                             "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '{0}' AND AUTOINC_INCREMENT IS NOT NULL", DestinationTableName)))
                {
                    object res = ainCmd.ExecuteScalar();
                    if (res != null)
                    {
                        idCol = (string)res;
                    }
                }
                if (string.IsNullOrEmpty(idCol))
                {
                    return;
                }

                // Get Max value if the column
                long?maxVal = null;
                using (var ainCmd = AdoNetUtils.CreateCommand(_conn, transact, string.Format(CultureInfo.InvariantCulture,
                                                                                             "SELECT CAST(MAX([{0}]) AS bigint) FROM [{1}]", idCol, DestinationTableName)))
                {
                    object res = ainCmd.ExecuteScalar();
                    if (res != null)
                    {
                        maxVal = (long)res;
                    }
                }
                if (!maxVal.HasValue)
                {
                    return;
                }

                //Reseed
                using (var ainCmd = AdoNetUtils.CreateCommand(_conn, transact, string.Format(CultureInfo.InvariantCulture,
                                                                                             "ALTER TABLE [{0}] ALTER COLUMN [{1}] IDENTITY ({2},1);", DestinationTableName, idCol, maxVal + 1)))
                {
                    ainCmd.ExecuteNonQuery();
                }
                transact.Commit();
            }
        }