Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Linq to sqlϵÁÐÎÄÕÂ


Ò»²½Ò»²½Ñ§Linq to sql£¨Ò»£©£ºÔ¤±¸ÖªÊ¶
Ò»²½Ò»²½Ñ§Linq to sql£¨¶þ£©£ºDataContextÓëʵÌå 
Ò»²½Ò»²½Ñ§Linq to sql£¨Èý£©£ºÔöɾ¸Ä
Ò»²½Ò»²½Ñ§Linq to sql£¨ËÄ£©£º²éѯ¾ä·¨
Ò»²½Ò»²½Ñ§Linq to sql£¨Î壩£º´æ´¢¹ý³Ì
Ò»²½Ò»²½Ñ§Linq to sql£¨Áù£©£ºÌ½¾¿ÌØÐÔ 
Ò»²½Ò»²½Ñ§Linq to sql£¨Æß£©£º²¢·¢ÓëÊÂÎñ 
Ò»²½Ò»²½Ñ§Linq to sql£¨°Ë£©£º¼Ì³ÐÓë¹ØÏµ 
Ò»²½Ò»²½Ñ§Linq to sql£¨¾Å£©£ºÆäËü²¹³ä
Ò»²½Ò»²½Ñ§Linq to sql£¨Ê®£©£º·Ö²ã¹¹¼ÜµÄÀý×Ó 
ËùÓдúÂëµã»÷ÕâÀïÏÂÔØ
source:   http://blog.csdn.net/LoveCherry/archive/2007/08/13/4606629.aspx
http://kb.cnblogs.com/zt/linq/   LINQרÌâ - ²©¿ÍÔ°
http://www.cnblogs.com/lyj/archive/2008/03/25/1119671.html


Ïà¹ØÎĵµ£º

pl/sql±¨ora 12154£ºTNS:ÎÞ·¨½âÎöÖ¸¶¨µÄÁ¬½Ó·ûÎÊÌâ

½â¾ö·½·¨Ò»
ÔÚoraDb10g_home->ÅäÖúÍÒÆÖ²¹¤¾ß->net Manager
      ÔÚ±¾µØÖÐн¨Ò»¸ö·þÎñÃüÃû
Õâ¸öÍøÂç·þÎñÃû¾ÍÊǵǽʱµÄÊý¾Ý¿âÃû
Íê³ÉÕâЩ²Ù×÷ºó£¬Ñ¡Ôñ²Ëµ¥ÖÐÎļþ->±£´æÍøÂçÅäÖþÍokÁË¡£
½â¾ö·½·¨¶þ
´ò¿ª°²×°Ä¿Â¼Ï·þÎñÆ÷¶ËµÄtnsnames.ora£¬±ÈÈçÎÒµÄÍêÕûĿ¼ÊÇE:\oracle\product\ ......

sql serverÇå³ýÈÕÖ¾

1: ɾ³ýLOG (ɾ³ýlogÎļþ£¬¸½¼Óʱ×Ô¶¯Öؽ¨logÎļþ£¬ÒÔ´Ë·½Ê½À´Çå¿ÕÈÕÖ¾)
    1) ·ÖÀëÊý¾Ý¿â  ÆóÒµ¹ÜÀíÆ÷£­£¾·þÎñÆ÷£­£¾Êý¾Ý¿â£­£¾ÓÒ¼ü£­£¾·ÖÀëÊý¾Ý¿â
    2) ɾ³ýLOGÎļþ
    3) ¸½¼ÓÊý¾Ý¿â  ÆóÒµ¹ÜÀíÆ÷£­£¾·þÎñÆ÷£­£¾Êý¾Ý¿â£­£¾ÓÒ¼ü£­£¾¸½¼ÓÊý¾Ý¿â
´Ë·¨Éú³ ......

SQLÁ´½ÓÊý¾Ý¿â

Standard   Security:  
   
  "Data   Source=Aron1;Initial  
Catalog=pubs;User   Id=sa;Password=asdasd;"    
        -   or   -  
 
"Server=Aron1;Database=pubs;User  
ID=sa;Pass ......

MS SQL ServerºÍMySQLÇø±ð

      1 MySQLÖ§³Öenum,ºÍsetÀàÐÍ£¬SQL Server²»Ö§³Ö
¡¡¡¡2 MySQL²»Ö§³Önchar,nvarchar,ntextÀàÐÍ
¡¡¡¡3 MySQLµÄµÝÔöÓï¾äÊÇAUTO_INCREMENT£¬¶øMS SQLÊÇidentity(1,1)
¡¡¡¡4 MS SQLĬÈϵ½´¦±í´´½¨Óï¾äµÄĬÈÏÖµ±íʾÊÇ((0)),¶øÔÚMySQLÀïÃæÊDz»ÔÊÐí´øÁ½À¨ºÅµÄ
¡¡¡¡5 MySQLÐèҪΪ±íÖ¸¶¨´æ´¢ÀàÐÍ
¡ ......

oracle sqlÓïÑÔÄ£ºý²éѯ ͨÅä·ûlikeµÄʹÓý̳Ì

ÔÚWhere×Ó¾äÖУ¬¿ÉÒÔ¶Ôdatetime¡¢char¡¢varchar×Ö¶ÎÀàÐ͵ÄÁÐÓÃLike×Ó¾äÅäºÏͨÅä·ûѡȡÄÇЩ“ºÜÏñ...”µÄÊý¾Ý¼Ç¼£¬ÒÔÏÂÊÇ¿ÉʹÓõÄͨÅä·û£º
%   Áã»òÕß¶à¸ö×Ö·û
_    µ¥Ò»ÈκÎ×Ö·û£¨Ï»®Ïߣ©
\     ÌØÊâ×Ö·û
[]     ÔÚijһ·¶Î§ÄÚµÄ×Ö·û£¬Èç ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ