WillCore.Data (Entity Framework for Node.JS)

Philip Schoeman — Thu, 23 Jan 2020 19:14:17 +0000

A while back I wanted to use MySQL in a NodeJS project. Coming from a C# background, I wanted to use something like Entity Framework. To my surprise I found that there is no Entity Framework equivalent for Node, so I decided to write my own.

I wanted something that supports code-first database creation, migrations and to write my queries using nothing else than JavaScript.

So I built a library (or framework) that is small and yet powerful to allow me to do what I wanted to do. It turned out pretty well (or I think), and just wanted to share it.

https://github.com/PhilipCoder/willcore.data

Features:
1) Code-first database generation.
2) Simple API.
3) Supports queryables.
4) Database migrations.
5) Async
6) Using only JS to query a DB.

Please note that it is still the first release, so any feedback on improvements would be wellcome.

WillCore.Requests: Auto Generating Fetch and XMLXHR Requests for Web API

Philip Schoeman — Wed, 11 Sep 2019 07:47:39 +0000

.NET CORE 2.2 WebAPI and JavaScript

A developer usually tend to avoid repetitive work. In coding we have the DRY principle, and I like to apply that philosophy to the way I code. That is why I got frustrated typing out Fetch request after Fetch request trying to consume a .NET Core Web API service I wrote for a project of my own. Why can't I just reference a WSDL and add a service reference to my JS?

That is when I got the idea to write a library to build JS code from your controllers, parameters and results. The generated code should also have full JSDoc comments so you can have intellisense support in Visual Studio.

I tried different routes, from T4 templates to building JavaScript via a node reference in C#. In the end I ended up with custom templates and a hierarchical C# class structure mimicking that of JavaScript.

I am planning to add the following to the library:
1) C# code generator that will also automatically build a NuGet package with all the code to consume your API.
2) C# class and action level attributes that allows you to generate custom JSDoc description comments.
3) Functionality to auto generate a HTML page that will allow you to add predefined, calculated and static parameters and results for every controller action, so that you can test your API by simply open the page.

I think it turned out pretty good, but any feedback is welcome.

Please note that the library is still in alpha state, but I have used it on a different projects and it seems quite stable. Is this something people would use?

GitHub: https://github.com/PhilipCoder/WillCoreRequests

DEV Community: Philip Schoeman

WillCore.Data (Entity Framework for Node.JS)

WillCore.Requests: Auto Generating Fetch and XMLXHR Requests for Web API

.NET CORE 2.2 WebAPI and JavaScript