public List <VehicleTE> GetSqlTestData()
{
List <VehicleTE> retLst = new List <VehicleTE>();
string sqlCon = @"data source=(LocalDB)\MSSQLLocalDB;attachdbfilename=|DataDirectory|\TestDB.mdf;integrated security=True;MultipleActiveResultSets=True;Connect Timeout=3";
SqlConnection conn = new SqlConnection(sqlCon);
conn.Open();
SqlCommand command = new SqlCommand("select * from VehicleModelYear", conn);
SqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
VehicleTE vte = new VehicleTE((int)reader[0], (int)reader[1], (String)reader[2], (String)reader[3]);
retLst.Add(vte);
}
}
catch { }
finally
{
reader.Close();
conn.Close();
}
return(retLst);
}
public void UpdateData()
{
int id = -1;
CloudTable table = GetTable();
VehicleTE vte = new VehicleTE(id, id, "Ding", "Dong");
var result = table.Execute(TableOperation.InsertOrReplace(vte));
TableQuery <VehicleTE> searchQuery = new TableQuery <VehicleTE>()
.Where(TableQuery.GenerateFilterConditionForInt("Id", QueryComparisons.Equal, id));
var queryResult = table.ExecuteQuery(searchQuery);
Assert.IsNotNull(queryResult.FirstOrDefault());
result = table.Execute(TableOperation.Delete(vte));
vte = new VehicleTE(id, id, "John", "Doe");
result = table.Execute(TableOperation.Insert(vte));
result = table.Execute(TableOperation.Delete(vte));
//TableOperation insertOperation = TableOperation.InsertOrReplace(test);
}
