Å×ÆúMS Access°É£¬ÇëʹÓÃSQLite
Å×ÆúMS Access°É£¬ÇëʹÓÃSQLite
1¡¢SQLite¼ò½é
SQLiteµÚÒ»¸öAlpha°æ±¾µ®ÉúÓÚ2000Äê5ÔÂ. ÖÁ½ñÒѾÓÐ4¸öÄêÍ·ÁË. ¶øÔÚ½ñÄêµÄ5ÔÂSQLiteÒ²ÓÀ´ÁËÒ»¸öеÄÀï³Ì: SQLite 3. SQLite¹Ù·½ÍøÕ¾: http://www.sqlite.org/
2¡¢SQLiteÀàÐÍ
SQLiteµÄÊý¾ÝÀàÐÍ
Ê×ÏÈÄã»á½Ó´¥µ½Ò»¸öÈÃÄ㾪ÑȵÄÃû´Ê: Typelessness(ÎÞÀàÐÍ). ¶Ô! SQLiteÊÇÎÞÀàÐ͵Ä. ÕâÒâζ×ÅÄã¿ÉÒÔ±£´æÈκÎÀàÐ͵ÄÊý¾Ýµ½ÄãËùÏëÒª±£´æµÄÈκαíµÄÈκÎÁÐÖÐ, ÎÞÂÛÕâÁÐÉùÃ÷µÄÊý¾ÝÀàÐÍÊÇʲô(Ö»ÓÐÔÚÒ»ÖÖÇé¿öϲ»ÊÇ, ÉÔºó½âÊÍ). ¶ÔÓÚSQLiteÀ´Ëµ¶Ô×ֶβ»Ö¸¶¨ÀàÐÍÊÇÍêÈ«ÓÐЧµÄ. Èç:
Create Table ex1(a, b, c);
³ÏÈ»SQLiteÔÊÐíºöÂÔÊý¾ÝÀàÐÍ, µ«ÊÇÈÔÈ»½¨ÒéÔÚÄãµÄCreate TableÓï¾äÖÐÖ¸¶¨Êý¾ÝÀàÐÍ. ÒòΪÊý¾ÝÀàÐͶÔÓÚÄãºÍÆäËûµÄ³ÌÐòÔ±½»Á÷, »òÕßÄã×¼±¸»»µôÄãµÄÊý¾Ý¿âÒýÇæ. SQLiteÖ§³Ö³£¼ûµÄÊý¾ÝÀàÐÍ, Èç:
CREATE TABLE ex2(
a VARCHAR(10),
b NVARCHAR(15),
c TEXT,
d INTEGER,
e FLOAT,
f BOOLEAN,
g CLOB,
h BLOB,
i TIMESTAMP,
j NUMERIC(10,5)
k VARYING CHARACTER (24),
l NATIONAL VARYING CHARACTER(16)
);
Ç°ÃæÌáµ½ÔÚijÖÖÇé¿öÏÂ, SQLiteµÄ×ֶβ¢²»ÊÇÎÞÀàÐ͵Ä. ¼´ÔÚ×Ö¶ÎÀàÐÍΪ”Integer Primary Key”ʱ.
SQLiteÖ§³ÖSQL92 ±ê×¼¡£
3¡¢ÓÃ.NET²Ù×÷sqliteÊý¾Ý¿â
System.Data.SQLite
ÊÇÒ»¸öÔʼSQLiteµÄ¼ÓÇ¿°æ. Ëü½«ÊÇÒ»¸öÔ°æµÄsqlite3.dllÍêÈ«Ìæ´úÆ· (ÄãÉõÖÁ¾Í¿ÉÒÔ°ÑËüÖØÃüÃûΪsqlite3.dll). Ëü²»ÐèÒªÁ´½Ó.NET ÔËÐÐʱ£¬ËùÒÔ¿ÉÒÔÍÑÀë.NET¶ÀÁ¢·¢²¼, È»¶øËüÄÚǶÁËÒ»¸öÍêÕûµÄ ADO.NET 2.0 ÒýÇ棬Ϊ¿ª·¢ÌṩÁËÍêÕûµÄÖ§³Ö.
ÒÔÏÂÊÇËüµÄÌØÐÔ¼ò½é:
ÍêÕûµÄ ADO.NET 2.0 ʵÏÖ
Õû¸ö¹¤³ÌÍêÈ«»ùÓÚVS2005 ºÍ ADO.NET 2.0ȫй¹½¨, ʹÓÃÁËÈ«²¿µÄADO.NET frameworkÐÂÌØÐÔ. °üÀ¨ÍêÕûµÄ DbProviderFactory Ö§³Ö, ×Ô¶¯µÄ·Ö²¼Ê½ÊÂÎñµ÷ÓÃ, ¹ã·ºµÄģʽ֧³Ö, ´ËÍâËùÓеÄÀ඼ÊÇ´Ó ADO.NET 2.0 µÄ»ùÀà¼Ì³ÐÏÂÀ´µÄ.
Ö§³ÖÍêÕûºÍ¾«¼òµÄ .NET Framework ÒÔ¼° C/C++
Õâ¸ö¿â²»ÐèÒªÁ´½ÓÒÀÀµ.NETÔËÐÐʱ£¬100%¼æÈÝÔʼµÄsqlite3.dll£¬¿ÉÒÔʹÓ÷ÇÍйܵÄC/C++ ½øÐпª·¢.
¿ÉÒÆÖ²µÄÊý¾Ý¿âÎļþ
δ¼ÓÃÜµÄ SQLite Êý¾Ý¿âÎļþ¿ÉÒÔ×ÔÓɵĿçƽ̨ºÍ´¦ÀíÆ÷ʹÓ㬰üÀ¨·ÇWindowsƽ̨. ¼ÓÃÜÖ®ºóµÄÊý¾Ý¿â¿ÉÒÔÔÚÈ«²¿Windowsƽ̨ÉÏʹÓÃ.
¿ÉÒÔÐÅÀµµÄËٶȣ¬±È°üÀ¨Sql Server Mobile ÔÚÄÚµÄÆäËü´ó¶àÊýǶÈëʽÊý¾Ý¿â¶¼Òª¿ìËÙ
SQLite'°²×°ËùÕ¼ÓõĿռäÏà¶ÔÓÚSql Mobile¿ÉνºöÂÔ²»¼ÆÁË. ËüÔ
Ïà¹ØÎĵµ£º
http://www.tongyi.net/article/20031101/200311013786.shtml
ËùνµÄÊý¾Ý´«Ê䣬ÆäʵÊÇÖ¸SQLServer·ÃÎÊAccess¡¢Excel¼äµÄÊý¾Ý¡£
ΪʲôҪ¿¼Âǵ½Õâ¸öÎÊÌâÄØ£¿
ÓÉÓÚÀúÊ·µÄÔÒò£¬¿Í»§ÒÔÇ°µÄÊý¾ÝºÜ¶à¶¼ÊÇÔÚ´æÈëÔÚÎı¾Êý¾Ý¿âÖУ¬ÈçAcess¡¢Excel¡¢Foxpro¡£ÏÖÔÚϵͳÉý¼¶¼°Êý¾Ý¿â·þÎñÆ÷ÈçSQLServer¡¢ORACLEºó£¬¾³£ÐèÒª·ÃÎÊÎı¾Êý ......
ÔÚ±àд×Ô¼ºµÄdll³ÌÐòµÄʱºò£¬ÏÈ¿ªÊ¼ÔÚµ÷ÓÃdllµÄexeÉϳöÏÖ(AVIDLL.DLL): 0xC0000005: Access Violation£¬²»ÊǺÜÃ÷°×£¬ÎªÊ²Ã´»á³öÏÖÕâ¸öÎÊÌâ¡£
ÔÚÄÚ²¿½øÐе÷ÊÔµÄʱºò·¢ÏÖ£¬Êǵ÷ÓÃÁËnew²Ù×÷·ûµÄÔµ¹Ê¡£
ºÜ²»Àí½â£¬ÔÚdllÖе÷ÓÃnew²Ù×÷·û»á³öÏÖÕâôһ¸öÎÊÌ⣬ÍøÂçÉÏËÑË÷£¬ÔÚ΢ÈímsdnÂÛ̳£¨¾ßÌåµØÖ·£ºhttp://forums.msdn.mic ......
C#ÖзÃÎʹؼü×Ö£¨access keyword£©ÓÐÁ½¸ö£ºbase¡¢this
1.base
ÓÃÓÚ´ÓÅÉÉúÀàÖзÃÎÊ»ùÀàµÄ³ÉÔ±£¬°üÀ¨£º
a.µ÷ÓûùÀàÉÏÒѱ»ÆäËü·½·¨ÖØд£¨override£©µÄ·½·¨¡£
b.Ö¸¶¨´´½¨ÅÉÉúÀàʵÀýʱӦµ÷ÓõĻùÀ๹Ô캯Êý¡£
×¢Ò⣺¶Ô»ùÀàµÄ·ÃÎÊÖ»ÄÜ ......
public static DataTable GetSchemaTable(string connectionString) //»ñÈ¡AccessËùÓеıíÃû£»
{
using (OleDbConnection connection = new
&n ......
ACCESSÔ¶³Ì±¸·ÝÒ»Ö±ÊǸöÁîÈËÍ·ÌÛµÄÎÊÌâ ¿´µ½Ò»¸ö²»´íµÄ±¸·Ý·½·¨ ·ÖÏíÏ£º
ÔÎĵØÖ·£ºhttp://www.cnblogs.com/catcat811/archive/2009/12/31/1637186.html
ÍøÕ¾ÓÖ¹ØÁË~~~¹ØµÃºÜͻȻ£¬Êý¾ÝÒ²À´²»¼°±¸·Ý¡£ÒòΪ¹«Ë¾Óиö²Ö¿âµÄϵͳÔÚ×âÓ÷þÎñÆ÷ÉÏ£¬Èç¹ûÍ£Á˾͵ÃÖØеã²Ö£¬ÄÇÊǺÜÀÛÈ˵ÄÊ¡£×î½üÍøվʱ³£¹Ø£¬ÕæÈÃÈËÍ·Í´¡£ÎªÁ˱Üà ......