This question is locked. New answers and comments are not allowed.
Hi,
I am new in ORM and planning to use it on my next project. Since i am already an user of Telerik, Open Access will be my first choice.
I understand ORM will do a mapping between database and the object/class. All the SQL query will did by the ORM itself. Question is should i not to use any SQL query or stored-procedures at all after i implemented ORM.
Lets say i have an Customer table in DB, when i need to update a bunch of record in that table, in ORM i need to query all the related records then loop each of it, make changes on the object then update them back to database. But if using SQL query or Stored-Procedure, this can achieve by a single query which i think it is faster. It does not need to get all the data from DB and map to object, then no need loop one by one to update, and then send back the updated data to DB again.
Please advise me on whether i should using T-SQL after implemented ORM and correct me if my thought on above situation is wrong.
Thanks.
I am new in ORM and planning to use it on my next project. Since i am already an user of Telerik, Open Access will be my first choice.
I understand ORM will do a mapping between database and the object/class. All the SQL query will did by the ORM itself. Question is should i not to use any SQL query or stored-procedures at all after i implemented ORM.
Lets say i have an Customer table in DB, when i need to update a bunch of record in that table, in ORM i need to query all the related records then loop each of it, make changes on the object then update them back to database. But if using SQL query or Stored-Procedure, this can achieve by a single query which i think it is faster. It does not need to get all the data from DB and map to object, then no need loop one by one to update, and then send back the updated data to DB again.
Please advise me on whether i should using T-SQL after implemented ORM and correct me if my thought on above situation is wrong.
Thanks.