[B! linq] kiyo_hikoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kiyo_hiko id:kiyo_hiko

linqã«é–¢ã™ã‚‹kiyo_hikoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{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}}

High Performance PowerShell with LINQ - Simple Talk
kiyo_hiko 2024/08/06
PowerShell

LINQ
ãƒªãƒ³ã‚¯
Bug? MVC5: EF6 wants to delete database on LINQ query?
kiyo_hiko 2015/07/29
ã“ã®æŒ™å‹•å‡ºãŸã‘ã©åŽŸå› ã‚‚æ„å‘³ã‚‚ã‚ã‹ã‚“ã // DropCreateDatabaseAlwaysã§DBåˆæœŸåŒ–ã—ã¦Controllerã§ã“ã‚“ãªã‚³ãƒ¼ãƒ‰æ›¸ã„ã¦ãƒ‡ãƒãƒƒã‚°ã—ãŸã‚‰å‡ºãŸâ†’ViewBag.DropDownOptions = from e in db.DropDown select new SelectListItem { Value = e.Id.ToString(), Text = e.Name };

asp

dotnet

mvc

5

efw

linq
ãƒªãƒ³ã‚¯
LINQï¼šãƒ‡ãƒ¼ã‚¿ã‚’ä¸¦ã¹æ›¿ãˆã‚‹ - orderbyå¥ï¼»C#ï¼½
æœ¬ã‚³ãƒ¼ãƒŠãƒ¼ã¯ã€ç§€å’Œã‚·ã‚¹ãƒ†ãƒ ç™ºè¡Œã®æ›¸ç±ã€ŽASP.NET MVC 5 å®Ÿè·µãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã€ã®ä¸ã‹ã‚‰ã€ç‰¹ã«Build Insiderã®èªè€…ã«æœ‰ç”¨ã ã¨è€ƒãˆã‚‰ã‚Œã‚‹é …ç›®ã‚’ç·¨é›†éƒ¨ãŒé¸ã³ã€åŒç¤¾ã®è¨±å¯ã‚’å¾—ã¦è»¢è¼‰ã—ãŸã‚‚ã®ã§ã™ã€‚ ã€ŽASP.NET MVC 5 å®Ÿè·µãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã€ã®è©³ç´°ã‚„è³¼å…¥ã¯ç§€å’Œã‚·ã‚¹ãƒ†ãƒ ã®ã‚µã‚¤ãƒˆã‚„ç›®æ¬¡ãƒšãƒ¼ã‚¸ã‚’ã”è¦§ãã ã•ã„ã€‚
kiyo_hiko 2015/07/15
"ã‚½ãƒ¼ãƒˆå¯èƒ½ãªã‚°ãƒªãƒƒãƒ‰è¡¨ã‚’ä½œæˆã™ã‚‹"

cs

linq
ãƒªãƒ³ã‚¯
Returning DbQuery to view that requires IEnumerable
kiyo_hiko 2015/07/15
LINQå¼ã®çµæžœã¯DbQueryã«è©•ä¾¡ã•ã‚Œã‚‹ã®ã§ã€ToListã§List<T>ã«å¤‰æ›ã™ã‚‹ã¨ã„ã†ã“ã¨

cs

linq

list
ãƒªãƒ³ã‚¯
LINQï¼ˆãƒªãƒ³ã‚¯ï¼‰ã®åŸºç¤ŽçŸ¥è˜
VS 2008æœ€å¤§ã®æ–°æ©Ÿèƒ½LINQã‚’åˆ†ã‹ã‚Šã‚„ã™ãè§£èª¬ã€‚C#ã‚³ãƒ¼ãƒ‰ã§DBã‚„ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’æ¤œç´¢ã€‚LINQã‚’å§‹ã‚ã‚‹ã«ã¯ã¾ãšã“ã“ã‹ã‚‰ã€‚ é€£è¼‰ç›®æ¬¡ Visual Studio 2008ï¼ˆä»¥ä¸‹ã€VS 2008ï¼‰ã«ã¯ã•ã¾ã–ã¾ãªæ–°æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã¦ã„ã¾ã™ãŒã€æœ€å¤§ã®æ–°æ©Ÿèƒ½ã¨ã„ãˆã°ã‚„ã¯ã‚Šã€ŒLINQã€ï¼ˆã€Œãƒªãƒ³ã‚¯ã€ã¨èªã¿ã¾ã™ï¼‰ã§ã—ã‚‡ã†ã€‚ LINQã¨ã¯ã€ Language INtegrated Query ã®ç•¥ã§ã€Œçµ±åˆè¨€èªžã‚¯ã‚¨ãƒªã€ã¨è¨³ã•ã‚Œã¾ã™ãŒã€ã‚‚ã†å°‘ã—åˆ†ã‹ã‚Šã‚„ã™ãã„ã„æ›ãˆã‚Œã°ã€ è¨€èªžï¼ˆC#ã‚„Visual Basicãªã©ï¼‰ã®ã‚³ãƒ¼ãƒ‰å†…ã«è¨˜è¿°ã§ãã‚‹ã‚¯ã‚¨ãƒª ã¨ãªã‚Šã¾ã™ã€‚ã‚¯ã‚¨ãƒªã¨ã¯ã€Œå•ã„åˆã‚ã›ã€ã§ã™ã€‚é–‹ç™ºã§ã‚¯ã‚¨ãƒªã¨ã„ãˆã°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¤œç´¢ã«ä½¿ã‚ã‚Œã‚‹SQLæ–‡ãŒä»£è¡¨çš„ã§ã™ãŒã€LINQã§ã¯SQLæ–‡ã«ä¼¼ãŸæ§‹æ–‡ã«ã‚ˆã‚Šã‚¯ã‚¨ãƒªã‚’è¨˜è¿°ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã¯ã˜ã‚ã€ã•ã¾ã–ã¾ãªå¯¾è±¡ã‹ã‚‰ã€ãƒ‡ãƒ¼ã‚¿ã®æ¤œç´¢ã‚„é›†è¨ˆã€å–å¾—ãªã©ãŒå¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ LINQã«ã‚ˆã‚‹ã‚¯
kiyo_hiko 2015/07/14
linq

å…¥é–€
ãƒªãƒ³ã‚¯
LINQæ–‡ã®æŒ™å‹•ã‚„ç”Ÿæˆã•ã‚Œã‚‹SQLæ–‡ã‚’ç¢ºèªã™ã‚‹ã«ã¯ï¼Ÿï¼»3.5ã€4ã€C#ã€VBï¼½ - ï¼ IT
C# 3.0ä»¥é™ã‚„Visual Basic 9.0ä»¥é™ã§ã¯ã€SQLãƒ©ã‚¤ã‚¯ãªæ§‹æ–‡ã§ãƒ‡ãƒ¼ã‚¿ã®ã‚¯ã‚¨ãƒªã‚’ç°¡å˜ã«è¨˜è¿°ã§ãã‚‹LINQï¼ˆLanguage INtegrated Queryï¼‰ã¨ã„ã†æ©Ÿèƒ½ãŒæè¼‰ã•ã‚Œã¦ã„ã‚‹ã€‚ã—ã‹ã—ã€LINQã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚¯ã‚¨ãƒªã®è¨˜è¿°ï¼ˆç‰¹ã«SQL Serverãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¯¾è±¡ã«ã—ãŸLINQï¼‰ã¯ã€æ–‡å—åˆ—ã®SQLæ–‡ã§ã¯ãªãã€ã‚½ãƒ¼ã‚¹ãƒ»ãƒ•ã‚¡ã‚¤ãƒ«ä¸ã«è¨˜è¿°ã•ã‚Œã‚‹ã‚³ãƒ¼ãƒ‰ã¨ãªã‚‹ã€‚ãã®ãŸã‚ã€ã‚¯ã‚¨ãƒªã®å®Ÿè¡Œçµæžœã‚’æ‰‹è»½ã«ç¢ºèªã§ããªã„ã€‚ å¾“æ¥ã®æ–‡å—åˆ—ã®SQLæ–‡ã§ã‚ã‚Œã°ã€æ„å›³ã—ãŸçµæžœãŒè¿”ã£ã¦ãã‚‹ã‹ã©ã†ã‹ã‚’ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯èµ·å‹•ã›ãšã«ã€Visual Studioã‚„SQL Server Management Studioã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªã‚’ç™ºè¡Œã§ãã‚‹ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦æ‰‹è»½ã«æ¤œè¨¼ã§ããŸã€‚ã—ã‹ã—LINQæ–‡ã®å ´åˆã¯ã€åŸºæœ¬çš„ã«ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’èµ·å‹•ã—ã¦ã€ãƒ‡ãƒãƒƒã‚°ã—ãŸã‚Šã€å‡¦ç†çµæžœã®ãƒ‡ãƒ¼ã‚¿ã‚’DataGridã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãªã©ã«è¡¨
kiyo_hiko 2015/07/14
from elem in table where elem.predicate(operand) orderby elem.field direction select elem

linq

å…¥é–€
ãƒªãƒ³ã‚¯
Looking for a C#-REPL compatible for LINQ
kiyo_hiko 2015/07/14
LINQPadãƒã‚§ãƒƒã‚¯ã™ã‚‹ã‹ã€‚

cs

repl

linq

efw
ãƒªãƒ³ã‚¯
VSå‹‰å¼·ä¼š .NET Framework å…¥é–€
3. 0. è‡ªå·±ç´¹ä»‹ HN: kamu(@kamukiriri) ä»•äº‹:å…ƒ.NETç³»æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºè€… ç¾iOSã‚¢ãƒ—ãƒªé–‹ç™ºè€… ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æš¦: C#, VB.NET, Objective-C, Javascript, PHP, VB6, VBA, VBS, etc... 4. 1. ã¯ã˜ã‚ã«(1) ã“ã®ç™ºè¡¨ã®å†…å®¹ã¯ã€ã€Œ.NET Frameworkå…¥é–€ã€ ã§ã™ãŒã€.NET Frameworkã®ä½¿ã„æ–¹ã‚’å…·ä½“çš„ã« èª¬æ˜Žã™ã‚‹ç‚ºã«ã€ä»¥ä¸‹ã®è¨€èªžã‚’ä¾‹ã¨ã—ã¦ä½¿ç”¨ã—ã¾ã™ ãƒ»Visual C#ã€€(ä»¥å¾ŒC#) ãƒ»Visual Basic.NETã€€(ä»¥å¾ŒVB.NET)
kiyo_hiko 2015/07/09
Nullableã€Collectionã€LINQã€‚Javaã®Map<T>â‰’C#ã ã¨Dictionary<T>â€¦ï¼Ÿã€‚ã‚‰ã—ã„

cs

dotnet

linq
ãƒªãƒ³ã‚¯
1