ΪʲôҪѧϰʹÓÃLINQ¼¼Êõ
Ê×ÏÈÒªÖªµÀLinq ¶¼ÓÐÄÄЩ֪ʶµã,Õâ¸ö¿ÉÒÔ×ÔÐаٶÈ;¶Ô¼¯ºÏµÄ²éѯ,ɸѡ,ÅÅÐò,ÖØÐÂÉú³ÉеĶÔÏó¶à¸ö¼¯ºÏµÄÁ¬½Ó²éѯLinq to SQL ,¿ÉÒÔ½øÐÐSQL²éѯµÈ²Ù×÷, ¿ÉÒÔºöÂÔ²»Í¬Êý¾Ý¿âÖ®¼äµÄ²îÒì;ÄãÒªÖªµÀºÜ¶àÈ˲»¶®µÃsqlÓï¾äµÄ,¸ü±ð˵²»Í¬Êý¾Ý¿âµÄsqlÓï¾ä;ÍÆ¼öÄ㿴һϠ,×Ô¼ºËÑË÷ÏÂÃæµÄÌõ¼þLinqʹÓÃÐĵ᪡ªSelectManyÌæ´ú¶þÖØforeachÑ»·¿ÉÒÔ¿´µÃ³ö±ÈÄã×Ô¼ºÐ´Ñ»·Òª·½±ãºÜ¶à;5.ÍÆ¼öÄã°ÑLINQµÄ¼¸Ê®¸ö²Ù×÷·û¶¼¿´Ò»ÏÂ,ÖªµÀÊÇʲô¹¦ÄÜ,¿ÉÒÔÏÈ»áÓÃ,ÖªµÀËüÄܸÉʲô,Õâ¸öʱºòÔÙ¾ßÌåÌÖÂÛËüµÄÒâÒå,Ëü¸Ã²»¸Ãѧϰ6.ÏÂÃæÊÇ2¸öÍøÖ·,ÓÐʱ¼ä¿ÉÒÔ×ÔÐп´Ò»ÏÂËüÊÇʲô,È»ºóÔÙÉÆäѧϰµÄÒâÒåhttp://www.cnblogs.com/foundation/archive/2009/01/05/1369371.htmlhttp://www.cnblogs.com/lyj/archive/2008/03/24/1119671.html
ʲôÊÇlinq¼¼Êõ
LINQ£¬ÓïÑÔ¼¯³É²éѯ£¨Language Integrated Query£©ÊÇÒ»×éÓÃÓÚc#ºÍVisual BasicÓïÑÔµÄÀ©Õ¹¡£ËüÔÊÐí±àдC#»òÕßVisual Basic´úÂëÒÔ²éѯÊý¾Ý¿âÏàͬµÄ·½Ê½²Ù×÷ÄÚ´æÊý¾Ý¡£
´Ó¼¼Êõ½Ç¶È¶øÑÔ£¬LINQ¶¨ÒåÁË´óÔ¼40¸ö²éѯ²Ù×÷·û£¬Èçselect¡¢from¡¢in¡¢whereÒÔ¼°order by£¨C#ÖУ©¡£Ê¹ÓÃÕâЩ²Ù×÷·û¿ÉÒÔ±àд²éѯÓï¾ä¡£²»¹ý£¬ÕâЩ²éѯ»¹¿ÉÒÔ»ùÓںܶàÀàÐ͵ÄÊý¾Ý£¬Ã¿¸öÊý¾ÝÀàÐͶ¼ÐèÒªÒ»¸öµ¥¶ÀµÄLINQÀàÐÍ¡£
¾¹ýÁË×î½ü 20 Äê£¬ÃæÏò¶ÔÏó±à³Ì¼¼Êõ£¨ object-oriented (OO) programming technologies £©ÔÚ¹¤ÒµÁìÓòµÄÓ¦ÓÃÒѾ½øÈëÁËÒ»¸öÎȶ¨µÄ·¢Õ¹½×¶Î¡£³ÌÐòÔ±ÏÖÔÚ¶¼ÒѾÈÏͬÏñ Àࣨclasses£©¡¢¶ÔÏó£¨objects£©¡¢·½·¨£¨methods£©ÕâÑùµÄÓïÑÔÌØÐÔ¡£¿¼²ìÏÖÔÚºÍÏÂÒ»´úµÄ¼¼Êõ£¬Ò»¸öеıà³Ì¼¼ÊõµÄÖØ´óÌôÕ½¿ªÊ¼³ÊÏÖ³öÀ´£¬¼´ÃæÏò¶ÔÏó¼¼Êõµ®ÉúÒÔÀ´²¢Ã»Óнâ¾ö½µµÍ·ÃÎʺÍÕûºÏÐÅÏ¢Êý¾Ý£¨ accessing and integrating information £©µÄ¸´ÔӶȵÄÎÊÌâ¡£ÆäÖÐÁ½¸ö×îÖ÷Òª·ÃÎʵÄÊý¾ÝÔ´ÓëÊý¾Ý¿â£¨database£©ºÍXML£¨±ê׼ͨÓñê¼ÇÓïÑÔϵÄÒ»¸öÓ¦Óã©Ïà¹Ø¡£
LINQ ÌṩÁËÒ»Ìõ¸ü³£¹æµÄ;¾¶¼´¸ø.Net FrameworkÌí¼ÓһЩ¿ÉÒÔÓ¦ÓÃÓÚËùÓÐÐÅÏ¢Ô´£¨ all sources of information £©µÄ¾ßÓжàÖÖÓÃ;£¨ general-purpose £©µÄÓï·¨²éÑ¯ÌØÐÔ£¨ query facilities £©£¬ÕâÊDZÈÏò¿ª·¢ÓïÑÔºÍÔËÐÐʱ£¨ runtime £©Ìí¼ÓһЩ¹ØÏµÊý¾Ý£¨ relational £©ÌØÐÔ»òÕßÀàËÆ XML ÌØÐÔ£¨ XML-specific £©¸üºÃµÄ·½Ê½¡£ÕâЩÓï·¨ÌØÐԾͽÐ×ö .NET Language Integrated Query (LINQ) ¡£
linqÔõô°´ºº×ÖÆ´ÒôÅÅÐò
²éµÚ6°æ¡¶ÏÖ´úººÓï´Êµä¡·Öª£ººº×ÖÖÐûÓжÁÒôΪ¡°linq¡±µÄ×Ö¡£
ÈôÊÇÖ¸¡°ling¡±µÄ»°£¬Ôò¿É¼ûµ½Óк຺ܶ×Ö²ÉÓÃ´ËÆ´Òô¡£×ÖµäÖеÄÅÅÐòÊÇÒÔ¶ÁÒôl¨©ng¡¢l¨ªng¡¢l¨«ng¡¢l¨¬ngµÄËÄÉù´ÎÐò·ÖÁÐÏȺó£¬Í¬Òô×ÖÔÙÒԱʻ´ÓÉÙÖÁ¶àÅÅÁС£ÓÉÓÚºº×ÖÖÐûÓжÁÒ»ÉùµÄl¨©ng×Ö£¬¹ÊÒÔl¨ªng¿ªÊ¼£º
l¨ªng£º◯£»ÁÁ棻Á飻ˆ{£»Üߣ»àò£»ãö£»Š–£»Á᣻èÚ£»•`£»¡¡¡£
l¨«ng£ºÁÁ룻Áì¡£
l¨¬ng£ºÁí£»ÁßÊ¡£
linq ÈçºÎ¶Áȡij¸öʵÌåÀàµÄÊôÐÔÈ»ºóת»¯ÎªÊý×飿
ʾÀýÈçÏ£º
class Student
{
public string Name { get; set; }
public int Age { get; set; }
}
static void Main(string[] args)
{
List data = new List();
string[] names = (from p in data select p.Name).ToArray();
}