stored procedures

[goxel]

Hi

We're using open access as an orm tool.
Does openaccess generates sql stored procedures automatically according to reverse mapping ?
How can we success this ? We want to use open access persistent classes with crud operations over stored procedures. We don't want to use objectscope.add or any method like that.

Thanks.

[PetarP]

Hi goxel,
you will first need to actually tell OA to generate those stored procedures for you. You can do so in the reverse mapping wizard. You should open the reverse map wizard and click on the Advanced View (TreeView) tab. 
You can choose the class for which you want to create a stored procedure. When you select class mark the Use stored procedure check box and on the insert procedure(or any other procedure) from the drop down list instead of Use Dynamic SQL choose Create Stored Procedures. Click generate and save config. Check if the Update Database property of your class library is set to true and if so rebuild your project. When you rebuild your project the stored procedure will be created on your sql server. Now you need to open the reverse mapping wizard again and do a merge to reflect the changes in the sql server. Merge the new procedures. When you do so you will be able to find those procedures in the Stored Procedures node in the Advanced View(TreeView) tab. Choose the procedure you want to generate and set the property Generate method to true. Click generate and save config. Now your stored procedure will be available as a static method into StoredProcedure.cs class inside your class library. To invoke them you will need to call [ClassLibraryName].StoredProcedures.[NameOfProcedure] (here you can replace the class library name with the class library that holds your persistent classes and NameOfProcedure with the actual name of your procedure).
Note that the newly created stored procedure will require all the fields from your table plus an instance of the IObjectScope.
Additional information can be found here.

Greetings,
PetarP
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.

[goxel]

Hi

i cant find screen you said. when i open the advenced tab there is no use stored procedures checkbox. i think version is different. mine is 2008.3.1204.1.

[PetarP]

Hello goxel,
stored procedures are introduced in Q1 2009. If you want to use them please update your version with the newest open access available on our web site.

Greetings,
PetarP
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.

[goxel]

Hi

what should I do to update the version that I use, is it possiple for you to tell me the procedure step by step?
It is an urgent and a critical situation. I have to process the operation as quick as possible

 

 

 

Thanks.

Thanks.

[Zoran]

Hi goxel,

There are three simple steps that require to be done in your scenario:

• Uninstall the current version of OpenAccess from your machine
• Download the latest version from our website
• Install the new version that you have downloaded

After you do so your stored procedures should be found by the Reverse-Mapping wizard as explained in our documentation.

Greetings,
Zoran
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.

[Rhyss]

I just did an install of the new version, as I had this problem too.
But on installation, the menu from VS2008 is no longer there.
Is this a known issue?  Is there something new I have to do to have OpenAccess play nice with VS2008?
Thanks,
Steele.

[Dimitar Kapitanov]

Hi Jordan,
We moved to a single 'company adopted' menu called Telerik. You should find the OpenAccess sub menu there. If you have other products from Telerik like Reporting or AJAX controls you will find additional stuff there.

Greetings,
Dimitar Kapitanov
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.

[prabhu]

hi goxel,

im vignesh

Steps

1.Choose the database (openaccess-->Enable project---->Expertwizard--->update database set true)
2.Telerik--->openaccess---->Reverse mapping
3.choose Avanced view tab --->select ur tables,
4.click ur  table (before initialize primay key in ur table)
5.select right corner one check box wil be display in dialog box (use stored procedure)
6.it wil automtically display the some option(insert,update,delete)select u r process wat u have done ..
7.Another way is there

     u just click Stored procedure --->right side wil be display u r stored procedure and select ur tables

8.And also dont forget simple view Tab select ur tables
9. Generate& save config
10.bulid the class file.


Further any doubt contact my mail id [e-mail]

take care bye!!!!