摘要： Top number of recordsSELECT column_nameFROM table_nameLIMIT 5;Like/Not LikeSELECT * FROM CustomersWHERE Country NOT LIKE '%land%';InSELECT column_nameFROM table_nameWHERE column_name IN ('value1', 'value2',...);Between.. And..SELECT column_nameFROM table_nameWHERE column_name 阅读全文

摘要： A private constructor is a special instance constructor. It is generally used in classes that contain static members only. If a class has one or more private constructors and no public constructors, other classes (except nested classes) cannot create instances of this class. For example:public class 阅读全文

摘要： Isolated Storage Explorer is installed in the following location:Program Files (x86)\Microsoft SDKs\Windows Phone\v8.0\Tools\IsolatedStorageExplorerToolIsolated Storage Explorer has the following syntax:ISETool.exe []product-idSpecifies the ProductID from the WMAppManifest.xml file for the app th... 阅读全文

摘要： Next week task is to learn how generic enumeration interface works, try to build a sample and write blog herereference:illustrated_c_2012_2nd_edition461 (466 / 750) 阅读全文

摘要： A WebClient façade class for simple download/upload operations via HTTP or FTPWebRequest and WebResponse classes for low-level control over client-side HTTP or FTP operationsHttpClient for consuming HTTP web APIs and RESTful services1. Concurrent requestsvar client = new HttpClient();var task1 阅读全文

摘要： 1.Consume REST web services from app2.De-serialize JSON into an in-memory object collection3.Save data offline using SQLite4.Capture,change and manipulate local data based on business requirement and then upload5.Password protect and encrypt local dataBitLocker+PIN 阅读全文

摘要： HTTP works as a request-response protocol between a client and server.A web browser may be the client, and an application on a computer that hosts a web site may be the server.Example: A client (browser) submits an HTTP request to the server; then the server returns a response to the client. The res 阅读全文

摘要： 1. get JSON responses and go to : http://json2csharp.com/2. write data contracts using C#All classes need to have a DataContract attribute, and all public properties that are to be serialized need to have a DataMember attribute, and both a getter and a setter in C#using System.Runtime.Serialization. 阅读全文

摘要： DataContractAttributeClass is in theSystem.Runtime.Serializationnamespace.But you should add reference toSystem.Runtime.Serialization.dll 阅读全文

摘要： [Table] public class AddTableNameHere : INotifyPropertyChanged, INotifyPropertyChanging { // // TODO: Add columns and associations, as applicable, here. // // Version column aids update performance. [Column(IsVersion = true)] private Binary _version; ... 阅读全文