Results

Encrypted Columns

Encrypted columns will updates when insert and update operation.

Phone is an encrypted column.

The data is decrypted when it calls the get all entities or get by id action.

[
  {
    "id": 2,
    "name": "Ömer",
    "surname": "Seyfettin",
    "phone": "05525220174"
  }
]

---

Contains or Equal Query

When run contains or equal query generated the following like query.

 Executed DbCommand (176ms) [Parameters=[@__phone_0='?'], CommandType='Text', CommandTimeout='30']
      SELECT a."Id", a."Name", a."Phone", a."Surname"
      FROM "Authors" AS a
      WHERE (@__phone_0 = 'mQIccaslggWGEuLyfGiH/g==') OR (strpos(a."Phone", @__phone_0) > 0)

Therefore, in the query when run "contains" or "equals" the input is encrypted and processed.