报错sql语句问题:
原因:默认是按sqlServer的语法。
解决:
增加一句代码。
SimpleCRUD.SetDialect(SimpleCRUD.Dialect.MySQL);
完整代码:
nuget引用 Dapper.SimpleCRUD 、 Mysql.Data
internal class LetterPronunce
{
IDbConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["defCon"].ConnectionString);
public LetterPronunce()
{
conn.Open();
SimpleCRUD.SetDialect(SimpleCRUD.Dialect.MySQL);
DefaultTypeMap.MatchNamesWithUnderscores = true;
}
public string record(string str)
{
var str2 = "";
if (string.IsNullOrEmpty(str))
return str2;
var rows = str.Split(new string[] { "\n" },StringSplitOptions.RemoveEmptyEntries);
var row0 = rows[0];
//var words = row0.Split('\t');
var idx1 = row0.IndexOf(" ");
var words=new string[] { row0.Substring(0,idx1),row0.Substring(idx1+1)};
var word = new Words() { Word = words[0], Pronunce = words[1] };
var id1 = conn.Insert(word);
}
}