How can I use the sql expressions in Kentico

Unal UN asked on January 19, 2018 12:02

Samples Operations

INSERT INTO Customer ( FirstName, LastName, Email, PhoneNumber) VALUES ( @FirstName, @LastName, @Email, @PhoneNumber)

SELECT CustomerID, FirstName, LastName, Email, PhoneNumber FROM Customer
WHERE (CustomerID = @CustomerID)

UPDATE CustomerSET FirstName = @FirstName, LastName = @LastName, Email = @Email, PhoneNumber = @PhoneNumber WHERE CustomerID = @CustomerID

DELETE FROM Customer WHERE CustomerID = @CustomerID

kentico 10 sql crud operations

Recent Answers

Alireza Arifi answered on January 19, 2018 12:21 (last edited on January 19, 2018 12:26)

Hi Unal,
Please read the documentation first. There are API Examples in Kentico API which you can have a look at, and use according to your needs and configuration.

If it is not what you are looking for please provide more information.

2 votesVote for this answer Mark as a Correct answer

Roman Hutnyk answered on January 19, 2018 14:05

Use CustomerInfoProvider to manipulate customers. You can find more details here.

1 votesVote for this answer Mark as a Correct answer

Jan Šedo answered on January 19, 2018 15:14

Please keep in mind that manipulating database directly is not supported scenario. You should always use Kentico API to aviod system corruption.

0 votesVote for this answer Mark as a Correct answer