public void Insert(SubOrganisation subOrganisation)
{
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDbConn1"].ConnectionString))
{
db.Query
("INSERT INTO SubOrganisation(Name) " +
"VALUES(@Name)", new { Name = subOrganisation.Name });
}
}
public void Update(SubOrganisation subOrganisation)
{
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDbConn1"].ConnectionString))
{
db.Query <bool>
("UPDATE SubOrganisation SET Name = @Name " +
"WHERE Id = @Id",
new { Id = subOrganisation.ID, Name = subOrganisation.Name });
}
}
