public int Insert(IFilter valuesFilter)
{
string insertInto = string.Format("{0} ({1})",tableName, string.Join(",", columns));
var commandString = string.Format(InsertCommand, insertInto, valuesFilter.GetFilterString());
int id = -1;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand(commandString,connection))
{
id = (int)command.ExecuteScalar();
}
}
return id;
}
