Delete an item by Primary Key

[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;

[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;

[elion]

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.

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

[elion]

I see... Thx for your reply!

[AlexP]

If you have any further questions, feel free to contact us.