Git Product home page Git Product logo

Comments (4)

zqlovejyc avatar zqlovejyc commented on May 28, 2024

问题1:采用如下方式可以解决,原因是Oracle表和列添加“”格式后,必须保持大写的;
image

问题2:bug已修复,请查看更新;

问题3:这个不能说是框架的问题了,这个需要自己灵活使用了;

问题4:应该是你列名的问题,我看提示“未明确定义列”,我试了下如下,可以正常使用
image

问题5:Mysql里面没有FULL JOIN语法 这个需要使用期间不采用这个语法了,框架本身的目的也是解析出来正确的sql语句;

from sqlbuilder.

lishuangquan1987 avatar lishuangquan1987 commented on May 28, 2024

针对问题1,都加上标签,将列名转换为大写,这样很麻烦。能不能在获取列名时,自动将其转换为大写,还有,如下代码,针对oracle数据库,也存在大小写转换问题:

Print(
                SqlBuilder.Select<UserInfo>()
                          .OrderBy(u => new[] { "Id", "age" }, OrderType.Ascending, OrderType.Descending),
                "OrderBy排序 用法1-1",
                "OrderBy"
            );

image

from sqlbuilder.

zqlovejyc avatar zqlovejyc commented on May 28, 2024

不能说只针对Oracle进行全部大写,你可以把解析成的sql自己ToUpper一下即可;或者说在SqlIntercept这个拦截里面转换为大写;

from sqlbuilder.

lishuangquan1987 avatar lishuangquan1987 commented on May 28, 2024

谢谢你的解答,目前没有其他问题了

from sqlbuilder.

Related Issues (5)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.