Exemple #1
0
        public void Insert(Entity item)
        {
            var sqlTokens = new SqlTokens(item.GetDictionaryInDbStyle(true));
            var sql       = "insert into " + item.TableName
                            + " (" + sqlTokens.AsColumnNames(false) + ") select " + sqlTokens.AsIndcies(false) + " from dual";

            using (var connection = CreateOrReuseConnection())
            {
                using (var command = CreateCommand(sql, connection.GetAdoConnection()))
                {
                    AddParameters(command, sqlTokens.GetNonNullableFieldsAndValues(), 0);
                    command.ExecuteNonQuery();
                }
            }
        }