LINQ to SQL ÔÚ Visual Studio 2008 Öеļòµ¥Ó¦ÓÃ
ÔÚ.Net Framework 3.5 ÖУ¬×¶¯ÈËÐĵľÍÊÇÔö¼ÓÁËLINQ¹¦ÄÜ£¬LINQÔÚÊý¾Ý¼¯³ÉµÄ»ù´¡ÉÏÌṩÁËеÄÇáÐÍ·½Ê½¡£ÓÐÁËLINQ£¬ÎÒÃÇ´´½¨µÄ²éѯÏÖÔھͱà³ÌÁË.Net ¿ò¼ÜµÄÒ»¸ö³ÉÔ±£¬ÔÚ¶ÔÒª²Ù×÷µÄÊý¾Ý´æ´¢Ö´Ðвéѯʱ£¬»áºÜ¿ì·¢ÏÖËûÃÇÏÖÔڵIJÙ×÷·½Ê½ÀàËÆÓÚϵͳÖеÄÀàÐÍ¡£Õâ˵Ã÷£¬ÏÖÔÚ¿ÉÒÔʹÓÃÈÎÒâ¼æÈÝ.Net µÄÓïÑÔÀ´²éѯµ×²ãµÄÊý¾Ý´æ´¢£¬ÕâÔÚÒÔǰÊDz»¿ÉÄܵġ£
¸ù¾ÝÒªÔÚÓ¦ÓóÌÐòÖд¦ÀíµÄµ×²ãÊý¾ÝµÄ²»Í¬£¬Óв»Í¬ÀàÐ͵ÄLINQ¹¦ÄÜ£º
LINQ to Objects
¶ÔÏóÖ»²»¹ýÊÇ´æ´¢ÔÚÄÚ´æÖеÄÊý¾Ý£¬¶ÔÏó±¾Éí¿ÉÄܾÍÊDzéѯÊý¾Ý£¬´Ëʱ¿ÉÒÔʹÓÃLINQ to Objects
LINQ to SQL¡¢LINQ to DataSets ºÍ LINQ to Entities ÌṩÁ˲éѯ¹ØÏµÐÍÊý¾ÝµÄ·½Ê½£¬Ö±½Ó·ÃÎÊÊý¾ÝºÍ´æ´¢¹ý³Ì£¬¼°±íʾ±íʾÌåÖ®¼äµÄ¹ØÏµ£¬Ö´ÐÐÌíɾ¸Ä²é¡£
LINQ to XML
LINQ to SQL ºÍ Visual Studio 2008
LINQ to SQL ÊÇÔÚSQL Server Êý¾Ý¿âÉÏÉèÖÃÒ»¸öÇ¿ÀàÐÍ»¯½çÃæµÄ·½Ê½£¬ÌṩÁËĿǰ²éѯSQL Server ×î¼òµ¥µÄ·½·¨¡£
ÏÂÃæÒª´´½¨Ò»¸öʾÀý£¬´ÓNorthwindÊý¾Ý¿â£¨SQL Server 2000 ʾÀýÊý¾Ý¿â ÏÖÔÚÖ»Äܵ½ÍøÉÏËÑË÷ÏÂÔØÁË£©µÄProducts ±íÖÐÌáÈ¡Êý¾ÝÏî
Ò»£¬ÓÃVSTS 2008 н¨Ò»¸öC# Web Ó¦ÓóÌÐò£¨.Net 3.5£©
¶þ£¬ÓÒ¼üΪÏîÄ¿Ìí¼ÓÒ»¸öLINQ to SQL Àà ²¢ÎªÆäÃüÃûΪºÍÊý¾Ý¿âÏàͬµÄÃû×Ö£¬ÈÝÒ×ʶ±ð¡£
È·¶¨£¬½á¹ûÈçÏ£¬¿É¼ûORÉè¼ÆÆ÷±»´ò¿ª
ORÉè¼ÆÆ÷ÓÉÁ½²¿·Ö×é³É£º
×ó±ß²¿·ÖÓÃÓÚÏÔʾÊý¾ÝÀ࣬Ëü¿ÉÒÔÊÇ±í¡¢Àà¡¢¹ØÁªºÍ¼Ì³Ð¡£
Óұ߲¿·ÖÓÃÓÚÏÔʾ·½·¨£¬ÕâЩ·½·¨Ó³Éäµ½Êý¾Ý¿âÖеĴ洢¹ý³ÌÉÏ¡£
Èý£¬´´½¨±í¶ÔÏó
ÔÚ´´½¨±í¶ÔÏó֮ǰ£¬ÎÒÃÇÏÈÓ÷þÎñÆ÷×ÊÔ´¹ÜÀíÆ÷½¨Á¢¶ÔNorthwindÊý¾Ý¿âµÄÒýÓá£
ÓÒ¼üÊý¾ÝÁ¬½Ó½Úµã->Ìí¼ÓÁ¬½Ó£¬´ò¿ªÌí¼ÓÁ¬½Ó¶Ô»°¿ò
ÊäÈë·þÎñÆ÷Ãû£¬ÃÜÂ룬²¢Ñ¡ÔñÊý¾Ý¿âÖ®ºóµãÈ·¶¨°´Å¥¡£Êý¾Ý¿â±»Ìí¼ÓÁ˽øÀ´¡£
´ò¿ª´ËÊý¾Ý¿âµÄ±íÎļþ¼Ð£¬Ñ¡ÔñProduct ±íÓÃÊó±êÖ±½ÓÍ϶¯µ½ORÉè¼ÆÆ÷ÉÏ£¬½á¹ûÈçÏÂ
ͬʱWeb.Config ÎļþÖлáÌí¼ÓÈçϵÄÁ¬½ÓÐÅÏ¢£¬ÔÚNorthwind.designer.csÎļþÖл¹»áÌí¼ÓÏàÓ¦µÄÓ³ÉäÉè¼Æ´úÂë
<connectionStrings>
<add name="NorthwindConnectionString" connectionString="Data Source=TERRYFENG-PC;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa;Password=saaaaa"
providerName="System.Data.SqlClient" />
</connectionStrings>
ÔÚORÉè¼ÆÆ÷µÄÊôÐÔ´°¿ÚÖУ¬ÎÒÃÇ¿ÉÒÔ¿´µ½Á¬½Ó´®µÈÐÅÏ¢
´ò¿ªDefault.aspx Îļþ£¬ÏòÆäÖÐÍ϶¯Ò»¸öGridView ¿Ø¼þ£¬²¢ÔÚºó
Ïà¹ØÎĵµ£º
I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fil ......
×î½ü,Òò¸öÈ˵çÄÔÓ²ÅÌËð»µ,йºÈëÁË500GµÄ´óÓ²ÅÌ,°²×°ÁËwindows7,ÔÚwin7Éϰ²×°Á˶à¸öÐéÄâxp»ú,ÐéÄâ»úÓëʵ¼ÊµÄ»úÆ÷(Ö÷»ú)×é³ÉÁËÒ»¸ö¾ÖÓòÍø,ʵÏÖÔÚÐéÄâ»úÖÐͨ¹ýÔ¶³ÌÁ¬½ÓÖ÷»úµÄsql server.ÏÖ½«ÎÒµÄÊÔÑé¹ý³Ì½éÉÜÈçÏÂ,¹©ÓÐÐËȤ³¢ÊԵĴóÏÀ²Î¿¼.
1. °²×°ÐéÄâ»ú»·¾³.
ÏȰ²×°window7.0Æì½¢°æ (רҵÓëÆóÒµ°æÒ²¿ ......
Oracle SQL PLUS »ù±¾²Ù×÷1
怬
c:\>sqlplus "sys/test1234 as sysdba" ÒÔsysdbaÉí·ÝµÇ¼
c:\>sqlplus/nolog ÒÔnologÉí·ÝµÇ¼
sql> connect sys/test1234 as sysdba
Connected.
Æô¶¯
SQL> startup &nb ......
²»´íµÄ×ÊÁÏ,ת¹ýÀ´,·½±ãÈÕºó²é¿´Ê¹ÓÃ!!!
--¼à¿ØË÷ÒýÊÇ·ñʹÓÃ
alter index &index_name monitoring usage;
alter index &index_name nomonitoring usage;
select * from v$object_usage where index_name =
&index_name;
--ÇóÊý¾ÝÎļþµÄI/O·Ö²¼
select
df.name,phyrds,phywrts,phyblkrd,phyblkwrt,sin ......