public int Add(TEntityType item)
{
var props = _mapper.GetProperties(item);
var attributes = from m in props select m.Name;
var parameterlist = from m in attributes select "@" + m;
string cmd = "insert into " + item.GetType().Name +
"(" + String.Join(",", attributes) + ")" + "values(" +
string.Join(",", parameterlist) + ")";
var MyType = typeof(TEntityType);
List <SqlParameter> sqlParameters = new List <SqlParameter>();
foreach (var attr in attributes)
{
PropertyInfo prop = MyType.GetProperty(attr);
object value = prop.GetValue(item);
sqlParameters.Add(new SqlParameter(attr, value));
}
return(SqlHelpers.ModifyDatabase(_connection, cmd, sqlParameters));
}
