我正在使用 synapse pay API,作为回报,我得到了一些响应。我想将该响应保存在 SQL 数据库中。
我为此创建了课程。
下面是获取响应的代码
var httpWebRequest = (HttpWebRequest)WebRequest.Create("https://sandbox.synapsepay.com/api/v2/user/create");
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string json = "{\"email\":\"[email protected] /cdn-cgi/l/email-protection\"," +
"\"fullname\":\"nik\"," +
"\"phonenumber\":\"111\"," +
"\"ip_address\":\"1.1.1.1.1\"," +
"\"password\":\"123123123\"," +
"\"client_id\":\"1111111111111111\"," +
"\"client_secret\":\"2222222222222222222\"}";
streamWriter.Write(json);
streamWriter.Flush();
streamWriter.Close();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
var result = streamReader.ReadToEnd();
}
}
我的 Json 响应
"{
\"expires_at\": \"1438381449\",
\"expires_in\": \"5184000\",
\"oauth_consumer_key\": \"tDOIKwdgJzSzbCQdpo9FGNCBV6cSDTAlJqdtBHg3\", \"refresh_token\": \"HxJWdwgrNchJHn5zviAO7nd141ALYXmSbNmuG5ZF\",
\"success\": true,
\"user_id\": 10212,
\"username\": \"1433197449c2630fc917ef4d2b846f\
"}"
这是我的 external_account 表
public partial class ExternalAccount
{
public ExternalAccount()
{
this.UserProfileExternalAccount = new HashSet<UserProfileExternalAccount>();
}
public int ExternalAccountId { get; set; }
public string Name { get; set; }
public string Description { get; set; }
public string ExternalId { get; set; }
public string oAuthToken { get; set; }
public string oAuthTokenSecret { get; set; }
public string oAuthKey { get; set; }
public string oAuthSecret { get; set; }
public string Username { get; set; }
public string ClientId { get; set; }
public string ClientSecret { get; set; }
public string RefreshToken { get; set; }
public string oAuthConsumerKey { get; set; }
public bool IsActive { get; set; }
public System.DateTime WhenAdded { get; set; }
public System.DateTime WhenUpdated { get; set; }
public string AddedBy { get; set; }
public string UpdatedBy { get; set; }
public int type_ExternalAccountStatusId { get; set; }
public virtual type_ExternalAccountStatus type_ExternalAccountStatus { get; set; }
public virtual ICollection<UserProfileExternalAccount> UserProfileExternalAccount { get; set; }
}
}
使用上面的类我创建了我的表..
我是 C# 新手,有人可以告诉我如何解析 json 并将其存储在数据库中。
如果我写的有什么不对的地方请指正..