Open access ORM versus Lightswitch

Thread is closed for posting
9 posts, 0 answers
  1. Henk
    Henk avatar
    114 posts
    Member since:
    Apr 2006

    Posted 13 Oct 2010 Link to this post

    Hi,

    I would like to see that using OA ORM will be as easy as building an application in Lightswitch. For me using ORM is still too much coding for standard data manipulation using master detail (detail) relationships and validation.

    The rad way would be: mapping table relationships to objects (automatically recognizing foreign key(s)) -> automatically generating data services for the objects -> assign the service as datasource to a silverlight control and to be able to do data validations of the map fields. This process should be done without any coding.

    I see that ORM are providing more and more wizards but the Lightswitch way for building LOB applications for Silverlihgt is unbeatable at this moment.  I hope that OA ORM will do a catch up in this area.

    Henk
  2. Jordan
    Admin
    Jordan avatar
    547 posts

    Posted 15 Oct 2010 Link to this post

    Hi Henk,

    Thank you for writing.
    As you have noticed, with the DSW and other wizards we are already trying to make developing with OpenAccess easier.
    Actually the scenario that you use as an example is mostly possible even now, because the DSW can generate a Silverlight application for you (with Microsoft or Telerik control).
    Have you tried that functionality of the DSW?

    We are constantly working in that direction in order to  allow developers to be even more productive with OpenAccess.
    We have already planned to extend the DSW with new functionality and support for more services and presentation layers that will make developing with OpenAccess even easier.
    Any feedback and suggestions that you might have are welcome.

    Kind regards,
    Jordan
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Henk
    Henk avatar
    114 posts
    Member since:
    Apr 2006

    Posted 25 Oct 2010 Link to this post

    No, i dont use specifically the dsw, but following the examples in regards using Ria services. Still a lot of issues encountered using Ria services in combination with ORM. Master detail relationships in the model are not fully recognized in dml operation and defining validation is not out of the box. Still a lot of coding in comparison the Lightswitch way.  I hope that the next  release will bring ORM more in sync with the Lightswitch rad way for building LOB applications.

    Henk
  4. Jordan
    Admin
    Jordan avatar
    547 posts

    Posted 27 Oct 2010 Link to this post

    Hello Henk,

    We have a vastly improved RIA experience on the road-map and definitely will be working on that in the future.
    Unfortunately I cannot give you a specific time frame for the availability of such functionality at the moment.
    As always, any feedback is welcome.

    Sincerely yours,
    Jordan
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Vassil Petev
    Admin
    Vassil Petev avatar
    1765 posts

    Posted 13 Apr 2011 Link to this post

    Hello Henk,

    You may have noticed this in our blogs, but I am sending it your way anyway - in case you still want to use Telerik OpenAccess ORM with LightSwitch: Getting Started With LightSwitch and OpenAccess


    Best wishes,
    Vassil
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  6. venkat
    venkat avatar
    9 posts
    Member since:
    Apr 2011

    Posted 19 Apr 2011 Link to this post

    Hello,
    I am using Telerik OpenAccess ORM and WCF RIA services to pull data and usinf Lightswitch to display that data.
    I can populate data into EditableGrid in LightSwitch,but when i tried to Update it,i am getting this error.

    Value cannot be null.
    Parameter name: sourceMemberNames.


    can we perform updates through lightswitch by using telerik openaccess ORM.I am using Oracle database.
    I am Using WCF RIA Services.


    this is my  "Domain Service"

     

    [

     

    EnableClientAccess()] 

     

     

     

    public partial class test_DS_cs : OpenAccessDomainService< testEntitiesModel  

     

     

    {

     

     

     

    public test_DS_cs() : base() 

     

     

    {}

     

     

     

     

     

    public IQueryable<TESTTABLE> GetTESTTABLEs() 

     

     

     

     

     

    return this.DataContext.TESTTABLEs; 

     

     

     

     

     

    public void DeleteTESTTABLEs(TESTTABLE tESTTABLE) 

     

     

    {

     

     

     

    // This is a callback method. The actual Delete is performed internally.  

     

     

     

    public void UpdateTESTTABLEs(TESTTABLE tESTTABLE) 

     

     

    {

     

     

     

    // This is a callback method. The actual Update is performed internally.  

     

     

    }

     

    public void InsertTESTTABLEs(TESTTABLE tESTTABLE) 

     

     

    {

     

     

     

    // This is a callback method. The actual Insert is performed internally.  

     

     

     

    }

    }


    And this is my table:

     

    public

     

     

    partial class TESTTABLE  

     

     

    {

     

    private long _eMPID; 

     

     

     

    public virtual long EMPID 

     

     

     

     

     

    get  

     

     

    {

     

    return this._eMPID; 

     

     

    }

     

     

     

    set  

     

     

     

    {

     

    this._eMPID = value

     

     

     

    }

     

     

     

     

     

    private string _fNAME; 

     

     

     

    public virtual string FNAME 

     

     

     

     

     

    get  

     

     

     

    {

     

    return this._fNAME; 

     

     

    }

     

     

     

    set  

     

     

     

    this._fNAME = value

     

     

     

    }

     

     

     

     

     

    private string _lNAME; 

     

     

     

    public virtual string LNAME 

     

     

     

     

     

    get  {

     

    return this._lNAME; 

     

     

    }

     

     

     

    set  

     

     

     

    this._lNAME = value

     

     

     

    }

     

    }



    Thanks,
    LV.

  7. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 21 Apr 2011 Link to this post

    Hi venkat,

     Can you please share with us which version of Telerik OpenAccess ORM are you using? I have seen such errors occur with version prior to Q1 2011. If you are using an earlier version can you please try to upgrade and see if that fixes your problem?

    Best wishes,
    Petar
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  8. venkat
    venkat avatar
    9 posts
    Member since:
    Apr 2011

    Posted 25 Apr 2011 Link to this post

    Hello,

    Thanks for your reply.
    I am using telerik openaccess orm version 2011.1.411.2.
    Still i am getting the same error while updating the record.
    I am not getting any errors while displaying data.Only problem is while updating .
    I didn't write any code to do update.Do i need to? with lightswitch and telerik openaccess orm.
    Please let me know.
    Or if possible please give me a working sample.

    Thanks,
    LV.
  9. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 17 Jun 2011 Link to this post

    Hello venkat,

     I have tested this with the latest version of OpenAccess and everything is working as expected. 
    No additional code is required for handling an update because the changes you do on your client are successfully resolved on the server side and the update should pass automatically once you call .Commit(). Please note that you should not write any code in your update methods too.
    If you are still facing any problems please send us a sample application where the problem is present so that we can investigate the cause of it and provide you with a fix.

    Regards,
    Petar
    the Telerik team
    Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
Back to Top