[B! Linq] taketsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

takets id:takets

Linqã«é–¢ã™ã‚‹taketsã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

LINQ to SQL MAX in WHERE clause
takets 2014/04/03
whereå¥ã®ä¸ã§Min(), Max()ã‚’ä½¿ã†ã‚µãƒ³ãƒ—ãƒ«ã€‚

Linq
ãƒªãƒ³ã‚¯
LINQ, â€œorderbyâ€ and dynamic query sample - Damir Dobric Posts - developers.de
takets 2014/03/27
c#

Linq
ãƒªãƒ³ã‚¯
Linq to SQL æ‰‹ç¿’ã„
å±±å½¦ã®é–‹ç™ºæ—¥è¨˜(echo's developer dialy) æœ€è¿‘ã¯C#ã€ãƒã‚¤ãƒ†ã‚£ãƒ–ã¯C,LISP,T-SQL,Pascal,ãªãŠæœ¬ãƒ–ãƒã‚°ã¯å®Œå…¨ã«å€‹äººçš„ãªè¦‹è§£ã‚’ç¤ºã—ã¦ã„ã¦ã€æ‰€å±žã—ã¦ã„ã‚‹çµ„ç¹”ç‰ã¨ã¯å…¨ãé–¢ä¿‚ã‚ã‚Šã¾ã›ã‚“ã€‚ Linq to SQLã®ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã‚’å…¬é–‹ã—ã¾ã™ã€‚ SQLãŒã‚ã‹ã‚‹ã“ã¨ã‚’å‰æã«è¨˜äº‹ã‚’æ›¸ã„ã¦ã„ã¾ã™ã€‚ SQLã‚¯ã‚¨ãƒªãŒã©ã‚“ãªæ„Ÿã˜ã§å‡ºåŠ›ã•ã‚Œã‚‹ã®ã‹ã€ç¢ºèªã—ã¦ã„ã„ãã¾ã—ã‚‡ã†ã€‚ åˆå¿ƒè€…ãŒèªã‚€ã«ã‚ãŸã£ã¦ var filtedQuery = q.Where(a => a.ColorCode < j); ã“ã‚“ãªè¡Œã§Î»å¼ï¼ˆãƒ©ãƒ ãƒ€å¼ï¼‰ãŒã„ãã¤ã‹ä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚ ãŸã¶ã‚“ã€Œa => ã¯ä½•ï¼Ÿçªç„¶å®£è¨€ã‚‚ç„¡ã—ã«å‡ºã¦ãã‚‹ã‘ã©ã€ã¨æ€ã„ã¾ã™ãŒã€ ãã†ã„ã†ã‚‚ã‚“ã ã¨æ€ã£ã¦ã€ã¾ãšã¯ã€ã²ã¨é€šã‚Šæ‰‹ç¿’ã„ã®ï¼‘ã‹ã‚‰ï¼˜ã‚’èªã‚“ã§ãã ã•ã„ã€‚ â€»åˆã‚ã¦ã®äººã¯ã‚¹ãƒ†ãƒƒãƒ—å®Ÿè¡Œã‚’ï¼‘å›žã—ã¦ã¿ã¦ãã ã•ã„ã€‚ Linq to SQLÂ æ‰‹ç¿’ã„ã€€ãã®ï¼‘
takets 2014/03/25
Linq

c#
ãƒªãƒ³ã‚¯
LINQ to SQL:1ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç‰¹å®šã™ã‚‹
ASP.NETã€Silverlightç‰ã€.NET Frameworkã®ä¸ã§ã‚‚Webã«é–¢ã™ã‚‹æŠ€è¡“ã®Tipsã€æƒ…å ±ã‚’ä¸»ã«ã¾ã¨ã‚ã¦ã„ã¾ã™ã€‚ â€»ã“ã®æŠ•ç¨¿ã¯Microsoft Visual Studio 2008 Beta2ã§å‹•ä½œã‚’ç¢ºèªã—ã¦ã„ã¾ã™ã€‚ å‰å›žãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦è¨˜è¿°ã—ãŸã‚ã¨ã§ã€è¿½åŠ ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’å‰Šé™¤ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦è¿°ã¹ã¦ã¿ã‚ˆã†ã¨è€ƒãˆã¦ã„ã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ã‚’å‰Šé™¤ã™ã‚‹ã«ã¯ã€è©²å½“ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ç‰¹å®šã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ãã“ã§è¿½åŠ ã—ãŸ1ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç‰¹å®šã™ã‚‹ãŸã‚ã®æ–¹æ³•ã‚’è€ƒãˆã¦ã„ãŸã¨ã“ã‚ã€ãƒ—ãƒã‚°ãƒ©ãƒ ã®è¨˜è¿°æ–¹æ³•ãŒã„ãã¤ã‹ã‚ã‚‹ã“ã¨ã«æ°—ã¥ãã¾ã—ãŸã€‚ ãã®è©¦è¡ŒéŒ¯èª¤ã®çµŒéŽã‚’ã¾ã¨ã‚ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ æœ€åˆã¯ã€ä¸€ç•ªæœ€å¾Œã«ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ç‰¹å®šã™ã‚‹ãŸã‚ã€Lastãƒ¡ã‚½ãƒƒãƒ‰ãŒåˆ©ç”¨ã§ããªã„ã‹ã€ã¨è€ƒãˆã¦æ¬¡ã®ã‚ˆã†ã«è¨˜è¿°ã—ã¦ã¿ã¾ã—ãŸã€‚ People deletePerson = dtc.People.Last();
takets 2014/03/19
Firstã¨Singleã§åŒã˜ã‚ˆã†ã«ä½¿ãˆã‚‹ã‚ˆã†ã«è¦‹ãˆã¾ã™ãŒã€Singleã®å ´åˆã€æ¤œç´¢çµæžœã«è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãŒå«ã¾ã‚Œã‚‹ã¨å®Ÿè¡Œæ™‚ã«"ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ã«è¤‡æ•°ã®è¦ç´ ãŒå«ã¾ã‚Œã¦ã„ã¾ã™"ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã¾ã™ã€‚ ä¸»ã‚ãƒ¼ã‚’æŒ‡å®šã—ã¦æ¤œç´¢ã™ã‚‹ã€ã¨ã„ã£ãŸ

c#

Linq
ãƒªãƒ³ã‚¯
LINQ to SQL:å€¤ã‚’è¤‡æ•°ç‰¹å®šã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã™ã‚‹
ASP.NETã€Silverlightç‰ã€.NET Frameworkã®ä¸ã§ã‚‚Webã«é–¢ã™ã‚‹æŠ€è¡“ã®Tipsã€æƒ…å ±ã‚’ä¸»ã«ã¾ã¨ã‚ã¦ã„ã¾ã™ã€‚ â€»ã“ã®æŠ•ç¨¿ã¯Microsoft Visual Studio 2008 Beta2ã§å‹•ä½œã‚’ç¢ºèªã—ã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã®æ›´æ–°ã®è©±ã‚’ã™ã‚‹å‰ã«ã¡ã‚‡ã£ã¨å¯„ã‚Šé“ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã™ã‚‹å ´åˆã«ã€ãŸã¨ãˆã°IDãŒ1ã€3ã€4ã€8ã®äººã ã‘ã‚’æŠ½å‡ºã™ã‚‹ã€ã¨ã„ã£ãŸæ„Ÿã˜ã§å€¤ã‚’è¤‡æ•°ç‰¹å®šã—ã€ãã®ãƒ‡ãƒ¼ã‚¿ã ã‘ã‚’æŠ½å‡ºã—ãŸã„ã¨ã„ã†å ´åˆãŒã‚ã‚Šã¾ã™ã€‚SQLæ–‡ã§ã„ã†ã¨INã‚’åˆ©ç”¨ã—ãŸã„å ´åˆã€ã¨ã„ã£ãŸã»ã†ãŒã‚ã‹ã‚Šã‚„ã™ã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã“ã†ã„ã£ãŸå ´åˆã«é…åˆ—ã‚„Listã®Containsãƒ¡ã‚½ãƒƒãƒ‰ã‚’whereã®æ¡ä»¶ã¨ã—ã¦è¨˜è¿°ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ using System; using System.Linq; using System.Data.Linq.SqlClient; using System.Collec
takets 2014/03/18
not inã‚’ã™ã‚‹ã‚„ã‚Šã‹ãŸã€‚

c#

Linq
ãƒªãƒ³ã‚¯
ã€LINQã€‘è¦ç´ ã®å€‹æ•°ã‚’å–å¾—ã™ã‚‹ã«ã¯ï¼ˆCounté›†è¨ˆæ¼”ç®—åï¼‰
// ãƒ‡ãƒ¼ã‚¿ string[] userArray = { "Taro", "Jiro", "Saburo", "Shiro", "Goro" }; // ã‚¯ã‚¨ãƒªå¼ã®å ´åˆ var query = (from user in userArray select user).Count(); // ãƒ©ãƒ ãƒ€å¼ã®å ´åˆ var lambda = userArray.Select(s => s).Count(); // çµæžœ â‡’ 5
takets 2014/03/18
Linq
ãƒªãƒ³ã‚¯
1