public int AddOrganisation(Organisation org) { using (var connection = GetOpenMapsConnection()) { string query = @"INSERT INTO tblOrganisation (OrganisationName, Phone, MailEnabled) VALUES (@OrganisationName, @Phone, @MailEnabled);"; return connection.Execute(query, org); } }
public int AddOrganisation2(Organisation org) { using (var connection = GetOpenMapsConnection()) { string query = @"INSERT INTO tblOrganisation (OrganisationName, Phone, MailEnabled) VALUES (@OrganisationName, @Phone, @MailEnabled); SELECT CAST(SCOPE_IDENTITY() as int);"; org.OrganisationId = connection.Query<int>(query, org).Single(); if (org.OrganisationId > 0) { return 1; } return 0; } }