Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ÃæÊÔÌâÒ»

1.ÓÃÒ»ÌõSqlÓï¾ä²éѯ³öÿÃŹ¦¿Î¶¼´óÓÚ80·ÖµÄѧÉúÐÕÃû 
Name
Class
Result
ÕÅÈý
ÓïÎÄ
56
ÕÅÈý
Êýѧ
88
ÀîËÄ
ÓïÎÄ
92
ÀîËÄ
Êýѧ
100
ÍõÎå
ÓïÎÄ
88
ÍõÎå
Êýѧ
99
ÍõÎå
Ó¢Óï
99
-------------------------------------------------------------------------------
´ð°¸£º
SELECT DISTINCT nam ......

SQL Server 2008ÏÂÔØ&ÆÆ½â

´Ó¹ÙÍøÏÂÔØSQL Server 2008µÄ180ÌìÊÔÓðæÆäʵÓëÕýʽ°æÄÚÈÝÊÇ»ù±¾ÏàͬµÄ£¬Î¨Ò»µÄÇø±ð¾ÍÔÚÓÚ°²×°ÅäÖÃÎļþÖÐËù°üº¬µÄkey¡£¸÷ÖÖ°æ±¾µÄSQL ServerÔÚ½øÐе½ÕâÒ»²½Ö®Ç°¶¼ÊÇÍêȫһÑùµÄ£º
Microsoft® SQL Server® 2008 Enterprise Evaluation£º¿ª·¢ÈËÔ±ÊÔÓÃÌåÑé
Microsoft® SQL Server® 2008 Enterprise Evaluatio ......

sql ºº×ÖתÊ××ÖĸƴÒô

create function fun_getPY(@str nvarchar(4000))
returns nvarchar(4000)
as
begin
declare @word nchar(1),@PY nvarchar(4000)
set @PY=''
while len(@str)>0
begin
set @word=left(@str,1)
--Èç¹û·Çºº×Ö×Ö·û£¬·µ»ØÔ­×Ö·û
set @PY=@PY+(case when unicode(@word) between 19968 and 19968+20901 ......

Oracle SQLµÄÓÅ»¯

SQLµÄÓÅ»¯Ó¦¸Ã´Ó5¸ö·½Ãæ½øÐе÷Õû£º
1.È¥µô²»±ØÒªµÄ´óÐͱíµÄÈ«±íɨÃè
2.»º´æÐ¡ÐͱíµÄÈ«±íɨÃè
3.¼ìÑéÓÅ»¯Ë÷ÒýµÄʹÓÃ
4.¼ìÑéÓÅ»¯µÄÁ¬½Ó¼¼Êõ
5.¾¡¿ÉÄܼõÉÙÖ´Ðмƻ®µÄCost
SQLÓï¾ä£º
ÊǶÔÊý¾Ý¿â(Êý¾Ý)½øÐвÙ×÷µÄΩһ;¾¶£»
ÏûºÄÁË70%~90%µÄÊý¾Ý¿â×ÊÔ´£»¶ÀÁ¢ÓÚ³ÌÐòÉè¼ÆÂß¼­£¬Ïà¶ÔÓÚ¶Ô³ÌÐòÔ´´úÂëµÄÓÅ»¯£¬¶ÔSQLÓï¾äµÄÓÅ»¯Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ