Page 1 of 1
Delete an item by Primary Key
Posted: Wed 10 Dec 2014 07:30
by elion
Hi there!
How can I delete an item explicit by an ID?
Now, I have first to retrieve an item from the database (e.g. SomeContext.GetEntity<TSomeEntity>), before I can execute DeleteAndSave, is it right?
Thank you!
I would like to have a functionality like shown below:
Code: Select all
var
SomeEntity: TSomeEntity;
SomeContext: TEntityContext;
begin
SomeEntity := TSomeEntity.Create;
SomeEntity.Id = 1234; // <-- this is a primary key
SomeContext.Delete(SomeEntity);
SomeContext.Save(SomeEntity);
end;
Re: Delete an item by Primary Key
Posted: Wed 10 Dec 2014 09:13
by AlexP
For record deletion, you can use the following code:
Code: Select all
var
SomeEntity: TSomeEntity;
SomeContext: TEntityContext;
begin
SomeEntity := SomeContext.GetEntity<T>(1234)
SomeContext.DeleteAndSave(SomeEntity);
end;
Re: Delete an item by Primary Key
Posted: Wed 10 Dec 2014 09:28
by elion
AlexP wrote:For record deletion, you can use the following code:
Code: Select all
var
SomeEntity: TSomeEntity;
SomeContext: TEntityContext;
begin
SomeEntity := SomeContext.GetEntity<T>(1234)
SomeContext.DeleteAndSave(SomeEntity);
end;
But in this case, I have to execute sql in order to get the item. But if I know the ID, I could delete the item directly without executing sql before.
Re: Delete an item by Primary Key
Posted: Thu 11 Dec 2014 10:15
by AlexP
To delete record, you can execute the following SQL query in the ExecuteSQL method:
Code: Select all
EntityConnection.ExecuteSQL('DELETE FROM TABLE WHERE FIELD = 123));
Re: Delete an item by Primary Key
Posted: Thu 11 Dec 2014 13:49
by elion
I see...
Thx for your reply!
Re: Delete an item by Primary Key
Posted: Fri 12 Dec 2014 06:47
by AlexP
If you have any further questions, feel free to contact us.