Related
Hi guys,
I'm looking forward to building apps with WP7 using SQL Azure database
I can build apps with WP7 and have my SQL Azure database ready, but I don't know how to query data from Azure to my WP7 client
So far I don't find any tutorial on this topic yet
Any help would be greatly appreciated
Thanks
huy302 said:
Hi guys,
I'm looking forward to building apps with WP7 using SQL Azure database
I can build apps with WP7 and have my SQL Azure database ready, but I don't know how to query data from Azure to my WP7 client
So far I don't find any tutorial on this topic yet
Any help would be greatly appreciated
Thanks
Click to expand...
Click to collapse
I don't have an Azure account to test, but don't you just connect to an Azure SQL server the same way you do a regular one?
Code:
string _connectionString = "Server=tcp:[serverName].database.windows.net;Database=myDataBase;User ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False;Encrypt=True;";
using(SqlConnection conn = new SqlConnection(_connectionString)) {
conn.Open();
...
}
Replacing the information in _connectionString for your Azure account obviously. You can find all necessary connection strings here:
http://www.connectionstrings.com/sql-azure
Blade0rz said:
I don't have an Azure account to test, but don't you just connect to an Azure SQL server the same way you do a regular one?
Replacing the information in _connectionString for your Azure account obviously. You can find all necessary connection strings here:
http://www.connectionstrings.com/sql-azure
Click to expand...
Click to collapse
Yep.
Oh an NO EXCUSES for not having an Azure account!
For all of you independent software developers out there, you can get a full Azure instance for FREE.
Just sign up for BizSpark:
http://www.microsoft.com/bizspark/default.aspx
Yes, it is legal and if you are developing software, you you qualify. Basically, BizSpark gets you a full MSDN account, including Azure for free.
Not bad...
BTW, get started on SQL Azure here: http://www.microsoft.com/en-us/sqlazure/whitepapers.aspx
Hi,
I'm currently registered as an individual software developer in germany.
Do I have to use my own name as "Startup Name"? How is the general
process with BizSpark? What do I fill in for "Date/Month founded"? The
date when I registered as developer in germany? I read about the
sponsorship network partner you need to approval. What about this?
I contacted one of the partners OCC Bangalore for more info.
toolsche said:
Hi,
I'm currently registered as an individual software developer in germany.
Do I have to use my own name as "Startup Name"? How is the general
process with BizSpark? What do I fill in for "Date/Month founded"? The
date when I registered as developer in germany? I read about the
sponsorship network partner you need to approval. What about this?
I contacted one of the partners OCC Bangalore for more info.
Click to expand...
Click to collapse
PM Sent on BizSpark
I would like to know the same about the process of the BizSpark. I'm interested in using SQL Azure.
Probably not a good idea. Unless you don't mind giving access to anyone with Reflector your connection string. (A read-only account with V. limited priv's for example).
Might be better to host a webservice and make requests to that webservice using one of the many Client - Server frameworks (WCF, JSON, etc) available.
That way the client calls a method on the webservice which queries the Azure data and then returns it to the client. The client then know's nothing about the database.
nTier might seem a bit much, but a hacker with your database login could be worse .
Everyone knows this url:
catalog.zune.net /v3.2/ en-US/apps?clientType=WinMobile%207.0&store=<storename>
But I haven't found a complete list of store names yet, so I wanted to start one. Help is appreciated!
TMODE - T-Mobile Germany
Samsung - Manufacturer store
HTC - Manufacturer store
LGE - LG Electronics Manufacturer store
Dell - Dell Manufacturer store
ATT - US AT&T
TMOUS - T-Mobile US
Starhub - Starhub Singapore
O2ODE - O² Germany
I would be especially interested in the store name of SingTel...
Maybe someone knows the store name for "Orange UK"?
"ATT" for US AT&T
"TMOUS" for T-Mobile US
Does someone know the name for Telstra? I'd like to have a look at Whereis Navigator...
Download the garmin xap from the US store, it contains resources for the Whereis app and may be useful to you (unless you want to use the xap to navigate of course)
Telus
Hades32 said:
Does someone know the name for Telstra? I'd like to have a look at Whereis Navigator...
Click to expand...
Click to collapse
In america TELUS
What is the purpose of this? I have sprint if you tell me how find it Ill try to post
Singtel and M1 Singapore.
does someone knows the register key to change the provider? I can't find it anywhere on the forum..
What about NOKIA?
HKLM\System\Platform\DeviceTargetingInfo\MobileOperator
Be carful with changing the MobileOperator. Doing it too often, it will invalidate DRM store (and ANY marketplace application will stop working).
There is a topic about this on xda.
-tobias
NOTE: The following guide is not my work it belongs to surya467 - Dexter's Lab. I found it in the lumia 800's section. And since it is valid for all wp7 devices i thought about sharing it here! Mods please don't hit me with any infraction.
THE GUIDE
So here is how to register your phone as a developer phone FOR FREE....You can deploy only 3 .xaps to your device since you are verified as a student, also u can unlock 3 Windows phone using 1 Live ID.
Part I - Getting a .edu email id for FREE
Step 1
You need to sign up, https://eims.maricopa.edu/MAW/MAW.html here.
At the signup page, you need to tick, "I am a new student and have never attended any Maricopa Community College or Skill Centers." this option, then fill in the captcha and continue.
Step 2
Next you need to give personal information, make sure you give your real information, except thePost code SSN which probably everyone doesnt have, so u can generate a FAKE SSN, http://www.fakenamegenerator.com/soc...ity-number.php here, and post code, you could just google up for a post code of "Arizona" or probably any postcode in the US would do.
Step 3
After you finish signup, you will get an MEID, a email, and a password. Save it in notepad.
Now there is a trick, go to https://eims.maricopa.edu/MAW/lookup.pl?req=passwd , click NO, den put ur details der, put the same password as before
Now try to loggin to www.maricopa.edu/google/ or goto https://mail.google.com/ and use the Email and password.
It takes almost 2-3 days to get active so don't worry if it doesnt work at the 1st attempt.
Part II - Getting a Dreamspark account using the .edu email
Step 1
Once you get access, goto https://www.dreamspark.com/ and you need a live account to login with, so you use the live account to which you want to unlcok your WP7 device, duh!
Step 2
Goto get verified, use school as "Chandler/Gilbert Community College" and state as "Arizona". Now fill out the rest of the information and when it asks for the email address, use the .edu email address you obtained from 'Part I'.
Step 3
Once your done here, you should get a verification email in your .edu email, so go chek it out there and click on the verification link.
Now you have an edu email and a dreamspark account!!
Part III - Create an Apphub account and link it to your Dreamspark LiveId.
Step 1
After Dreamspark is verified, go to App Hub - home register your Windows Live ID and signup as a student. It will ask if you have a verified Dreamspark account.
Step 2
Download the Windows phone developer tools from AppHub or from here
http://www.microsoft.com/download/en....aspx?id=13890
Step 3
Run the Windows Phone Developer Registration tool. Sign in with Windows Live ID you registered at AppHub, connect your phone and make sure it is not screen locked, viola, your WP7 device is now unlocked using a verified developers id.
And you can unlock 2 other Windows 7 phones too for a total of 3 phones.
Not to mention you can submit your apps to microsoft through this apphub account.
Here's a link to original thread if you like - http://forum.xda-developers.com/showthread.php?t=1551057
Why would you repost this..... The other thread is still alive and well.
the whole wp7 community doesnt check the lumia section.. thats why i posted it here!
Do NOT post duplicate threads, and do not knowingly break rules (and then ask the mods to do nothing)....
Closed.
Hello!
I'm software developer from Russia, and made one very popular app in local market. Very soon I realized that I need an ability to give licensed version of app for my friends or reviewers or someone else.
Unfortunately AppHub doesn't provide such functionality(private distribution is pain in ass), so I created a webservice for myself.
After two days I realized that it may be useful for other developers, so here it is:
promo.g33k.ru (here I wanted to post url, but I can't due to low post count. You may find it in my profile->interests)
Now it has:
- JSON/SDK with RSA1024/SHA1 sign for additional security checks
- Binary SDK available
- Russian localization(if anyone cares ) (btw, if you can help translating to other language(s) or correct english misspellings - i will appreciate this).
Now this service works in beta mode.
So for developers I have two questions:
1) Is such service useful for you?
2) How to develop it further, in which way?
Not yet clear
I am sorry, but after reading your post and also checking your website I am still not sure what you offer. For me there is just not enough information to understand and then judge the usefulness of your service.
Maybe you could give a step-by-step scenario: Dev does this, then interested user does that, dev then this ...
Ok, I'll try to describe a little more details:
1) Developer wants to add capability of promo codes in his app(to give some specific users full licensed app).
The first problem is that developer need his own server for checking of promo code validity(hardcoding is not an option, of course).
2) So, Developer registers in my service, add his app's guid to his app list and create a promo code for specific app via web.
3) Developer adds support for promo codes in his app by:
a) adding an text box for user to enter promode
b) adding a web request to specific URL for promocode activation
c) adding to his license check web request for checking is current user activated a promo code.
Benefits for developer:
- Add support for promo codes without owning a server.
- Simple way to give full version of program to friends
Benefits for users:
- User may found promo code for specific app somewhere and use it to get full version of app in simple manner.
Benefits for reviewers/portals:
- Developers can easily give promo code for reviewing purpose or as giveaway for news post.
Clear now
Thanks for the additional info, now it's clear
Well yes, sounds useful. Properly implemented is probably really easier than Microsoft's "closed beta" mechanism, and of course can be used for other, non-beta apps as well.
The icing on the cake would be a "frame application" as sample code that basically does nothing more than asking for a promo code and then check against the list of valid codes on your server.
Sounds intresting but how do you ensure security?
chabun, I thought about security and situation is same as with default checking for trial - there is no security Man-in-the-Middle and direct cracking of xap will work, and there is no way out. I could use RSA signing for MitM, but still cracking of xap is very easy option today, so no one really interested will try to use MitM. When WP8 SDK will be out(I believe it will be in several weeks) - some developers may implement trial checks in native code - this will be much harder to crack.
As for server part there are following possible problems
- App's ID squatting(same as domain, someone else could reserve developer's app's guid). Don't know yet what to do with this, may be think about it later when this happens?
- Promocode's for App ID bruteforce - could be easily avoided via server throttling, if this ever happens - i'll add such checks
- Server DDoS - every webmaster's nightmare, I hope this never happens(or my Amazon AWS will pour my purse empty
rbrunner7, nice idea, I'll add a sample app as soon as possible on site.
This looks like an interesting concept
Sent from my SGH-i917 using XDA Windows Phone 7 App
Yop, you can never avoid direct cracking... However, RSA signing would be good I'd say as it will avoid MitM - with MitM you could create simple tools which can be used by every noob outhere. Cracking xaps requires some skill and it will need an unlocked WP7 as well.
I can see this working i have been thinking about something similar also. You can encrypt the data on device before sending it off to the cloud, you can than verify the encrypted data with a password and compare it to the codes registered on the server. Than link a code to a certain device id (once the code becomes 'registered') if a certain code is already coupled to a deice id and the device is not the same than the app will jump back into trial mode. Otherwise one can use the paid mode.
This can defenetly work and will prevent reselling th codes. Although it requires a server. And users can still hack/patch the app ofcourse but that will require an unlocked device so I should not worry to much about it.
Also to prevent spoofing you can frequently check with the server if this device is legitetmately registered.
Marvin_S said:
I can see this working i have been thinking about something similar also. You can encrypt the data on device before sending it off to the cloud, you can than verify the encrypted data with a password and compare it to the codes registered on the server. Than link a code to a certain device id (once the code becomes 'registered') if a certain code is already coupled to a deice id and the device is not the same than the app will jump back into trial mode. Otherwise one can use the paid mode.
This can defenetly work and will prevent reselling th codes. Although it requires a server. And users can still hack/patch the app ofcourse but that will require an unlocked device so I should not worry to much about it.
Also to prevent spoofing you can frequently check with the server if this device is legitetmately registered.
Click to expand...
Click to collapse
That's what I thought of... private/public key
chabun, so, for example, how about following scenario:
for each developer server creates public/private key pair.
when checking license on server: if success server encodes userid with developer private key
when checking license in app: server response decoding via public key(hardcoded in app) and comparing to userId. if ok -> licensed.
You might want to ask @ngreader guys on twitter. They do have this concept implemented in their app.
diverofdark said:
chabun, so, for example, how about following scenario:
for each developer server creates public/private key pair.
when checking license on server: if success server encodes userid with developer private key
when checking license in app: server response decoding via public key(hardcoded in app) and comparing to userId. if ok -> licensed.
Click to expand...
Click to collapse
I'm not sure if it would be good to encode the request to the server as well but otherwise it sounds really cool now... I'll use this service when I need this (and tell my friends about it)
Here is one way to do it http://stackoverflow.com/questions/599837/how-to-generate-and-validate-a-software-license-key
wpxbox said:
Here is one way to do it http://stackoverflow.com/questions/599837/how-to-generate-and-validate-a-software-license-key
Click to expand...
Click to collapse
Well, what they suggest is not as good as diverofdark's service which is a lot more secure and still easy to use for the customers...
Greetings everyone!
Today I updated promo.g33k.ru, now it has:
- more detailed about page,
- SDK now includes RSA1024/SHA1 sign for additional security checks
- Binary SDK available
- Russian localization(if anyone cares ) (btw, if you can help translating to other language(s) or correct english misspellings - i will appreciate this).
- Many minor bugfixes.
So, from now this service works in beta mode
diverofdark said:
Greetings everyone!
Today I updated promo.g33k.ru, now it has:
- more detailed about page,
- SDK now includes RSA1024/SHA1 sign for additional security checks
- Binary SDK available
- Russian localization(if anyone cares ) (btw, if you can help translating to other language(s) or correct english misspellings - i will appreciate this).
- Many minor bugfixes.
So, from now this service works in beta mode
Click to expand...
Click to collapse
Thanks! I will check this out
Hey diverofdark
It would be nice if you update the first post in the thread with all information. That's the way it's usually done in the forum.
A possible user (here dev ) can read it and without having to browse the whole thread, he can use your promocode service...
Thanks for mentioning it, I updated the first post.
When i am opening my browser of sense2.1 latest european rom...and type anythng in google there is a message as below..plz suggest
403. That’s an error.
Your client does not have permission to get URL /search?hl=en&sky=ee&ie=ISO-8859-1&q=wildfire&btnG=Search from this server. (Client IP address: 106.79.92.162)
Please see Google's Terms of Service posted at http://www.google.com/terms_of_service.html
If you believe that you have received this response in error, please report your problem. However, please make sure to take a look at our Terms of Service (http://www.google.com/terms_of_service.html). In your email, please send us the entire code displayed below. Please also send us any information you may know about how you are performing your Google searches-- for example, "I'm using the Opera browser on Linux to do searches from home. My Internet access is through a dial-up account I have with the FooCorp ISP." or "I'm using the Konqueror browser on Linux to search from my job at myFoo.com. My machine's IP address is 10.20.30.40, but all of myFoo's web traffic goes through some kind of proxy server whose IP address is 10.11.12.13." (If you don't know any information like this, that's OK. But this kind of information can help us track down problems, so please tell us what you can.)
We will use all this information to diagnose the problem, and we'll hopefully have you back up and searching with Google again quickly!
Please note that although we read all the email we receive, we are not always able to send a personal response to each and every email. So don't despair if you don't hear back from us!
Also note that if you do not send us the entire code below, we will not be able to help you.
Best wishes, The Google Team
/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/k5fvA2I66JbZwNlbWR30BXRdrHXiq755jzFYIxHKZk7n5nT_m G3aT0FK5QxgMWm0kmH41qW_cvO6pTegMrRGT5-wayz1A4CGBE OnhawbsjlCPdnaoDYI-i_MfJDJWijNeEwKeLBZj3cCF-cY0Ji MW8eAcNj3GWivAh8S09rIg5xMyKJdm4oOeKyMJ1rMG9khJHxL pmRilz1OvvNIFVVLEu4a9VGDG9SNl_DMfbf0pW9sqGhO21KFO 07u7gJIUoWGiN2W5IR4fMwT5vK_NfuioRJ8DJg_8cBYXy6Kss 1h_O3VaYlylGwilxMG5m19gwtZzD_4iWHeKgji-qTN7dUKKyh 8lI15uySZX1y2vn9_3OghK_uDL4YpUsOqAs7TJUgvhaFm7MUP tI_oWQMt9jVxWSped7m5AzFwjp74iaB5m-dYM47rDNbtBaZNv 1n-DRI4Yndqa0Lbtf9tRaUix2wsmJqB2Mhtvf3Cb1ArZ9P7ds 4lI9W2c3XNJcQzbXvEydYumbd7BJYYiSY2Ox28a2mqsU-eLWH pLMNcRvFpkOF-BiGwhGQfUiRdsJI4nsA5k1gdBs6EtLgqEvo8 qGJ49UbISWyGjQ0NP_YxwB0-x3KnMh7Q8CbxvXQlu-SGA6zgd lCCCLOtwdWqHKjjZR8xGWOvmoez03DNYXRuDAt_td9KQLo9DI ER-_HW3K2DUrdG5zQUXuouP2Lb_ve9xF-F6yjJnqFdkDAK9FI BqyLbTjoKSJAs4ffbKLjFwGzEIqSiXmLPXT6AGBFnfEH1Zmqx p7sMmFAPamQL4AuSmIV2sQHjMNuLNZEoGQErBa-tPkdaZg0lT l3eyrLKEzlK_AUMBiz5PtADWqlNdX4xFXgkkgDSw8yW4PJei3 tFkdOnst7neDJo1veqG5FFed_78E5YQguhLfdIcqQ8uF42xqa Nz5Bv6m5sdwM5SyewpquafrEK5NCkqRk1WsVwCDQd1BHyOqSy sS-QlQTcd0_faH9Aku-Dnr0FPZ-7K8-jfXdLTox5I-eH3daIe fo3M-S-_x49m4BoNxpuF-vzhuxRt3OJ-vALhGDc6b4mykI_LG s-d9gLcttt5Y5okzSxlBnVaAsqsSqnPNpGfGoBzradjPSZOh7 spajeUff0SgFHKmwEvVlg3FFJO3k7-hnS5s3YGKd9Wmhsxrdz ifrwC4RgGbsqKTMMUEQyUotX9118jc0_CYfvrpucVLMFztBCe nThy-jZJ6AVjmDdviBU_-3LwG8VeqH6GC_8uVooTHmaQ-JoOX _lpqTz0tNi3RIBMubZy-Yvomwv-LofCZ1SmFy04wdIKXE6Zq2 yD_MIRrJeyVsZ8WNA8rRH5HikdIBbx_O7QWh55pj55BTjeTHk css-yNPEVFjoacSBK7Q2duzCwOvzCW4OQ8x-932_7rrpOdfqA -_oNXksLeMid6B8tgroOFXD5IPXPC8EDIX7Z94SgaAR5qiJFb SCPi3FonIak3ho7PV2PFe8dSqCJYNgQn66hpFiv01enkrlU-N xB8BOO_i-QOQszn6uvKIvkY1kYQ2pFSQqBa9GSNz6ojDEM7po 2lolAQ0CPd5bS4eu +/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+/+ That’s all we know.
Sent from my HTC Wildfire S A510e using xda app-developers app