如何在ASP.NET MVC中添加存储的prouder迁移？ [英] How I can add stored prouder in migration in ASP.NET MVC?

问题描述

大家好，



我想在2个表格中使用Crete报表查看器在我的asp.net mvc应用程序中有关系，我先使用Entity Framework Code，所以我使用迁移创建我的数据库。



我尝试过：



这是我存储的prouder：

Hello everyone,

I want to Crete report viewer with 2 tables has relationship in my application in asp.net mvc , I am using Entity Framework Code first , so i create my database using migration .

What I have tried:

This is my stored prouder:

CREATE PROCEDURE [dbo].[ReportExpenseDetails]
	
AS
	SELECT 

	e.Expenses_Id as ExpenseNo,
	e.Expenses_Type,
	

   ed.ExpenseDetails_Id,
    ed.ExpensesId,
	ed.Amount,
	ed.DateExpense,
	ed.Note
	
	    from Expenses as e inner join ExpenseDetails as ed on e.Expenses_Id=ed.ExpensesId

RETURN 0

这是我的ExpenseDetails型号：

This is my ExpenseDetails models :

public class ExpenseDetails
{
    [Key]
    public int ExpenseDetails_Id { get; set; }

    public double Amount { get; set; }

    [DisplayFormat(DataFormatString = "{0:MM/dd/yyyy}")]
    public DateTime DateExpense { get; set; }

    public string Note { get; set; }

    public int ExpensesId { get; set; }

    [ForeignKey("ExpensesId")]
    public virtual Expenses expenses { get; set; }
}

这是费用型号：

This is Expenses Model:

public class Expenses
{
    [Key]
    public int Expenses_Id { get; set; }

    public string Expenses_Type { get; set; }
}

推荐答案

使用DbContext API中的SqlQuery输出参数的存储过程 - Diego Vega [ ^ ]

这篇关于如何在ASP.NET MVC中添加存储的prouder迁移？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！