public bool HasDifferences(TableSizes tablesSizes) { if (tablesSizes == null) { return(true); } return(!tablesSizes.Items.OrderBy(x => x.Key.ToString()).SequenceEqual(Items.OrderBy(x => x.Key.ToString()))); //return !RowCount.SequenceEqual(tablesSizes.RowCount); }
public TableSizes GetTableSizes(DbConnection conn, LinkedDatabaseInfo linkedInfo) { var res = new TableSizes(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = SqlServerLinkedServer.ReplaceLinkedServer(SqlServerDatabaseFactory.LoadEmbeddedResource("rowcounts.sql"), linkedInfo); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { string table = reader.SafeString("Table"); string schema = reader.SafeString("Schema"); int rowcount = Int32.Parse(reader.SafeString("RowCount") ?? "0"); res.RowCount[new NameWithSchema(schema, table)] = rowcount; } } } return res; }
public bool HasDifferences(TableSizes tablesSizes) { return !RowCount.SequenceEqual(tablesSizes.RowCount); }