public void WriteToTable()
{
var configuration = new DataStoreConfiguration();
configuration.ConnectionString = _connectionString;
configuration.Columns = new List <DataStoreColumn>
{
new DataStoreColumn {
Name = "First Name", Source = "People"
},
new DataStoreColumn {
Name = "Last Name", Source = "People"
},
new DataStoreColumn {
Name = "Age", Source = "People"
}
};
var store = new SqlDataStore(configuration);
store.Write("John", "Doe", "23");
store.Write("Jane", "Doe", "21");
var memoryStore = new MemoryDataStore(configuration);
memoryStore.Write("John", "Doe", "23");
memoryStore.Write("Jane", "Doe", "21");
var actual = store.Read().ToList();
var expected = memoryStore.Read().ToList();
TestHelper.AreEqual(expected, actual);
}
public void ReadFromTable()
{
var configuration = new DataStoreConfiguration();
configuration.ConnectionString = _connectionString;
configuration.Columns = new List <DataStoreColumn>
{
new DataStoreColumn {
Name = "First Name", Source = "People"
},
new DataStoreColumn {
Name = "Last Name", Source = "People"
},
new DataStoreColumn {
Name = "Age", Source = "People"
}
};
RunSql("INSERT INTO [dbo].[People] ([First Name],[Last Name],[Age]) VALUES ('John', 'Doe', 23)");
RunSql("INSERT INTO [dbo].[People] ([First Name],[Last Name],[Age]) VALUES ('Jane', 'Doe', 21)");
var store = new SqlDataStore(configuration);
var actual = store.Read().ToList();
var memoryStore = new MemoryDataStore(configuration);
memoryStore.Write("John", "Doe", "23");
memoryStore.Write("Jane", "Doe", "21");
var expected = memoryStore.Read().ToList();
TestHelper.AreEqual(expected, actual);
}
public void Write()
{
var source = new MemoryDataStore(DataStoreConfiguration.FromColumns("First Name", "Last Name", "Age"));
var row = source.NewRow("John", "Doe", "23");
source.Write(row);
var expected = new[] { row };
var actual = source.Read().ToArray();
TestHelper.AreEqual(expected, actual);
}
