Database.NET

Database .NET???款å??è´¹ä????½å¼ºå¤§ç??å¤??°æ?????å·¥å?·ï?该软件è????è¾?å®??¨ç??ï¼???ä¾??´ç????¹ä¾¿??????????¢æ?è§??°æ?????容ï???é¡»å?þ@?å®?è£??´ä¸ª?°æ???ç³»ç?ï¼??³å???´æ?¥æ???°æ??è¿?ç¨?è¿?è¡??°æ??????¨çº¿å­???ï¼??¹ä¾¿?°æ???è°?è¯?ï¼?ä¿??¹ï??¥è?ï¼?????/a>ï¼?è¾??ºï?å¤?份â?þ>?å¤??¹é?¢å???????è¦????¨æ?·å???´æ?¥å?¨æ???ä¸?è½?/a>ï¼?

Database.NET?????°æ???ç§?ç±?/h3>

1??MSAccess97-2003 ï¼?*.mdb;*.*ï¼?

2?? MS Access 2007 ï¼?*.accdbï¼?

3??MSExcel97-2003 ï¼?*.xlsï¼?

4??MS Excel 2007 ï¼?*.xlsxï¼?

5?? Firebird ï¼?*.gdb;*.fdbï¼?

6??MySQL 5.x or later

7??SQL Server

8??SQL Server CE 3.5sp1 ï¼?*.sdfï¼?

9??SQLite ï¼?*.db;*.db3;*.sqliteï¼?

10??PostgreSQL

11?? Oracle

12??dBASE IV ï¼?*.dbfï¼?

Database.NET?¹è?²å????/h3>

1???´å??????å¤?ç§??°æ???å¹³å?°ï???ä¸???件æ?¹ä¾¿?ºå¸¦ä¸?使ç??/p>

2??????è¯??é«?äº??¾ç¤ºï¼?Syntax Highlightingï¼?

3???°æ??????¨å??å¤???ï¼?Automaticallyï¼?ï¼? ??é¡»é??è¿?SQL?½ä»¤??å¤??¨æ?§è?

4??å¯???ä¿??¤ï?Protect Databaseï¼?ï¼? Access 97-2003/Access 2007/SQL Server CE/SQLite

5?????¨æ?°å»ºï¼?Create Databaseï¼?ï¼? Access 2000/Access 2007/Firebird/SQL Server CE/SQLite

6??????a href="/r/ysrj" target="_blank">??ç¼?/a>ï¼?Shrink Databaseï¼?ï¼? Access 97-2003/Access 2007/Firebird/MySQLï¼?MyISAMï¼?/SQL Server/SQL Server CE/SQLite/PostgreSQL

7??å¤?份è???ï¼?Backup/Restore Databaseï¼?ï¼? MySQL/SQL Server/PostgreSQL

8??????代ç?????¨ç????ï¼?Code Generationï¼?ï¼? Access/Firebird/MySQL/Oracle/PostgreSQL/SQL Server/SQL Server CE/SQLite

9 ???????°æ??????¡ç???ï¼?Service Managerï¼?ï¼? Firebird/MySQL/PostgreSQL/SQL Server

10??????å¤?页ç??¥è?ï¼?Multiple Query Tabï¼?ï¼? å¤?页ç?ç»????¾ç¤ºï¼?Multiple Resultï¼?

11????????ä¾???件ç???ï¼?SQL Example Managerï¼?

12?????????¾æ?°æ?????è½½ï?DragDrop Databaseï¼?

13??ç»???è¾??ºï?Export to CSV/XML/TXTï¼?

14??å¤??½è?è¨??¾ç¤ºï¼?Multiple Languageï¼?ï¼? é¢?设中?±æ??ï¼?并å??????©å??

15??ç»??????°ï?Print query resultsï¼?

Database.NETå¿??·é??/h3>

(sqlç¼?è¾???/a>sql editor) ?§è?execute: f5, ctrl + e, alt + x

(sql ç¼?è¾???ql editor) ?§è?å½?????è¿°å?execute current statement: ctrl + enter

(sql ç¼?è¾???ql editor) ?°å??¥è?new query: ctrl + n

(sql ç¼?è¾???ql editor) ?³é???¥è?close query: ctrl + f4

(sql ç¼?è¾???ql editor) ä¿?å­?save: ctrl + s

(sql ç¼?è¾???ql editor) ???cut: ctrl + x

(sql ��??ql editor) �??opy: ctrl + c

(sql ç¼?è¾???ql editor) è´´ä?paste: ctrl + v

(sql ç¼?è¾???ql editor) ?¨é??select all: ctrl + a

(sql ç¼?è¾???ql editor) 復å??undo: ctrl + z

(sql ç¼?è¾???ql editor) ????redo: ctrl + y

(sql ��??ql editor) ??�ind: ctrl + f

(sql ç¼?è¾???ql editor) ??ä»?eplace: ctrl + h

(sql ç¼?è¾???ql editor) è·³è?³æ??å®?è¡?goto: ctrl + g

(sql ç¼?è¾???ql editor) ?¥è??¢ç????uery builder: ctrl + q

(sql ç¼?è¾???ql editor) sql?¼å???sql formatting: ctrl + m

(sql ��??ql editor) 主解comment: ctrl + shift + c

(sql ��??ql editor) ??�主解uncomment: ctrl + shift + u

(sql ��??ql editor) 以���示�??results to grid: ctrl + 1

(sql ç¼?è¾???ql editor) 以æ??å­??¾ç¤ºç»???results to text: ctrl + 2

(sql ç¼?è¾???ql editor) å°?ç»???å­?æ¡?/a>results to file: ctrl + 3

(sql ��??ql editor) �??��??ine open below*: ctrl + shift + enter

(sql ��??ql editor) �??��??ine open above*: ctrl + +

(sql ç¼?è¾???ql editor) 页籤?³é??lose tab*: middle-click

(sql ��??ql editor) ���???ext pane: f6

(sql ��??ql editor) ���???revious pane: shift + f6

(sql ��??ql editor) �??�??esults pane: ctrl + r

(???¨å???ä¸??ºè?½æ????utocomplete and intellisense(*)) ????nsert*: space, enter, tab, =

(???¨å???ä¸??ºè?½æ????utocomplete and intellisense(*)) ???ºæ????list members*: ctrl + j, shift

(???¨å???ä¸??ºè?½æ????utocomplete and intellisense(*)) ???ºç?å¼?????æ®?ist code snippets: ctrl + k

(???¨å???ä¸??ºè?½æ????utocomplete and intellisense(*)) 模å?????oggle completion mode: ctrl + alt + space

(???¨å???ä¸??ºè?½æ????utocomplete and intellisense(*)) ?ºè?½æ???¥å???oggle intellisense on or off: ctrl + i

(èµ???表ç?è¾?table designer) æ·»å????ä½?insert column: ctrl + n

(èµ???表ç?è¾?table designer) ???¤æ??ä½?delete column: delete

(èµ?????ç¼?è¾?data editor) ä¿?å­?save: ctrl + s

(èµ?????ç¼?è¾?data editor) ?·æ??efresh: f5

(èµ?????ç¼?è¾?data editor) ???copy: ctrl + x

(�????��data editor) �??opy: ctrl + c

(èµ?????ç¼?è¾?data editor) è´´ä?copy: ctrl + v

(èµ?????ç¼?è¾?data editor) ???¤å??delete row: delete

(èµ?????ç¼?è¾?data editor) 设置èµ?????ä½??ºç©º??et cell as null: ctrl + 0

(èµ?????ç¼?è¾?data editor) 移å?¨è?³æ?°å??move to new row*: ctrl + n

(èµ?????ç¼?è¾?data editor) cell ç¼?è¾???ell editor(*): ctrl + e

(èµ?????ç¼?è¾?data editor) form ç¼?è¾???orm editor(*): alt + v

(èµ?????ç¼?è¾?data editor) ?¹æ?æ±???mport: ctrl + i

(�????��data editor) ??�ind: ctrl + f

(èµ?????ç¼?è¾?data editor) 移è?³è?????goto: ctrl + g

(�??????�data browser) �??xport: ctrl + s

(�??????�data browser) �??opy: ctrl + c

(èµ???????è§?data browser) ?¨é??select all: ctrl + a

(�??????�data browser) ????a href="/r/dyrj" target="_blank">print: ctrl + p

(�??????�data browser) cell ??�??ellviewer: ctrl + v

(�??????�data browser) form ??�??orm viewer: alt + v

(�??????�data browser) ??�ind: ctrl + f

(èµ???????è§?data browser) 移è?³è?????goto: ctrl + g

(?©ä»¶??è§?object navigator) ?©ä»¶å¿???ç­???quick filter: ctrl + 2

(?©ä»¶??è§?object navigator) å¤???opy*: ctrl + c

(?©ä»¶??è§?object navigator) å±?å¼?/?¶å??expand/collapse: ctrl + right

(?©ä»¶??è§?object navigator) ?·æ??efresh: f5

(ç¨?å¼???管ç??code manager) å¤???opy*: ctrl + c

(ç¨?å¼???管ç??code manager) ?·æ??efresh: f5

(ç¨?å¼???管ç??code manager) ??寻è???earchbox: enter, f5

(??????ç±?ll tabs) ä¸?ä¸?ä¸?¡µç±?ext tab*: ctrl + tab

(??????ç±?ll tabs) ä¸?ä¸?ä¸?¡µç±?revious tab*: ctrl + shift + tab

Database.NET?´æ?°æ?¥å?

- 主ç?å¼??´æ??Main):

Upd: Oracle ??件ç?????´æ?°è? Oracle.ManagedDataAccess.dll 19.10.0 (2020/11/17)(7629)

?¸å?³æ?´æ?°ä??? Oracle 10g ????????ä¸???å½±å??(7629)

???? Easy Connect Plus è¿?线æ?¹å?ä¸????°è?线è?ç½?7629)

Add: ?°å???????????è¯???¢è?è¨? Norwegian Bokmaal language (by Edvind H?pnes)(7629)

Add: (PostgreSQL 12+) å¢??? JsonPath Type èµ???åº?ç±»å???¸å?³å???(7629)

Add: (PostgreSQL) å¢??? Composite Types ? UDDT ???ä¹?ç±»å??(7629)

Fix: ?¹è?ä¸???????½å??, ä¿??(7613)??º¿???¨é??è¿?å¤????????¨ç?????(7629)

Upd: (Firebird) åµ??¥ç????件ä?å­??¨æ?? å°????°å?????设置?¹ä¾¿?´æ??7629)

Fix: (Oracle 10/11) ä¿?? NUMBER ??å§?é¢?设å?¼è??ºç?????????(7629)

Fix: 解å?³ä½¿?¨ç?ä¸??¹å????¶å???½ä????°æ??æ³?正确设置大å??????(7629)

Upd: PostgreSQL ??件ç?????´æ?°è? Npgsql.dll 4.1.6 (2020/11/16)(7629)

Upd: ?¶ä?????´¯è®¡å?å¹??´æ?? ä¿??ä¸?ä¼???å¤???(7629)

- �????�����(Data Browser and Editor):

Add: ???? ExpandoObject èµ???ç±»å??解æ??å¤???(7629)

Fix: (PostgreSQL) ä¿??(7592)å¾? Composite Types èµ???ç±»å????æ³??¾ç¤º?????(7629)

Fix: (PostgreSQL) ä¿??(7592)å¾? timestamp/timestamptz/tstzrange èµ???åº?ç±»å???¸å?³å???(7629)

Fix: (PostgreSQL) ä¿?? time/timetz èµ???åº?ç±»å???¸å?³å???(7629)

Upd: å¢??? timetz ä¸??¹è? timestamptz èµ???åº?ç±»å??解æ???½å??(7629)

- ??????令ç??(Generating Scripts):

Add: ???? SCRIPT AS ALTER �?��????(7629)

Fix: (Firebird) ä¿??(7613)导è?´é?¨å??èµ???ç±»å??å¤??ºé?¿åº¦?¾ç¤º????è¯?7629)

Fix: (Firebird) ä¿?? DBTRIGGERS ????失å?»ä??¨ç?????(7629)

- èµ????¼ç?è¾???Cell Editor)/èµ?????a href="/r/llq" target="_blank">æµ?è§???/a>(Cell Viewer):

Fix: (PostgreSQL) ä¿??(7592)å¾? Json/Jsonb èµ???ç±»å????æ³?ä¿?å­??????(7629)

- èµ???æ±???Data Export):

Add: (csv/tsv/psv/ssv/sql) å¢???ä¿??????è¡?å°¾ç??空ç?½é??é¡?Trim trailing spaces from data fields)(7629)

- SQL ç¼?è¾???SQL Editor):

Fix: ä¿???§ç?? Oracle 10g ä¸???å­????§è?计å??(Plain Execution Plan)??æ³??¾ç¤º?????(7629)

- �??���Database Migration)(Pro):

Upd: ?????´æ?°å?? dbMigration .NET è½??(7629)