.NET Interactive with SQL!| .NET Notebooks in Visual Studio Code
efcore๋ฅผ ํตํ linq2sql์์ ๊ฐ๋ฅํฉ๋๋ค.
https://devblogs.microsoft.com/dotnet/net-interactive-with-sql-net-notebooks-in-visual-studio-code/
.NET Interactive with SQL!| .NET Notebooks in Visual Studio Code
efcore๋ฅผ ํตํ linq2sql์์ ๊ฐ๋ฅํฉ๋๋ค.
https://devblogs.microsoft.com/dotnet/net-interactive-with-sql-net-notebooks-in-visual-studio-code/
๊ธฐ์กด์ .NET Interactive ์ฐ๊ณ ์์๋๋ฐ ์ด์ EF Core๊น์ง ๊ฐ๋ฅํ๊ตฐ์!
๊ธ์ ์ฌ๋ฆฐ๋ค ํ ์คํธํด๋ณด๋ identity ํจํค์ง ๊ด๋ จ ์ค๋ฅ๊ฐ ์์ด์ efcore context ์์ฑ ์์ ์ด ์๋์ด ์ด์๋ฑ๋ก์ ํ๋๋ 2๋ฌ๋ฐ๋ง์ ํจ์น๊ฐ ๋์๋จ ๋ด์ฉ์ ๋ฐ์์ต๋๋ค. ๊ณ ๋ง์ธ๋ฐ๋ฆ์ ๋๋ค. ๊ฐ๋จํ DB์์ ์ ์ฝ๊ฒ ํ ์ ์๊ฒ ๋์ด ๊ธฐ์๋ค์~~
#i "nuget:https://pkgs.dev.azure.com/dnceng/public/_packaging/dotnet-tools/nuget/v3/index.json"
#r "nuget:Microsoft.DotNet.Interactive.SqlServer,*-*"
#!connect mssql --create-dbcontext --kernel-name RazorPagesEF "Persist Security Info=False; Integrated Security=false; Initial Catalog=RazorPages-CRUD; Server=****; User Id=***; Password=***;"
RazorPagesEF.Products.Where(p => p.Id == 7).FirstOrDefault().Display();
RazorPagesEF.Products.Display();
#!sql-RazorPagesEF
select * from Product
๊ฐ๋จํ ํ
์คํธ๋ด์ฉ์ ์บก์ณ ํ์ฌ
๊ตฟ๊ตฟ์ ๋๋ค! ^^