public void InsertAndGetID <T>(T _Object, string schemaName = null, string tableName = null)
        {
            string query      = QueryMaker.InsertQuery(_Object, tableName) + "SELECT SCOPE_IDENTITY();";
            int    ID         = GetScaler(query);
            var    PrimaryKey = GetKeyProperty <T>();

            PrimaryKey.SetValue(_Object, ID);
        }
 public void Insert <T>(T _Object, string tableName = null)
 {
     ExecuteQuery(QueryMaker.InsertQuery(_Object, tableName));
 }