Пример #1
0
        void EmptyTheDatabase()
        {
            var repository = new WriteRepository(new ConfigConnectionSettings("rel"));

            repository.Do("TRUNCATE TABLE [Beds]", Enumerable.Empty<KeyValuePair<string, object>>());
            repository.Do("TRUNCATE TABLE [Participants]", Enumerable.Empty<KeyValuePair<string, object>>());
            repository.Do("TRUNCATE TABLE [ParticipantsRetreats]", Enumerable.Empty<KeyValuePair<string, object>>());
            repository.Do("TRUNCATE TABLE [Retreats]", Enumerable.Empty<KeyValuePair<string, object>>());
        }
Пример #2
0
        static void Main(string[] args)
        {
            var readRepository = new ReadRepository(new ConfigConnectionSettings("event"));
            var writeRepository = new WriteRepository(new ConfigConnectionSettings("event"));

            var binaryFormatter = new BinaryFormatter();

            var snapshots = readRepository.All("SELECT * FROM [Snapshots] ORDER BY [DateTime]", Enumerable.Empty<KeyValuePair<string, object>>());

            foreach (var snapshot in snapshots)
            {
                var actual = binaryFormatter.Deserialize(new MemoryStream((byte[])snapshot.Snapshot)) as Event;

                var stream = new MemoryStream();
                new XmlSerializer(actual.GetType()).Serialize(stream, actual);
                var content = stream.ToArray();

                var xmlpair = new KeyValuePair<string, object>("@Xml", content);
                var typepair = new KeyValuePair<string, object>("@Type", actual.ToString());
                var idpair = new KeyValuePair<string, object>("@Id", snapshot.Id);

                writeRepository.Do("UPDATE [Snapshots] SET [SnapshotXml] = @Xml, [Type] = @Type WHERE [Id] = @Id", new[] { xmlpair, typepair, idpair });
            }

            var events = readRepository.All("SELECT * FROM [Events] ORDER BY [DateTime]", Enumerable.Empty<KeyValuePair<string, object>>());

            foreach (var @event in events)
            {
                var actual = binaryFormatter.Deserialize(new MemoryStream((byte[])@event.Event)) as Event;

                var stream = new MemoryStream();
                new XmlSerializer(actual.GetType()).Serialize(stream, actual);
                var content = stream.ToArray();

                var xmlpair = new KeyValuePair<string, object>("@Xml", content);
                var typepair = new KeyValuePair<string, object>("@Type", actual.ToString());
                var idpair = new KeyValuePair<string, object>("@Id", @event.Id);
System.Threading.Thread.Sleep(10);
                writeRepository.Do("UPDATE [Events] SET [EventXml] = @Xml, [Type] = @Type WHERE [Id] = @Id", new[] { xmlpair, typepair, idpair });
            }
        }