This is a migrated thread and some comments may be shown as answers.

Open access ORM versus Lightswitch

8 Answers 151 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Henk
Top achievements
Rank 1
Henk asked on 13 Oct 2010, 10:20 AM
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

8 Answers, 1 is accepted

Sort by
0
Jordan
Telerik team
answered on 15 Oct 2010, 04:46 PM
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
0
Henk
Top achievements
Rank 1
answered on 25 Oct 2010, 11:00 AM
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
0
Jordan
Telerik team
answered on 27 Oct 2010, 02:23 PM
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
0
Vassil Petev
Telerik team
answered on 13 Apr 2011, 09:58 AM
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
0
venkat
Top achievements
Rank 1
answered on 19 Apr 2011, 09:38 PM
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.

0
PetarP
Telerik team
answered on 21 Apr 2011, 07:17 AM
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
0
venkat
Top achievements
Rank 1
answered on 25 Apr 2011, 04:12 PM
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.
0
PetarP
Telerik team
answered on 17 Jun 2011, 09:36 AM
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.
Tags
General Discussions
Asked by
Henk
Top achievements
Rank 1
Answers by
Jordan
Telerik team
Henk
Top achievements
Rank 1
Vassil Petev
Telerik team
venkat
Top achievements
Rank 1
PetarP
Telerik team
Share this question
or