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

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 ¿Ø¼þ£¬²¢ÔÚºó


Ïà¹ØÎĵµ£º

sql group by


sql group by Ó÷¨
2009-07-16 11:01:00    Òµ½ç |  ÆÀÂÛ(0) |  ä¯ÀÀ(1676)
group byÖ÷ÒªÊÇÓÃÀ´·Ö×éµÄ£¬Ôõô¸ö·Ö×éÄØ£¿
ÒÔÏÂÓÃÁ½¸öÀý×Ó˵Ã÷Á½¸öʹÓ÷½Ã棬1ÊǺÏÀíµÄ·µ»ØºÏ¼ÆÖµ£¨·ÀÖ¹µÑ¿¨¶û»ýÏÖÏ󣩣¬2ÊÇÓ÷Ö×éÀ´ÕÒ³öÖظ´µÄ¼Ç¼
============================================================== ......

Sql serverµÄodbc,ado,ado.netÁ¬½Ó´®.

Ó¦ÓóÌÐòͨ¹ýodbc,ado»òado.netÓësql serverÁ¬½Ó,ÎÞÂÛͨ¹ýÄÇÖÖ·½Ê½½øÐÐÁ¬½Ó,ÿһÖÖÁ¬½Ó·½Ê½,Ê×ÏÈÒªÉèÖõÄÊÇÁ¬½Ó´®¡£ÒÔϾÍ˵˵¼¸ÖÖ·½Ê½µÄÁ¬½Ó´®µÄÉèÖãº
ÏÈ˵˵odbcÁ¬½Ó,odbcÈ«³ÆΪ¿ª·ÅʽÊý¾Ý¿âÁ¬½Ó,ÊÇ΢Èí×îÔç·¢²¼µÄÊý¾Ý¿âÁ¬½Ó·½Ê½¡£Á¬½Ó´®¸ñʽÈçÏ£ºdriver={sql server};server=·þÎñÆ÷°²È«Ãû;uid=Óû§Ãû;pwd=ÃÜÂë;databa ......

Oracle DBAÈÕ³£sqlÁÐ±í¼°³£ÓÃÊÓͼ

²»´íµÄ×ÊÁÏ,ת¹ýÀ´,·½±ãÈÕºó²é¿´Ê¹ÓÃ!!!
--¼à¿ØË÷ÒýÊÇ·ñʹÓÃ
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 ......

Ìí¼ÓÊý¾ÝÔ´²¢ÅäÖÃÊý¾ÝÔ´Óësql ServerÉí·ÝÑé֤ģʽ

      ÔÚÊý¾Ý¿âÓ¦ÓóÌÐò·¢²¼Ê±£¬¿Í»§¶Ë°²×°ÔÚ¾ÖÓòÍøÖеÄÖ÷»úAÉÏ£¬sql server °²×°ÔڸþÖÓòÍøµÄÖ÷»úBÉÏ¡£¿Í»§¶ËÈí¼þÖаüº¬ÓÐËüÒªÁ¬½ÓµÄÊý¾Ý¿âµÄÐÅÏ¢¡£ÈçÊý¾ÝÔ´£¬·þÎñÆ÷Ãû³Æ£¬Êý¾Ý¿âµÈ£¬ÊµÀý£ºdata source=SQLOLEDB;SERVER=DongZi\sqlExpress;uid=sa;pwd=123;database=MachineRoom
¡£ÄÇôÎÒÃÇÔÚÖ÷» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ