public void TestHanaCreateTableScriptShorts() { IScriptBuilder builder = new ScriptHanaBuilder(); var connStr = ConnectionStringReader.GetConnstring("hana"); var conn = new HanaConnection(connStr); var sql = $@"SELECT [OUSR].[USER_CODE], [OUSR].[USERID], [OUSR].[U_NAME], [dpto].[Name] as [DepartmentName], [OUSR].[Department], [OUSR].[GENDER], [OUSR].[objType], [OUSR].[userSign], [OUSR].[SUPERUSER], [OUSR].[updateDate] FROM [OUSR] left join [OUDP] [dpto] on [dpto].[Code] = [OUSR].[Department]" .Replace("[", "\"").Replace("]", "\""); var users = conn.Query <OUSR>(sql); }