public int Remover(TEntidade obj) { using (OracleConnection connection = new OracleConnection(_connectionString)) { return(connection.Delete(obj)); } }
public void Delete() { var affrows = 0; using (var conn = new OracleConnection(_connectString)) { var item = new TestConnectionExt { title = "testdelete" }; affrows = conn.Insert <TestConnectionExt>().AppendData(item).ExecuteAffrows(); Assert.Equal(1, affrows); affrows = conn.Delete <TestConnectionExt>().Where(item).ExecuteAffrows(); conn.Close(); } Assert.Equal(1, affrows); }
public bool RemoveRoleFromUser(int roleId, int userId) { using (var conn = new OracleConnection(ConnectionString)) { var parameters = new List <OracleParameter>(); parameters.Add(new OracleParameter() { ParameterName = "Id", Value = userId }); parameters.Add(new OracleParameter() { ParameterName = "RoleId", Value = roleId }); var recordsAffected = conn.Delete <UserRole>(parameters); return(recordsAffected.Equals(1)); } }
public bool RemoveActivityFromRole(int activityId, int roleId) { using (var conn = new OracleConnection(ConnectionString)) { var parameters = new List <OracleParameter>(); parameters.Add(new OracleParameter() { ParameterName = "ActivityId", Value = activityId }); parameters.Add(new OracleParameter() { ParameterName = "RoleId", Value = roleId }); var recordsAffected = conn.Delete <RoleActivity>(parameters); return(recordsAffected.Equals(1)); } }
static void Main(string[] args) { var people = new People(); people.Name = "Samuel"; people.Age = 30; using (var con = new OracleConnection("your connection string")) { con.Insert(people); con.Update(people); var result = con.Query("select * from people where peopleid = 1"); con.Delete <People>(1); //...... } Console.WriteLine("Hello World!"); }
public void DeleteJob(Models.Job job) { conn.Delete <Models.Job>(job); }