Ciugk

Clash Royale CLAN TAG #URR8PPP “The given key was not present in the dictionary”, create data model mysql visual studio 2017 I have hours looking for how to solve the error and I can not find it, and uninstall and install mysql several times and I can not solve it, thanks for your help visual studio 2017 comunity mysql 8.0.12 (installed with mysql installer) conector net 8.0.12 (installed with mysql installer) mysql.data.entity 6.10.7 (installed with nuget) mysql.data 6.9.12 (installed with nuget) NET framework 4.5 the test conection is success I only have one table, is this CREATE DATABASE IF NOT EXISTS mydb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE mydb; CREATE TABLE negocios ( idNegocio int(11) NOT NULL, nombre varchar(45) DEFAULT NULL, calle varchar(45) DEFAULT NULL, activo int(11) DEFAULT NULL, colonia varchar(45) DEFAULT NULL, municipio varchar(45) DEFAULT NULL, numero int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE DATABASE IF NOT EXISTS mydb ...

Clash Royale CLAN TAG #URR8PPP How to call Stored Procedure in Entity Framework 6 (Code-First)? I am very new to Entity Framework 6 and I want to implement stored procedures in my project. I have a stored procedure as follows: ALTER PROCEDURE [dbo].[insert_department] @Name [varchar](100) AS BEGIN INSERT [dbo].[Departments]([Name]) VALUES (@Name) DECLARE @DeptId int SELECT @DeptId = [DeptId] FROM [dbo].[Departments] WHERE @@ROWCOUNT > 0 AND [DeptId] = SCOPE_IDENTITY() SELECT t0.[DeptId] FROM [dbo].[Departments] AS t0 WHERE @@ROWCOUNT > 0 AND t0.[DeptId] = @DeptId END Department class: Department public class Department { public int DepartmentId { get; set; } public string Name { get; set; } } modelBuilder .Entity<Department>() .MapToStoredProcedures(s => s.Update(u => u.HasName("modify_department") .Parameter(b => b.Department, "department_id") .Parameter(b =...