将SQL Server的多个表映射到Class [英] Map multiple table of sql server to Class

问题描述

大家好，

我在sql server中创建了一个存储过程，该存储过程从多个表返回多个select语句.现在，我需要将这些多个表的记录映射到单个类.即我有两个表用户，地址.现在，我有一个存储过程正在返回那些表的数据

选择*来自用户
选择*从地址

现在，我需要将这两个表的记录绑定到单个类.我不想使用数据表.有人让我知道如何实现吗?

Hi All,

I have created a stored procedure in sql server which is returning multiple select statements from multiple table. Now I need to map those multiple table''s record to a single class. i.e. I have two tables User, Address. Now I have a stored procedure which is returning those table''s data

SELECT * FROM USERS
SELECT * FROM ADDRESS

Now I need to bind these two table''s record to a Single Class. I do not want to use Datatable. Anyone let me know how to achieve this?

推荐答案

我要设置的方式是先创建一个Address类，然后再创建一个User类，该类具有一个返回一个地址，类似这样

The way I would set this up would be to have an Address class, then a User class that has a property that returns an Address, something like this

class Address
    {
        public string Street { get; set; }
        public string Suburb { get; set; }
        public string City { get; set; }
    }

    class User
    {
        public string FirstName { get; set; }
        public string LastName{get;set}
        public int Age{get;set;}
        public Address CurrentAddress{get;set;}
    }

然后，您可以从一个DataReader中填充这两个类.

希望这对您有帮助

Then you can populate both classes from one DataReader.

Hope this helps

您好，谢谢您的回复.但是我没有使用datareader.我已将存储过程与Linq映射，该Linq返回记录列表.

Hi, Thanks for your repaly..but I am not using datareader. I have mapped the stored procedure with the Linq, which return the List of records.

这篇关于将SQL Server的多个表映射到Class的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！