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 }); } }