public override string SayHello()
{
string sResults = "";
try
{
using (DataConnect dc1 = new DataConnect())
{
// get select row from DB
DataRow rowResults = dc1.ExecuteFunction <DataTable>("SELECT 'Hello from DBRepository' as message", null).Rows[0];
sResults = string.Format("Result from DB: {0}", (rowResults["message"].ToString()));
}
}
catch (Exception ex)
{
throw ex;
}
return(sResults);
}
public override int UpdatePerson(Person person)
{
var dataResults = new DataTable();
dynamic sqlParam = new ExpandoObject();
sqlParam.firstName = person.FirstName;
sqlParam.lastName = person.LastName;
try
{
using (DataConnect dc1 = new DataConnect())
{
dataResults = dc1.ExecuteFunction <DataTable>("exec some_sp @firstName, @lastName", sqlParam);
person.PersonId = Int32.Parse(dataResults.Rows[0]["PersonID"].ToString());
}
}
catch (Exception ex)
{
throw ex;
}
return(person.PersonId);
}