ä¯ÀÀLINQ to SQL¹Øϵ
±êÇ©£ºÊý¾Ý·ÃÎÊ LINQ LINQ to SQL ²¿·Ö
ä¯ÀÀLINQ to SQL¹Øϵ Á½¸ö¹ØÁªµÄ±í£º
½«Á½¸öÓÐÁªÏµµÄ±í¼ÓÈëdbmlÎļþÖУ¬±ÈÈ磺Customers±í ºÍ Orders±í£¬Á½¸ö±íͨ¹ýCustomerIDs½¨Á¢ÁªÏµ£» O/RÉè¼ÆÆ÷»á×Ô¶¯¼ì²âµ½±íÖ®¼äµÄ¹Øϵ£¬ËùÒÔÔÚCustomersÀàÖÐÌí¼ÓÒ»¸öOrders³ÉÔ±£¬À´±íʾ¸Ã¹Øϵ¡£ Àý£º AreslabDataContext aresData = new AreslabDataContext(); var queryResults = from c in aresData.Customers where c.Country =="USA" select new { ID=c.CustomerID,
.....
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......
´æ´¢¹ý³ÌgetRecordfromPageµÄÄÚÈÝ
//getRecordfromPage.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[getRecordfromPage]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[getRecordfromPage]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
G ......
»·¾³´î½¨£º
windows MobileµÄ¿ª·¢»·¾³µÄ´î½¨ÕâÀï¾Í²»ËµÁË£¬²»Ã÷°×µÄÅóÓÑÔÚÍøÉÏËÑϼ´¿É¡£
²½Öè¸ÅÊö:
1£ºPCÉϵÄSQL SERVER ÐèÒª¿ªÆôÔ¶³ÌÁ¬½Ó¡£
2£ºMoblieÄ£ÄâÆ÷ÐèҪͨ¹ýActiveSyncÁ¬½Ó£¬Ê¹ÆäÄܹ»Í¨¹ýPCÁ¬Íø¡£(Èç¹ûÊÇÊÖ»úµÄ»°£¬ÐèÒªÄܹ»Í¨¹ýÎÞÏßÍøÂçÁ¬È뻥ÁªÍø)
Ïêϸ˵Ã÷£º
1:SQL Server 2005¿ªÆôÔ¶³ÌÁ¬ ......
Ôø¾ÓÐÏëͨ¹ý´´½¨sql serverÊÓͼµ÷ÕûÓ¦ÓÃÐÔÄܵÄÏë·¨£¬²»¹ýºóÀ´Ö¤Ã÷Õâ¸öÏë·¨ÊÇÐв»Í¨µÄ¡£
×öÁ˸öʵÑ飬ÔÚ¶ÔÔÀ´µÄsqlÓï¾äµ÷ÕûÖ®ºó´´½¨ÁËÁ½¸öÊÓͼ£¬°ÑÔÀ´µÄsqlת»»ÎªÊÓͼÁË£¬Í¨¹ýÊÓͼÀ´¶ÁÈ¡Êý¾Ý¡£×îÖյıȽϽá¹ûÊÇͨ¹ýÊÓͼ±ÈÖ±½ÓʹÓÃsqlÓï¾äÒªÂý£¬Í¨¹ýÊÓͼÀ´Ìá¸ßsqlµÄÐÔÄÜ¿´À´ÊDz»ÐÐ ......
Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄsql serverÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý£¨clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý£©ºÍ·Ç¾Û¼¯Ë÷Òý£¨nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý£©¡£ÏÂÃ棬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
¡¡¡¡Æäʵ£¬ÎÒÃǵĺºÓï× ......