FETCHING PLANS

[prabhu]

hi,

how to create and use Fetch plans in telerik Openaccess ORM

any body can help me???

[PetarP]

Hello prabhu,
I believe that this topic will provide useful information regarding the fetch plans in OpenAccess ORM.
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.

[prabhu]

Thanks for u reply

i need Telerik openaccess ORM Fetch plans video examples using windows application.

im waiting for u reply


byeeee

[PetarP]

Hello prabhu,
unfortunately such videos are not yet available. As for now you can refer to the help topic I posted in my previous replay or to our QSF examples that come with installing the Telerik OpenAccess ORM product. Note that this examples are available in both C# and VB.
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.

[vignesh]

hi peter,

How to combined more than one SQL query in run time using Telerik ORM

is it any possible way .......

thaks
regards,
 vignesh

[Zoran]

Hi vignesh,

I am not very sure if I got that one right. If you execute a complex OQL or Linq query it generates a SQL query which looks like few queries merged. It is also possible to execute more then one query into one transaction and than have multiple result sets.

Sincerely yours,
Zoran
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.

[vignesh]

hi zoran,

can u give some examples

for this one "more then one query into one transaction"

And also one more doubt ,

how to fetched this queries in ORM????

thanks for u reply ,
Regards,
vignesh

[Peter]

Hi,
Please check out also the relevant demos.
-Peter

[Zoran]

Hi vignesh,

Here is a sample code where we execute multiple queries into one transaction:

        IObjectScope scope = Database.Get("DatabaseConnection1").GetObjectScope();
        {
            scope.Transaction.Begin();
            {
                IQuery query1 = scope.GetOqlQuery("SELECT ord FROM OrderExtent AS ord");
                IQueryResult queryResult1 = query1.Execute();

                IQuery query2 = scope.GetOqlQuery("SELECT cust FROM CustomerExtent AS cust");
                IQueryResult queryResult2 = query2.Execute();

                for (int i = 0; i < 10; i++)
                {
                    Order o = (Order)queryResult1[i];
                    Customer c = (Customer)queryResult2[i];
                    o.Customer = c;
                }
               Customer newCustomer = new Customer();
                scope.Add(newCustomer);
                scope.Transaction.Commit();
            }

In the code above we first execute two different SELECT queries in OQL which generate two different SQL queries for extracting the Orders and Customers from the database. After that we then edit some of the returned results in the "for" loop, add an additional record and call Transaction.Commit(). This further generates multiple UPDATE queries for all the edited "Order" objects(which we edited in the loop) and also an INSERT query for the newly created "Customer" instance.


Best wishes,
Zoran
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.

[vignesh]

hi Zoran ,

Thanks  for ur reply...

it wil be definetly useful for me....

i have another doubt

i need insert and update records by using Stored Procedure in  Telerik Open access ORM

is there any other easy way ......

thanks ,
regards,
vignesh

[Peter Brunner]

Hi Vignesh,

Thank you for contacting us again.

Please always review the appropriate information available online in our documentation, demos, knowledge base and code library for general information and ask more specific questions here.

Even you might not find something to any related topic in any of these resource areas, it is worth checking, because these resources are being expanded continuously.

A good entry point for Stored Procedure is "Using Stored Procedures" or more directly  "Update Data Using a Stored Procedure".

Please don't hesitate to contact us again for further questions.

Kind regards,
Peter Brunner
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.

[kottu]

Hi Peter ,

Thanks for u r reply.....

I got it man........

take care


Regards ,
vignesh