This question is locked. New answers and comments are not allowed.
is there any way to get write all stored prodedure using OpenAcess if i have databse with tables?
stored prodecures to insert , update, delete, select,find
are expected to produced by this orm if i can chose the databse
stored prodecures to insert , update, delete, select,find
are expected to produced by this orm if i can chose the databse
3 Answers, 1 is accepted
0
Hello PureRamu,
OpenAccess can generate stored procedures for the basic CRUD operations for you. Please have a look at our help topic located here.
Kind regards,
PetarP
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
OpenAccess can generate stored procedures for the basic CRUD operations for you. Please have a look at our help topic located here.
Kind regards,
PetarP
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
PureRamu
Top achievements
Rank 1
Rank 1
answered on 30 May 2009, 01:15 PM
i have enable a project to use open acess and i am retrieving data using a codes
(I created class from tables)
I looked my databse .but no stored procedures are created newly on the database
why?
"The Telerik OpenAccess ORM tool supports usage of stored procedures for retrieving and modifying data."
do this mea that it creates stored procedures .
can u point out what step may i go wrong?
Can you give me step by step instruction to create a web application as 3 tiere?
(I created class from tables)
I looked my databse .but no stored procedures are created newly on the database
why?
"The Telerik OpenAccess ORM tool supports usage of stored procedures for retrieving and modifying data."
do this mea that it creates stored procedures .
can u point out what step may i go wrong?
Can you give me step by step instruction to create a web application as 3 tiere?
0
Accepted
Hi PureRamu,
when you reverse map your tables you can switch to advanced tab in the reverse mapping wizard. From there you can select any class and check the Use stored procedure check box. A list with available stored procedures will appear and from there you can specify whether to use Dynamic SQL(meaning that every time when you add for example a new SQL statement will be generated) or you can select create stored procedure which will generate a new stored procedure on your SQL server and that stored procedure will be used the next time you try to add an object.
All the best,
PetarP
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
when you reverse map your tables you can switch to advanced tab in the reverse mapping wizard. From there you can select any class and check the Use stored procedure check box. A list with available stored procedures will appear and from there you can specify whether to use Dynamic SQL(meaning that every time when you add for example a new SQL statement will be generated) or you can select create stored procedure which will generate a new stored procedure on your SQL server and that stored procedure will be used the next time you try to add an object.
All the best,
PetarP
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.