c# - Connecting Windows Phone 8 to Sql server -

as i'm not skilled in windows phone 8 development discuss/ask the best way connect windows phone 8 sql-server database. tried search through internet , found few guides didn't worked me linq-to-sql using webservice. this failed.

firstly display data - important, don't need edit them yet. in future inevitable.

if editing work need edit them directly on sql server i'm connected. checked sql server compact guide can work under ce 4.0 (when exporting data sql server sql compact) doesn't support windows phone 8. if work copy sql server database sql compact , doesn't work data directly on sql server (which understandable because sql server compact).

so searching way using webservice followed step-by-step guides on youtube mentioned before, problem displaying data guide led me using listbox because windows phone 7.1 , in windows phone 8 longlistselector.

i found question connect windows phone , windows 8 apps sql server quiet helpful me.

i think need step-by-step guide how-to. ask if there step-by-step guide how connect wp8 , sql server? if kind , edit code here make work.

thank time reading , answers/comments.

m.s.

well, achieve goal, do:

1. build rest webservice asp.net web api (http://www.asp.net/web-api) returns objects (those objects translated json automatically). example:

   public class myobject  {   public string content { get; set; } } 

   controller it:

   public class testcontroller : apicontroller {   [httpget]   public myobject example() {     return new myobject() { content = "hello world!" };   } } 

2. use http client in win phone project:

   httpclient client = new httpclient(); client.baseaddress = new uri("http://mywebservice.com"); client.defaultrequest.headers.accept.add(new mediatypewithqualityheadervalue("application/json"));  using (var result = await client.getstreamasync("test/example")) {   var serializer = new jsonserializer(); // json.net serializer   using (var streamreader = new streamreader(result)) {     using (var jsonreader = new jsontextreader(streamreader))     {       var obj = serializer.deserialize<myobject>(jsonreader);       // can access obj.content content created webservice       // in example there "hello world!"     }   } } 

sure can create more complex objects (de)serialized. take @ web api tutorials.

within webservice can access database want.

edit if need more detailed answer, leave me comment.