alecgn/mssql-helpers

MsSqlHelpers is a library to improve MS SQL Server common development tasks, like generating parametrized bulk inserts to be used with ADO.NET, Entity Framework and Dapper, and more.

mssql-helpers's Issues

Schema support

Great tool! Thank you
When specifying a table schema e.g.

.SetTableName("uccx.AgentStateDetail")

TableName later gets braces added and that caused my inserts to fail

I removed the [ and ] where they are at the moment and did this but there's no doubt some better way:

    private string _TableName;
    public string TableName {
        get { return _TableName; }
        set
        {
            if(value.StartsWith("[") || value.EndsWith("]") || value.Contains("."))
            {
                _TableName = value;
            }
            else
            {
                _TableName= "[" + value + "]";
            }
        } 
    }

As I didn't want to do the mappings by hand as my columns and properties were consistent I added this so that I didn't have to do any mapping. Wondered if it might be a helpful addition

    /// <summary>
    /// Use this method to auto map by column name
    /// </summary>
    /// <returns></returns>
    public MapperBuilder<T> AutoMapping()
    {
        foreach (PropertyInfo property in typeof(T).GetProperties())
        {
            _mapper.Mappings.Add(property.Name, property.Name);
        }

        return this;
    }

Thank you :-)

Identity Inserts

Thanks for the great tool!

Is there a way to set the identity insert to on and then off after the query is run?