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