I need to return the idCity. If it does not find in one table, it is mandatory in the other.
Return is null.
My Query
public const string sql = @"DECLARE @retorno AS INT = 0;
SELECT @retorno = id...
I have the following difficulties:
1 - View data from a select with inner join. The fields in the other tables do not all appear in the select, and those that appear have a value of zero (0).
2 - Write the data in the database. Even if you...
Hello!
I have a question regarding the return of an object with an already-filled 'Value Object', for example:
I have the User.cs class
public class User
{
public Guid UserId { get; set; }
public string Name { get; set; }
pub...
Good morning everyone, alright?
I need to control the Dapper transaction using SimpleCrud.
I have an application in asp.net core using Injection Dependency.
I'll post parts of the code only (removing ViewModel to Model conversions and vali...
I just saw content I was studying about performance and optimization in ASP.Net applications. They presented me with a diagnostic tool called Glimpse .
The tool's operation is perfect, it measures ajax requests execution times, SQL quer...
In a project, I have some standard methods, for example:
//Execute Return List DapperORM.RetornoList<EmployeeModel> <=
public static IEnumerable<T> RetornoList<T>(string procedureName, DynamicParameters param = nul...
When working with ORM it is common (will it be mandatory?) to create the model classes as if they were a mirror of the bank tables. But I have a different case and wanted to know if dapper works this way. In the bank I have the tables. Pro...
I have the following problem when I inner join in 3 in> Dapper does not bring me all the columns of the 3 tables, but only the parent table of my inner join (ie the first table in the query).
My classes
public class ItemQuesti...
I have the following code for creating the table:
string query = @"CREATE TABLE GVP_USERS_TAGS(
ID integer NOT NULL PRIMARY KEY AUTOINCREMENT,
DATEINS datetime NOT NULL DEFAUL...