public void Deletes_Range_of_Records_With_Composite_String_PK()
{
var list = new List <CompoundWidget>();
for (int i = 1; i <= 10; i++)
{
var newWidget = new CompoundWidget()
{
SKU = "SKU " + i, Name = "Widget " + i, Price = Decimal.Parse(i.ToString())
};
list.Add(newWidget);
}
int initialCount = list.Count;
IBiggyStore <CompoundWidget> cpdWidgetStore = new SQLServerStore <CompoundWidget>(_cache);
cpdWidgetStore.Add(list);
var deleteMe = cpdWidgetStore.Load();
cpdWidgetStore.Remove(deleteMe.ToList());
var fetchWidgets = cpdWidgetStore.Load();
Assert.True(initialCount == 10 && fetchWidgets.Count() == 0);
}
public void Deletes_Range_of_Records_With_Composite_String_PK()
{
var list = new List<CompoundWidget>();
for (int i = 1; i <= 10; i++) {
var newWidget = new CompoundWidget() { SKU = "SKU " + i, Name = "Widget " + i, Price = Decimal.Parse(i.ToString()) };
list.Add(newWidget);
}
int initialCount = list.Count;
IBiggyStore<CompoundWidget> cpdWidgetStore = new SQLServerStore<CompoundWidget>(_cache);
cpdWidgetStore.Add(list);
var deleteMe = cpdWidgetStore.Load();
cpdWidgetStore.Remove(deleteMe.ToList());
var fetchWidgets = cpdWidgetStore.Load();
Assert.True(initialCount == 10 && fetchWidgets.Count() == 0);
}
public void IBiggyStore_Deletes_Many_Records_With_String_PK()
{
IBiggyStore<Widget> widgetStore = new SQLServerStore<Widget>(_connectionStringName);
var insertThese = new List<Widget>();
for (int i = 0; i < 10; i++) {
var newWidget = new Widget() { SKU = "SKU " + i, Name = "Widget " + i, Price = Decimal.Parse(i.ToString()) };
insertThese.Add(newWidget);
}
widgetStore.Add(insertThese);
var newWidgets = widgetStore.Load();
int insertedCount = newWidgets.Count();
widgetStore.Remove(newWidgets);
newWidgets = widgetStore.Load();
Assert.True(insertedCount == 10 && newWidgets.Count() == 0);
}
public void IBiggyStore_Deletes_Many_Records_With_String_PK()
{
IBiggyStore <Widget> widgetStore = new SQLServerStore <Widget>(_connectionStringName);
var insertThese = new List <Widget>();
for (int i = 0; i < 10; i++)
{
var newWidget = new Widget()
{
SKU = "SKU " + i, Name = "Widget " + i, Price = Decimal.Parse(i.ToString())
};
insertThese.Add(newWidget);
}
widgetStore.Add(insertThese);
var newWidgets = widgetStore.Load();
int insertedCount = newWidgets.Count();
widgetStore.Remove(newWidgets);
newWidgets = widgetStore.Load();
Assert.True(insertedCount == 10 && newWidgets.Count() == 0);
}