Git Product home page Git Product logo

netautocode's Introduction

NetAutoCode,最新版本1.3

自动生成C#实体类和SQL Server的增删改查的存储过程

具体介绍:https://meta.appinn.net/t/topic/23913

自动生成实体类

注意

需要连接SQL Server才能使用

下载

蓝奏云,免登陆 密码:9zlh

更新

1.3版本变化

添加了多个数据库的账号密码单独保存功能

1.2版本变化

1、添加了配置文件,加密保存服务器密码等数据

2、添加了nvarchar、decimal等数据类型在存储过程定义时的精度控制,例如生成@longitude decimal(10,6) = 116.397128而不是@longitude decimal = 116.397128

3、优化了字符串模糊查询,例如生成where ISNULL(name, '') like '%' + @name + '%' ,而不是where name like '%' + @name + '%' ,防止裸查询结果不包含字段为null的数据,如果确实不需要null的数据,可以手动移除ISNULL方法

4、修复了数据库和表数量显示问题,添加了选中表的字段数量显示

5、优化了生成所选数据库所有实体类的速度

6、select查询时自动添加所有字段,方便在每个字段前面添加“--”来注释掉可能不需要的字段,例如密码等敏感字段

7、移除了生成所选数据库“所选数据库生成多个类文件(Alt+V)”的按钮,但保留了快捷键触发。因为不推荐每个表都新建一个类文件,把所有实体类放在一个类文件即可(例如TClass类文件)。即使因为业务需求有手动新增的实体类, 把它单独放在一个类文件里即可(例如TExpand类文件)

netautocode's People

Contributors

majorworld avatar

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.