C# Line Reader

-

Sometimes I'll get a text file to parse, where it's too big or too complex for a spreadsheet, and not worth the trouble of importing to a database. Here's a quick way to parse the file line-by-line with C#

Here's the same thing in NodeJS - personally I think the C# way is a little easier, especially since .NET Core and the dotnet CLI came out.

View code on GitHub

Comments

Post a Comment

Popular posts from this blog

Left Join in Entity Framework

-
Image
If you need a left join in Entity Framework, you have a couple options. First, if you’re using a real foreign key that just happens to be nullable, then you can use the regular navigation properties. But if you’re doing a left join manually, or with other factors, then you need to do things just a little differently: Suppose we have the following database: create table dbo . Foods ( FoodID int not null identity primary key , FoodName varchar ( 100 ) not null ) ; go insert dbo . Foods ( FoodName ) values ( 'Pizza' ) , ( 'Chicken' ) , ( 'Potatoes' ) , ( 'Broccoli' ) ; go create table dbo . People ( PersonID int not null identity primary key , FirstName varchar ( 100 ) not null , FavoriteFoodID int null , constraint FK_Person_FavoriteFoodID foreign key ( FavoriteFoodID ) references dbo . Foods ( FoodID ) ) ; go insert dbo . People ( FirstName , FavoriteFoodID ) values ( 'John' , 1 ) , ...
Read more

JavaScript Spread Operator

-
Image
With JavaScript's spread operator, you can clone an array, or inject the values into another array, or into the parameters of a function. You also can combine the properties of two objects when you build it using an object literal. View code on GitHub
Read more

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