FETCHING PLANS

Thread is closed for posting
12 posts, 0 answers
  1. prabhu
    prabhu avatar
    6 posts
    Member since:
    Jun 2007

    Posted 16 Apr 2009 Link to this post

    hi,

    how to create and use Fetch plans in telerik Openaccess ORM

    any body can help me???
  2. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 16 Apr 2009 Link to this post

    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.
  3. prabhu
    prabhu avatar
    6 posts
    Member since:
    Jun 2007

    Posted 16 Apr 2009 Link to this post

    Thanks for u reply

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

    im waiting for u reply


    byeeee



  4. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 17 Apr 2009 Link to this post

    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.
  5. vignesh
    vignesh avatar
    7 posts
    Member since:
    Apr 2009

    Posted 17 Apr 2009 Link to this post

    hi peter,

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

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

    thaks
    regards,
     vignesh
  6. Zoran
    Admin
    Zoran avatar
    534 posts

    Posted 17 Apr 2009 Link to this post

    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.
  7. vignesh
    vignesh avatar
    7 posts
    Member since:
    Apr 2009

    Posted 17 Apr 2009 Link to this post

    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

  8. Peter
    Peter avatar
    10 posts
    Member since:
    Oct 2008

    Posted 17 Apr 2009 Link to this post

    Hi,
    Please check out also the relevant demos.
    -Peter
  9. Zoran
    Admin
    Zoran avatar
    534 posts

    Posted 17 Apr 2009 Link to this post

    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.
  10. vignesh
    vignesh avatar
    7 posts
    Member since:
    Apr 2009

    Posted 17 Apr 2009 Link to this post

    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


  11. Peter Brunner
    Admin
    Peter Brunner avatar
    89 posts

    Posted 20 Apr 2009 Link to this post

    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.
  12. kottu
    kottu avatar
    23 posts
    Member since:
    Mar 2009

    Posted 20 Apr 2009 Link to this post

    Hi Peter ,

    Thanks for u r reply.....

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

    take care


    Regards ,
    vignesh
Back to Top