Cascading Dropdown in asp.net MVC core using ADO.NET

I am doing cascading drop down from Country to States in asp.net MVC core using ADO.NET using the stored procedure. Is it the right approach to use ADO.NET in ASP.NET MVC Core. and my question is I have issues while selecting the country list from the drop-down. States are not coming to the drop down as CountryId is not passing into the Controller method getStateByCountry.Suggestions would be highly appreciated.

 

**View Model** :

public class Country

{

public int CountryId { get; set; }

public string CountryName { get; set; }

public virtual int StateId { get; set; }

public virtual string StateName { get; set; }

public virtual List states { get; set; }

}

**Controller:**

public class CascadeController : Controller

{

DataBaseSetting db = new DataBaseSetting();

public IActionResult Index()

{

return View();

}

public IActionResult Create()

{

try

{

List list_country = new List();

List selectListItems = new List();

list_country = db.GetCountry();

ViewBag.Country = list_country;

return View();

}

catch (Exception ex)

{

throw ex;

}

}

public JsonResult getStateByCountry(int ID)

{

List Liststates = new List();

Liststates = db.GetStatesByCountry(ID);

Liststates.Insert(0, new State { StateId = 0, StateName = "Select State" });

return Json(new SelectList("StateId", "StateName"));

}

}

**Ado Code:**

public class DataBaseSetting

{

string ConnectionString = "Data Source=ABC-17;Initial Catalog=*****User ID=sa; Password=******";

public List GetCountry()

{

List list_Country = new List();

using (SqlConnection sqlConnection = new SqlConnection(ConnectionString))

{

using (SqlCommand sqlCommand = new SqlCommand("spGetCountry", sqlConnection))

{

sqlCommand.CommandType = CommandType.StoredProcedure;

sqlConnection.Open();

SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();

while (sqlDataReader.Read())

{

Country country = new Country()

{

CountryId = (int)sqlDataReader["CountryId"],

CountryName = sqlDataReader["CountryName"].ToString()

};

list_Country.Add(country);

}

}

return list_Country;

}

}

public List GetStatesByCountry(int CountryId)

{

List ListState = new List();

using (SqlConnection sqlCOnnection = new SqlConnection(ConnectionString))

{

using (SqlCommand sqlCommand = new SqlCommand("GetStateByCountry", sqlCOnnection))

{

sqlCommand.CommandType = CommandType.StoredProcedure;

sqlCommand.Parameters.AddWithValue("@CountryId", CountryId);

sqlCOnnection.Open();

SqlDataReader dataReader = sqlCommand.ExecuteReader();

while (dataReader.Read())

{

State state = new State()

{

StateId = (int)dataReader["StateId"],

StateName = dataReader["StateName"].ToString(),

};

ListState.Add(state);

}

}

}

return ListState;

}

}

**Create View:**

@model CascadingDropDown.Models.Country

@{

ViewData["Title"] = "Create";

}

}