SQL Print output in ADO.NET

-

Thank you to this StackOverflow answer for showing how to retrieve PRINT result from SQL Server in C#:

conn.InfoMessage += (sender, e) => {
    // e.Message contains the print output
};

Comments

Post a Comment

Popular posts from this blog

C# Record Serialization

-
Image
With .NET 5, you get a new concept called record . Lots of cool things, one of which is that you can serialize and deserialize with JSON just like a class, except you don't need to define properties one at a time, or even the body of the type. Apparently XML serialization doesn't quite work, so stick with JSON. View code on GitHub
Read more

Razor Pages AJAX

-
Image
Razor Pages is a fantastic alternative to ASP.NET MVC. Here's one reason - CSRF protection is included by default. That's great news, but it means that you can't execute AJAX posts as easily. Fortunately, it's still not difficult to do a post. Here's how. View code on GitHub
Read more

SQL Dates Table

-
create table dbo . Dates ( TheDate date not null , constraint PK_Dates primary key ( TheDate ) ) ; go declare @StartDate date = '1950-01-01' ; declare @EndDate date = '2099-12-31' ; ; with cte as ( select @StartDate [ TheDate ] union all select dateadd ( day , 1 , [ TheDate ] ) from cte where dateadd ( day , 1 , [ TheDate ] ) < = @EndDate ) insert dbo . Dates ( TheDate ) select TheDate from cte option ( maxrecursion 0 ) ; go select * from dbo . Dates order by TheDate ; go
Read more