.NET CoreCLR现在是开源的，因此我通过Microsoft Power BI运行了GitHub存储库

The hits keep on coming, Dear Reader. Just as we announced a few months back, .NET Core is open source. We said it would run on Windows, Mac, and Linux, but then the work of doing it has to actually happen. ;)

亲爱的读者，热门歌曲不断上演。 就像几个月前我们宣布的那样，.NET Core是开源的。 我们说它可以在Windows，Mac和Linux上运行，但是这样做实际上必须完成。 ;)

Go check out the .NET Framework Blog. Today the .NET team put the Core CLR up on GitHub. It's open source and it's under the MIT License. This includes the Core CLR source, the new RyuJIT, the .NET GC, native interop and everything you need to fork, clone, and build your own personal copy of the .NET Core CLR. What a cool day, and what an immense amount of work (both technical and legal) to make it happen. Years in the making, but still lots of work to do.

前往.NET Framework Blog。 今天，.NET团队将Core CLR安装在GitHub上。 它是开源的，并且受MIT许可。 这包括Core CLR源代码，新的RyuJIT，.NET GC，本机互操作以及您需要进行的所有分支，克隆和构建.NET Core CLR个人副本。 多么美好的一天，以及要实现这一目标需要进行的大量工作(技术和法律工作)。 经过多年的努力，但仍有很多工作要做。

The GitHub repo has 2.6ish MILLION lines of code. They say when it's all said and done.NET Core will be about 5 MILLION lines of open source code.

GitHub存储库中有2.6百万条代码行。 他们说，一切都说定了。NETCore大约有500万行开源代码。

The .NET Blog did a nice pie chart, but honestly, I found it to be not enough. It basically was a big grey circle that said "other 2.2M." ;)

.NET博客的饼图很好，但是说实话，我发现这还不够。 基本上是一个大灰圈，上面写着“其他2.2M”。 ;)

I'd like a little more insight, but I don't know if I have the compute power, or the patience, frankly, to analyze this code repository. Or do I?

我想要更多的见解，但是坦白地说，我不知道我是否具有计算能力或耐心来分析此代码存储库。 还是我

I decided to import the repository into Microsoft Power BI preview. Power BI (BI means "Business Intelligence") is an amazing service that you can use (usually for FREE, depending on your data source) to pull in huge amounts of data and ask questions of that data. Watch for a great video on this at http://friday.azure.com this week or next.

我决定将存储库导入Microsoft Power BI预览。 Power BI(BI表示“商业智能”)是一项了不起的服务，您可以使用它(通常是免费的，具体取决于您的数据源)来提取大量数据并询问该数据问题。 本周或下周在http://friday.azure.com上观看有关此视频的精彩视频。

I logged into http://powerbi.com (It's US only for the preview, sorry) and clicked Get Data. I then selected GitHub as the source of my data and authorized Power BI to talk to GitHub on my behalf. Crazy, AMIRITE?

我登录http://powerbi.com (抱歉，仅在美国使用)，然后单击“获取数据”。 然后，我选择GitHub作为数据源，并授权Power BI代表我与GitHub进行交谈。 疯狂，AMIRITE？

关于.NET团队的“ CoreCLR” GitHub存储库，Power BI告诉我什么？ (What does Power BI tell me about the .NET Team's "CoreCLR" GitHub repository?)

Here's what Power BI told me.

这是Power BI告诉我的。

Let's dig in. Looks like Stephen Toub has worked on a LOT of this code. He's super brilliant and very nice, BTW.

让我们深入研究。看起来Stephen Toub从事了很多这样的代码。 他非常聪明，非常友善，顺便说一句。

Editing the query and looking at Dates and Times, it seems the .NET Team commits code at ALL hours. They are really feeling "committable" around 3 to 4 pm, but they'll even put code in at 4 in the morning!

编辑查询并查看日期和时间，.NET团队似乎在所有时间都提交代码。 他们真的在下午3点到4点感到“值得”，但是他们甚至会在凌晨4点输入代码！

Here's a more intense way to look at it.

这是一种更强烈的观察方式。

One of the insanely cool things about Power BI is the ability to ask your data questions in plain English. Given that my SQL abilities have atrophied to "Select * from LittleBobbyTables" this is particularly useful to me.

关于Power BI的一个很酷的事情之一就是能够用简单的英语问数据问题。 鉴于我SQL功能已经无法使用“从LittleBobbyTables中选择*”，这对我特别有用。

I asked it "issues that are open sorted by date" and you'll notice that not only did it work, but it showed me what I meant underneath my query.

我问它“按日期排序的未解决问题”，您会注意到它不仅起作用，而且还显示了我在查询中的含义。

What about issues closed by a certain person?

某个人解决的问题呢？

I'm running around in this tool just building charts and asking questions of the repo. It's all in HTML5 but it's just like Excel. It's amazing.

我在这个工具中跑来跑去，只是建立图表并询问回购交易的问题。 所有内容都在HTML5中，但就像Excel。 太奇妙了。

Open issues from last year?

去年有未解决的问题？

Average time to close an issue in hours?

解决问题的平均时间(小时)？

It's amazing to be running queries like this on something as significant as the now open-sourced .NET Core CLR. I didn't need to be an employee to do it. I didn't need special access, I just did it. I'm enjoying this new Microsoft, and very much digging Power BI. Next I'm going to put my Blood Sugar and Diabetes Data in Power PI and encourage others to do the same.

像现在开放源代码的.NET Core CLR一样重要的事情上运行这样的查询真是太神奇了。 我并不需要成为一名雇员。 我不需要特殊的访问权限，而已。 我很喜欢这个新的Microsoft，并且非常喜欢Power BI。 接下来，我将把血糖和糖尿病数据放入Power PI中，并鼓励其他人也这样做。

P.S. Check out the code for the Core CLR Hello World app. When was the last time you saw an ASCII Art Linux Penguin in Microsoft Source code? ;)

PS查看Core CLR Hello World应用程序的代码。 您是什么时候最后一次在Microsoft源代码中看到ASCII Art Linux Penguin ？ ;)

翻译自: https://www.hanselman.com/blog/the-net-coreclr-is-now-open-source-so-i-ran-the-github-repo-through-microsoft-power-bi