Does anyone know how to use SELECT in SQL for multiple objects. For example, I want to try to SELECT from Make and Model under a single method. I tried using SELECT Make, Model FROM car_basic WHERE Year IN (1985), but it only selects the former object.
public List<string> SearchYear()
{
//chose 1985 as the year
string sql = "SELECT Make FROM car_basic WHERE Year IN (1985)";
List<string> select = _db.LoadData<string, dynamic>(sql, new { });
return select;
}
public List<string> SearchYearContinued()
{
//chose 1985 as the year
string sql = "SELECT Model FROM car_basic WHERE Year IN (1985)";
List<string> select2 = _db.LoadData<string, dynamic>(sql, new { });
return select2;
}