Oracle and SilverLight



  • Does anyone know how, in less than the very vague terms I've found everywhere else, I can set up in VS 2010 a Silverlight Application that consumes data from an Oracle Database?  Most of the answers I've found have revolved around using the entity framework wizard which as far as I can tell doesn't have the capability of connecting to Oracle without using paid thrid party "drivers" (and those posters usually fail to mention or even hit at that)..



  •  Why not expose that data as either a json or xml service?



  • That so far looks like the only option.

    I HATE the cloud and despise the internet.



  • What about this ? 

    Disclaimer: I'm not a silverlight dev, so I don't have first hand knowledge.



  • @frits said:

    What about this ? 

    Disclaimer: I'm not a silverlight dev, so I don't have first hand knowledge.

    Thanks.  Already aware of ODP, and as far as I know, can use that to create the web service to which the silverlight application connects to get/alter data.



  • @Medezark said:

    Thanks.  Already aware of ODP, and as far as I know, can use that to create the web service to which the silverlight application connects to get/alter data.

    Beware of the evil "Package State has been discarded" exception which is no exception at all. That exception will completely undermine all your efforts to create a sane codebase and sane exception handling. Look no further, you have found madness incarnate.

     Without diving (too far) into an Oracle rant, I have to say that the ODP.NET library will unfortunately make an object oriented implementation contain GOTOs.. I mean insane cases of FOR-CASE and WHILE-FALSE with a bit of SWITCH-IF-GetType(). You have been warned.

     My opinion? Scrap oracle to begin with, and go with another database engine which does not belch in your face when you try to use it1



  • @Forumtroll said:

    @Medezark said:

    Thanks.  Already aware of ODP, and as far as I know, can use that to create the web service to which the silverlight application connects to get/alter data.

    Beware of the evil "Package State has been discarded" exception which is no exception at all. That exception will completely undermine all your efforts to create a sane codebase and sane exception handling. Look no further, you have found madness incarnate.

     Without diving (too far) into an Oracle rant, I have to say that the ODP.NET library will unfortunately make an object oriented implementation contain GOTOs.. I mean insane cases of FOR-CASE and WHILE-FALSE with a bit of SWITCH-IF-GetType(). You have been warned.

     My opinion? Scrap oracle to begin with, and go with another database engine which does not belch in your face when you try to use it1

    If only I had any choice in the matter.

    One way to avoid the Package State crap is to avoid using Packages altogether.  -- Triggers, Functions and Procedures out in the open seems much more sane to me than packages anyway.



  • @Medezark said:

    If only I had any choice in the matter.

    One way to avoid the Package State crap is to avoid using Packages altogether.  -- Triggers, Functions and Procedures out in the open seems much more sane to me than packages anyway.

    You're basically screwed then. Procedures and functions requires to be in a package to comply to some absurd oracle standard AFAIK. You may avoid severe sanity loss with mental disorders following as long as you don't have a certified Oracle DBA calling the shots. Developing with Oracle is playing Call of Cthulhu - you will lose your sanity and go insane... sooner or later.

    Use a sane ORM mapper, and you may be able to circumvent the DBA problem.



  • @CaptainCaveman said:

     Why not expose that data as either a json or xml service?

    Silverlight 4 can also consume .NET RIA Services, REST services and OData services (WCF Data Services). Getting data into Silverlight



  • @Forumtroll said:

    @Medezark said:

    If only I had any choice in the matter.

    One way to avoid the Package State crap is to avoid using Packages altogether.  -- Triggers, Functions and Procedures out in the open seems much more sane to me than packages anyway.

    You're basically screwed then. Procedures and functions requires to be in a package to comply to some absurd oracle standard AFAIK. You may avoid severe sanity loss with mental disorders following as long as you don't have a certified Oracle DBA calling the shots. Developing with Oracle is playing Call of Cthulhu - you will lose your sanity and go insane... sooner or later.

    Use a sane ORM mapper, and you may be able to circumvent the DBA problem.

    Was explicitly told to stop workin g on new technologies

     



  • @Medezark said:

    @Forumtroll said:

    You're basically screwed then. Procedures and functions requires to be in a package to comply to some absurd oracle standard AFAIK. You may avoid severe sanity loss with mental disorders following as long as you don't have a certified Oracle DBA calling the shots. Developing with Oracle is playing Call of Cthulhu - you will lose your sanity and go insane... sooner or later.

    Use a sane ORM mapper, and you may be able to circumvent the DBA problem.

    Was explicitly told to stop workin g on new technologies

    So you are not allowed to use an ORM mapper? You have been explicitly been told to make use of datasets and ODP.NET in a silverlight app?

     I for one smell some manager not having the balls to fire you directly, and instead gives you the impossible assignment. Frankly, the ODP.NET connectivity plugin requires the entire 700MB Oracle client environment to be installed as well on the target computer. This means either an insane attempt at wrapping Oracle client into the silverlight app, resulting in 700+ MB worth of silverlight app (which I call perversely infeasible), or telling your supervisor to grow a pair and invest in a better DB platform.

     Edit: I had to the same in my last job. I lasted two years before I called it quits and told my manager to go fuck off so hard he'd never return in my existence again. You don't work for EG Utility by any chance, do you?



  • @Forumtroll said:

    @Medezark said:

    @Forumtroll said:

    You're basically screwed then. Procedures and functions requires to be in a package to comply to some absurd oracle standard AFAIK. You may avoid severe sanity loss with mental disorders following as long as you don't have a certified Oracle DBA calling the shots. Developing with Oracle is playing Call of Cthulhu - you will lose your sanity and go insane... sooner or later.

    Use a sane ORM mapper, and you may be able to circumvent the DBA problem.

    Was explicitly told to stop workin g on new technologies

    So you are not allowed to use an ORM mapper? You have been explicitly been told to make use of datasets and ODP.NET in a silverlight app?

     I for one smell some manager not having the balls to fire you directly, and instead gives you the impossible assignment. Frankly, the ODP.NET connectivity plugin requires the entire 700MB Oracle client environment to be installed as well on the target computer. This means either an insane attempt at wrapping Oracle client into the silverlight app, resulting in 700+ MB worth of silverlight app (which I call perversely infeasible), or telling your supervisor to grow a pair and invest in a better DB platform.

     Edit: I had to the same in my last job. I lasted two years before I called it quits and told my manager to go fuck off so hard he'd never return in my existence again. You don't work for EG Utility by any chance, do you?

    Oh, quite the contrary.  Was told to abandon silverlight in favor of asp.net.  Which I have no problems with.  And I agree with the reasoning.  The applications we are developing are not really good candidates for silverlight.



  • I can understand that decision then. I was worried you were caught up with one of those develomestruction architects who wants all modules on bleeding edge technology, but refuses to adapt to new requirements. I am so relieved on your behalf that I was wrong. Unfortunately, I was not that lucky in my last job.

    I've learned one thing, though. Oracle is an abomination. 



  • Shhh. I don't want the mods mods moving this into the I Hate Oracle Thread

     



  • @Medezark said:

    Shhh. I don't want the mods mods moving this into the I Hate Oracle Thread

    No comprende, Señor!



  • @Forumtroll said:

    Procedures and functions requires to be in a package to comply to some absurd oracle standard AFAIK
     

    Bullshit. You can have it either way. Packages are usefull to organise the code and to keep state (i.e. package variables, which are just like static variables in a java class).

    I know Oracle has some quirks, but in this case, it seems like the problem exists beween keyboard and chair.

     


Log in to reply
 

Looks like your connection to What the Daily WTF? was lost, please wait while we try to reconnect.