public CountryTerritory Read(long id) { const string sql = "SELECT Name, Id, ObjectId, CreatedAt, ModifiedAt, DeletedAt FROM CountryTerritory WHERE Id=@Id"; CountryTerritory entity = null; using (var connection = new SqlConnection(_connectionString)) { connection.Open(); using (var command = new SqlCommand(sql, connection)) { command.Parameters.AddWithValue("@Id", id); var reader = command.ExecuteReader(CommandBehavior.SingleResult); while (reader.Read()) { entity = new CountryTerritory() { Name = (System.String)reader["Name"], Id = (System.Int64)reader["Id"], ObjectId = (System.Guid)reader["ObjectId"], CreatedAt = (System.DateTime)reader["CreatedAt"], ModifiedAt = (System.DateTime)reader["ModifiedAt"], DeletedAt = (System.DateTime?)reader["DeletedAt"], }; } } } return(entity); }
public bool Insert(CountryTerritory entity) { const string sql = "INSERT INTO CountryTerritory ( Name, Id, ObjectId, CreatedAt, ModifiedAt, DeletedAt ) VALUES ( @Name, @Id, @ObjectId, @CreatedAt, @ModifiedAt, @DeletedAt )"; long rows; using (var connection = new SqlConnection(_connectionString)) { using (var command = new SqlCommand(sql, connection)) { command.Parameters.AddWithValue("@Name", entity.Name); command.Parameters.AddWithValue("@Id", entity.Id); command.Parameters.AddWithValue("@ObjectId", entity.ObjectId); command.Parameters.AddWithValue("@CreatedAt", entity.CreatedAt); command.Parameters.AddWithValue("@ModifiedAt", entity.ModifiedAt); command.Parameters.AddWithValue("@DeletedAt", entity.DeletedAt); rows = command.ExecuteNonQuery(); } } return(rows > 0); }
public bool Update(CountryTerritory entity) { return(false); }