Click here to Skip to main content
15,910,981 members

Comments by kyros88 (Top 4 by date)

kyros88 9-Jan-14 11:18am View    
ok..So as I wrote yesterday, by creating an ASP.NET project and adding a Silverlight-enabled WCF Service, can I connect my sql Database? (Am I right until now?). And if I can, how can I do this connection? Do you have any tut or something to read about this ? Should I create inside the WCF a string Connection and so on?..
kyros88 9-Jan-14 10:06am View    
I saw another tut, that say to open a new project in VS2010 and create a Database connection (through the ServerExplorer and click on Connect to a Database) Then a pop up appears. By inserting the Server name, sql server authentication and name of database CAN I connect remotely to my DB?

Moreover, there is a choice in this pop-up window that says Microsoft Sql Server(SqlClient) I change that to MysqDatabase, but when I try to write in this form, the form close.. Why is that happening? Am I missing something? (still working inside the silverlight app)
kyros88 8-Jan-14 15:46pm View    
ok I see your point! Can I go a little further?

I create an ASP.NET Empty Web Application. After that I Add a new item and insert an ADO.NET Entity Model. Generate from database. I used an already created connection (Not New Connection) (Pluralize or signularize generated objects names and include foreign keys.. selected both).
Now, do I have to create again the dabase exaclty as it is in hosting DB? How this will help me to grab the information from the server DB?

I saw this tutorial and doing this step by step:
(http://studentguru.gr/b/dt008/archive/2010/12/02/querying-a-database-on-windows-phone-7-using-wcf.aspx?pi127=1#comments)

My target is, people who have created an account through my web site, can login to my application. So, I need to grab the username and password (..and more..) from the server DB.
(I am using Visual studio 2010 and windows silverlight app).
kyros88 8-Jan-14 6:16am View    
Hello there,

I have the same problem, so I am trying this solution you are suggesting! But, there is a problem in "SqlCeConnection".. I see that you are using theses two asseblies
using System.Data.SqlTypes;
using System.Data.SqlServerCe;

Where can I found them?

I am trying to build a silverlight widows phone application in 7, 7.1