Databases
StackOverflow2013
Postsdbo
POWeb Service Client Architecture - c#
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWeb Service Client Architecture - c#
    primarykey
    data
    text
    <p>Morning all,</p> <p>I have been tasked with developing a client tool for a cloud web service API (A simple WSDL). I am not a seasoned or even qualified developer, I have an intermediate knowledge of C# and enough I believe to make this work, but I don't want a solution that just works, I want to build something clean and well coded which another dev can read and understand and which is intuitive.</p> <p>You may want to stop me there and say "That is something you can only learn through experience." if that is the case then I can accept that and move on, but if you do have some advice the rest of the details are below.</p> <p>The solution will be a C# Console application. I have produced a spec for this, it is below:</p> <blockquote> <p>1.) Create a console application in .NET which has the following capabilities:</p> <p>2.) Consume CSV file containing Processed Data OR ODBC Connection to staging SQL database and read records directly out of load table</p> <p>3.) Make the following calls to Zuora Webservice (Asynchronous) ·<br> <em>SubscribeWithExisitingAccount()</em> · <em>Create()</em> ·<br> Login() · Subscribe() · Update() · Delete()</p> <p>(*) Calls marked with this are possibly avoidable, </p> <p>*it is possible to create a subscription, account and contact with a single call (Subscribe())</p> <p>*Create() may be the exception as a scenario may occur where we need to create an instance of an object with no corresponding subscription.</p> <p>4.) Report back the success and errors of every record into a CSV file.</p> <pre><code> Mappings will be done on a 1 to 1 basis, where the input file </code></pre> <p>will have the same column names as the target</p> </blockquote> <p>Where I lack knowledge is following a design which will make this app make sense and work efficiently. I am not looking for someone to do this for me, what I am looking for is tips on how I can improve on what I am already doing</p> <p>Currently I am just organically building the solution due to a lack of foresight on jobs like this, so I am also interested in things I can do post development.</p> <p>ALL Advice and criticism is welcomed.</p> <p>Thanks in advance,</p> <p>Matt </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USHleo
    1. USHleo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWeb Service Client Architecture - c#
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWeb Service Client Architecture - c#
      1. USmFontoura
      1. VTFavorite
    1. COMy code is working but the design which has evolved means that it is a clunky solution and I am following no design principles, I am looking for general design advice when building a solution like this
      singulars
      1. POWeb Service Client Architecture - c#
      1. USHleo
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload