SPToCore
SPToCore copied to clipboard
DarioN1
Stored procedure scaffolding utility for .netcore3
```c# private static string SP_GetType(string type, bool isNullable) { type = type.ToLower().Trim(); if (type == "int") return "int" + (isNullable ? "?" : ""); else if (type.Contains("numeric")) return "decimal" +...
Why it's not possible to specify witch SP to include (and not all the schema) ?
public void Collection_Save(string PMN,string CollectionNotes,**WTF**?! ReserveBalance,string UpdatedUser) The actual SQL sproc: CREATE proc [dbo].[Collection_Save] @PMN nvarchar(15), @CollectionNotes varchar(max), @ReserveBalance **money,** @UpdatedUser varchar(50)
hi @DarioN1 , My team has been using your amazing tool and we are so greatfull with the results. While we used it, one of my teammates realices that the...
This tool is great, at the moment I'm using it but I ended up just copying pieces over to my .net 5 generated context rather then using the output directly,...
I was receiving weird cast error (that int16 could not be cast to int32) due to smallint -> int mapping. smallint should map to short (int16), not int32. This should...
Hi, i downloaded project. try to compile. in output SPToCoreT4.cs file on line 411 this.Write("\n"); bunch of syntax errors. UPDATE: as i found out there is a } in line...
1. `SP_GetType`, `SP_GetDbType`: There are some `if (A) {...} else if (A) {...}` branches. The second branch probably should check for a different type. 2. `SPToCoreScan`: There are three empty...
When scaffolding a stored procedure with a parameter type of "money", the procedure is skipped because it is unmapped in the following places: private static string SP_GetType(string type, bool isNullable)...
I have noticed that after command SPToCore.exe generate in DbContext result file a call to a method Query which has been replaced with Entity. Source: [Microsoft Doc](https://docs.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.modelbuilder.query?view=efcore-3.1)
