public static async Task <Models.ModelCatalog> FindOrCreateModelCatalogAsync ( this CarContext carContext, string makeName, string modelName) { var query = @"EXECUTE [dbo].[FindOrCreateModelCatalog] @MakeName ,@ModelName ,@Id OUTPUT"; var parMakeName = CarContextExtentions.CreateParNVarchar("@MakeName", makeName, 255); var parModelName = CarContextExtentions.CreateParNVarchar("@ModelName", modelName, 255); var parId = CarContextExtentions.ParIdOutput(); carContext.Database.ExecuteSqlRaw( query, parMakeName, parModelName, parId); var model = new Models.ModelCatalog { Id = (Guid)parId.Value, Name = modelName }; return(model); }
public static Models.MakeCatalog FindOrCreateMakeCatalogAsync(this CarContext carContext, string name) { var query = @"EXECUTE [dbo].[FindOrCreateMakeCatalog] @Name ,@Id OUTPUT"; var parName = CarContextExtentions.ParNameInput(name); var parId = CarContextExtentions.ParIdOutput(); carContext.Database.ExecuteSqlRaw( query, parName, parId); var mark = new Models.MakeCatalog { Id = (Guid)parId.Value, Name = name }; return(mark); }