#linqpad

[sonergonul]

(https://youtube.com/watch?v=j7enLXy2F5g&feature=share gönderdi)

[cheerchain]

LPDENTERP LINQPad Developer Enterprise license 商用單機下載版 (ESD) - The .NET Programmer’s Playground! 立即測試任何C＃/ F＃/ VB片段或程式 在LINQ（或SQL）中查詢資料庫 - #SQL / #CE / #Azure, #Oracle, #SQLite 和 #MySQL #NuGet #Language #Integrated #Query 享受豐富的輸出格式，可選的 #自動完成 和 #整合 #偵錯 使用您喜歡的.NET語言編寫腳本並自動化 https://www.pcstore.com.tw/cheerchain/M55706734.htm

[ducnghiatq]

During some spare time last weekend I decided to look into booting up Umbraco outside of a web context. I know this has been done before in various different ways but for this I wanted to just try to

[samtran-me]

Linqpad-The Developers' Playground

Linqpad-The Developers’ Playground

There’s a little tool that’s been around for years but still largely unknown outside the software engineering space-the legendary Linqpad by Perth based engineer/author Joseph Albahari.

It’s been described as a software utility targeted at .Net development but it does so much more including helping thousands of developers and engineers across the globe each day with prototyping, learning and…

View On WordPress

[dave-tech]

Using Graphviz Wrapper from LinqPad

Install Graphviz for Windows and clone the git repository for the wrapper

Then, build the wrapper project.

In a new LinqPad query add the output of the build. And set the import namespaces to:

GraphVizWrapper GraphVizWrapper.Commands GraphVizWrapper.Queries

After all that is setup, you can now run this sample code from LinqPad:

var getStartProcessQuery = new GetStartProcessQuery(); var getProcessStartInfoQuery = new GetProcessStartInfoQuery(); var registerLayoutPluginCommand = new RegisterLayoutPluginCommand(getProcessStartInfoQuery, getStartProcessQuery); var wrapper = new GraphGeneration(getStartProcessQuery, getProcessStartInfoQuery, registerLayoutPluginCommand); wrapper.GraphvizPath = @"C:\Program Files (x86)\Graphviz2.38\bin"; wrapper.RenderingEngine = Enums.RenderingEngine.Dot; var output = wrapper.GenerateGraph( @"digraph{a -> b; b -> c; c -> a;}", Enums.GraphReturnType.Png); Util.RawHtml( String.Format( "<img src=\"data:image/jpg;base64,{0}\" />", Convert.ToBase64String(output))).Dump();

[decoupledlogic]

Rethrowing More Expressive Exceptions with C#

This post was contributed by Jonathan Hamm, one of the developer gurus I have the privilege of working with at my day job.

I did not realize this behavior with rethrowing exceptions existed where information can be added to the exception by the “catch” then in subsequent “catch” blocks the data will remain. It does make sense now with this test.

The inner most method throws an error, the next…

View On WordPress

[coldacid]

Recent projects

Some stuff I’ve been working on lately (apart from work projects or games):

I created a new plugin for Media Browser Server, meant to force the creation or updating of local metadata files for items in the media library. This plugin is pretty raw and currently only available as source code on GitHub, but it provides the functionality I needed to keep an update of Media Browser from early in the…

View On WordPress

[thevog]

Use LINQPAD to write the contents of a BLOB column in your database table to a file

Hey all ! This is my first blog post, so bear with me.

Going to show you a really neat way to get at the binary data stored in a BLOB column of your database table.

I'm going to keep the table simple. Lets assume we have a table that looks something like this (I'm using a SQL Server database):

CREATE TABLE [dbo].[MyBlobs](  [Id] [int] NOT NULL,  [Filename] [nvarchar](255) NOT NULL,  [BinaryData] [image] NOT NULL )

For this example we can also assume we have 3 rows:

Id=1, Filename="music.mp3", BinaryData=[bytes - lots of them] Id=2, Filename="foo.pdf", BinaryData=[bytes - lots of them] Id=3, Filename="cheese.jpg", BinaryData=[bytes - lots of them]

Lets open LINQPAD and enter the following code into the query window as a "C# Program":

void Main() {  var tableRow =   MyBlobs   .Where (r => r.Id == 2)   .SingleOrDefault();

 if (tableRow != null)   System.IO.File.WriteAllBytes(    Path.Combine(@"D:\", tableRow.Filename),     tableRow.BinaryData.ToArray());

 Console.WriteLine (tableRow); }

The first line is fairly standard LINQ that retrieves the row in the table with Id of 2.

The second line writes the file out to the D: drive.

The trick here is calling ToArray() on the BinaryData column of the row. LINQPAD has done all the work for us to represent each column from the database table as a property on the object returned by the query in the first line.

If we look on our D:\ drive, we will find the file "foo.pdf".

And that's all folks.

PS. There's some great discussion on the oreilly forum about displaying images from your database columns right inside LINQPAD.

Check it out here: http://forums.oreilly.com/topic/21099-displaying-embedded-images-in-linqpad/