資源簡介
代碼片段和文件信息
using?MySql.Data.MySqlClient;
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Threading.Tasks;
using?Dapper;
using?System.Text;
using?Microsoft.Extensions.Configuration;
using?System.IO;
namespace?NETCoreMySQL
{
????public?class?Program
????{
????????public?static?void?Main(string[]?args)
????????{
????????????Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);???????????
????????????MySqlConnection?con?=?new?MySqlConnection(“server=127.0.0.1;database=test;uid=root;pwd=;charset=‘gbk‘;SslMode=None“);
????????????//新增數據
????????????con.Execute(“insert?into?user?values(null?‘測試‘?‘http://www.cnblogs.com/linezero/‘?18)“);
????????????//新增數據返回自增id
????????????var?id?=?con.QueryFirst(“insert?into?user?values(null?‘linezero‘?‘http://www.cnblogs
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????????94??2016-09-21?17:22??global.json
?????文件????????1478??2016-09-21?17:22??NETCoreMySQL.sln
?????文件?????????204??2016-09-21?17:22??README.md
?????文件?????????257??2016-12-26?09:04??sql.txt
?????目錄???????????0??2016-09-21?17:22??src\
?????目錄???????????0??2016-09-21?17:22??src\NETCoreMySQL\
?????文件????????1244??2016-09-21?17:22??src\NETCoreMySQL\NETCoreMySQL.xproj
?????文件????????1675??2016-09-21?17:22??src\NETCoreMySQL\Program.cs
?????文件?????????492??2016-09-21?17:22??src\NETCoreMySQL\project.json
?????目錄???????????0??2016-09-21?17:22??src\NETCoreMySQL\Properties\
?????文件?????????824??2016-09-21?17:22??src\NETCoreMySQL\Properties\AssemblyInfo.cs
?????文件?????????320??2016-09-21?17:22??src\NETCoreMySQL\User.cs
- 上一篇:c# sql批量導入數據
- 下一篇:.NET MVC2 完整博客系統源碼
評論
共有 條評論