Exemplos de Lemon.Transform SqlTransformDataReader em C# (CSharp)

Exemplo n.º 1

Arquivo: DefaultTransformEngine.cs Projeto: dream-365/lemon

        private ITransformDataReader CreateSqlDataReader(DataInputModel source)
        {
            var temp = source.Connection.Split('.');

            var logicDbName = temp[0];

            var queryName = temp[1];

            var connection = new SqlConnection(_connectionStringProvider.GetConnectionString(logicDbName));

            var sql = SqlNamedQueryProvider.Instance.Get(queryName);

            IDictionary <string, object> parameters = Newtonsoft.Json.JsonConvert.DeserializeObject <IDictionary <string, object> >(source.Filter);

            var reader = new SqlTransformDataReader(connection, sql, parameters);

            reader.SetPrimaryKey(source.PrimaryKey);

            return(reader);
        }

Exemplo n.º 2

Arquivo: DefaultTransformEngine.cs Projeto: dream-365/lemon

        private ITransformDataReader CreateSqlDataReader(DataInputModel source)
        {
            var temp = source.Connection.Split('.');

            var logicDbName = temp[0];

            var queryName = temp[1];

            var connection = new SqlConnection(_connectionStringProvider.GetConnectionString(logicDbName));

            var sql = SqlNamedQueryProvider.Instance.Get(queryName);

            IDictionary<string, object> parameters = Newtonsoft.Json.JsonConvert.DeserializeObject<IDictionary<string, object>>(source.Filter);

            var reader = new SqlTransformDataReader(connection, sql, parameters);

            reader.SetPrimaryKey(source.PrimaryKey);

            return reader;
        }