DynamicObject

Documentation

This example uses Oracle HR schema.

Code

Method that returns a dynamic object with all fields based on informed SQL statement.

// Metodo que retorna um objeto dinamico com todos os campos baseado na instrução SQL informada.
// Method that returns a dynamic object with all fields based on informed SQL statement.
// param name="strQuery" Instrução SQL / SQL Statement
// param name="DataBase" Banco de Dados / DataBase
// param name="EnablePascalCase" Habilita Formamatação em Pascal Case / Formatting enables Pascal Case
using (var Ecrud = new ECRUD.OracleDynamic())
{
    StringBuilder sbQuery = new StringBuilder().Append("SELECT * FROM HR.EMPLOYEES WHERE EMPLOYEE_ID = 200");

    var Employees = Ecrud.DynamicObject(sbQuery.ToString(), DataBase.HR, true);
}