/// <summary>
/// 构造Access和Sqlite数据文件 SQL插入语句
/// </summary>
/// <param name="dataFieldTypes"></param>
/// <returns></returns>
public static string CreateInsertSql(DataFieldTypeCollection dataFieldTypes)
{
string fieldString = string.Join(",", dataFieldTypes.Select(item => item.FiledName));
string parameterNameString = string.Join(",", dataFieldTypes.Select(item => item.FieldParameterName));
string insertSql = $"insert into [mytable]({fieldString}) values({parameterNameString})";
return(insertSql);
}
/// <summary>
/// 创建参数列表
/// </summary>
/// <param name="dataFieldTypes"></param>
/// <returns></returns>
public static List <string> CreateParameterNameList(DataFieldTypeCollection dataFieldTypes)
{
return(dataFieldTypes.Select(item => "@" + item.FiledName).ToList());
}
