C# (CSharp) ActiveQueryBuilderApi Examples

Example #1

File: HomeController.cs Project: ActiveDbSoft/webapi-active-query-builder-web-client

        public ActionResult Index()
        {
            ActiveQueryBuilderApi api = CreateApiInstance();

            SqlQuery           query  = new SqlQuery(_guid, _sql);
            List <QueryColumn> fields = api.GetQueryColumnsPost(query);

            return(Json(fields));
        }

Example #2

File: HomeController.cs Project: ActiveDbSoft/webapi-active-query-builder-web-client

        public ActionResult Index(Transform transform)
        {
            transform.Guid = _guid;
            transform.Sql  = _sql;

            ActiveQueryBuilderApi api    = CreateApiInstance();
            TransformResult       result = api.TransformSQLPost(transform);

            return(GetDataMysql(result.Sql, result.Totals));
        }