我应该在EF 4.1 + LINQ中使用DDD聚合根存储库吗？
|
我已经读过DDD Evans，并且尝试使用C＃和Entity Framework 4.1 + LINQ进行汇总根存储库设计。
但是，我担心发送到数据库的实际查询。我正在使用SQL 2008 R2，并运行SQL Profiler来检查数据库响应LINQ代码正在做什么。
考虑一个使用Person和EmailAddress的简单2实体设计。一个人可以有零到多个电子邮件地址，并且一个电子邮件地址必须恰好有一个人。 Person是聚合根，因此不应有电子邮件地址的存储库。电子邮件地址应从“个人”存储库中选择（根据DDD Evans）。
为了进行比较，我确实为电子邮件地址设置了一个临时存储库。下面的代码行：
var emailString = \"someone@somewhere.com\";
var emailEntity = _tempEmailRepository.All.SingleOrDefault(e =>
e.Value.Equals(emailString, StringComparison.OrdinalIgnoreCase));
SELECT
[Extent1].[Id] AS [Id],
[Extent1].[PersonId] AS [PersonId],
[Extent1].[Value] AS [Value],
[Extent1].[IsDefault] AS [IsDefault],
[Extent1].[IsConfirmed] AS [IsConfirmed],
FROM [dbo].[EmailAddress] AS [Extent1]
var emailEntity = _personRepository.All.SelectMany(p => p.Emails)
.SingleOrDefault(e => e.Value.Equals(emailString,
StringComparison.OrdinalIgnoreCase))
SELECT
[Extent1].[Id] AS [Id],
[Extent1].[FirstName] AS [FirstName],
[Extent1].[LastName] AS [LastName],
FROM [dbo].[Person] AS [Extent1]
exec sp_executesql N\'SELECT
[Extent1].[Id] AS [Id],
[Extent1].[PersonId] AS [PersonId],
[Extent1].[Value] AS [Value],
[Extent1].[IsDefault] AS [IsDefault],
[Extent1].[IsConfirmed] AS [IsConfirmed],
FROM [dbo].[EmailAddress] AS [Extent1]
WHERE [Extent1].[PersonId] =
@EntityKeyValue1\',N\'@EntityKeyValue1 int\',@EntityKeyValue1=1
exec sp_executesql N\'SELECT
[Extent1].[Id] AS [Id],
[Extent1].[PersonId] AS [PersonId],
[Extent1].[Value] AS [Value],
[Extent1].[IsDefault] AS [IsDefault],
[Extent1].[IsConfirmed] AS [IsConfirmed],
FROM [dbo].[EmailAddress] AS [Extent1]
WHERE [Extent1].[PersonId] =
@EntityKeyValue1\',N\'@EntityKeyValue1 int\',@EntityKeyValue1=2
IEnumerable<TEntity>
IQueryable<TEntity>
没有找到相关结果
已邀请:
1 个回复
郸身