blocks|key|5183452|text|我在源代码管理中找到了这个脚本：https://code.google.com/p/elmah/source/browse/src/Elmah.SqlServer/SQLServer.sql|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|5183453|在用于为Elmah创建数据库结构的数据库上运行该脚本。|5183454|entityMap|0|LINK|mutability|MUTABLE|url|https://code.google.com/p/elmah/source/browse/src/Elmah.SqlServer/SQLServer.sql^0|G|27|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

I found the script in source control: <a href="https://code.google.com/p/elmah/source/browse/src/Elmah.SqlServer/SQLServer.sql" rel="noreferrer">https://code.google.com/p/elmah/source/browse/src/Elmah.SqlServer/SQLServer.sql</a>

Run that script on the database you are using to create the database structures for Elmah.

blocks|key|3285893|text|DDL脚本是从Elmah+downloads+page链接的。不需要搜索源码树。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3285894|(我不明白为什么它没有和NuGet捆绑在一起)|3285895|entityMap|0|LINK|mutability|MUTABLE|url|http://elmah.github.io/downloads/^0|D|E|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

The DDL script is linked from the Elmah <a href="http://elmah.github.io/downloads/" rel="nofollow noreferrer">downloads page</a>. No need to trawl the source tree.

(Why it's not bundled with the NuGet escapes me)

blocks|key|3285952|text|对于代码优先迁移场景，我发现this文章非常有用。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3285953|首先在“包管理器控制台”中运行Add-Migration+AddElmah命令。这将在迁移文件夹下创建一个文件。该文件将包含带有函数Up()和Down()的AddElmah类。将这两个函数替换为以下代码：|style|CODE|3285954|public+override+void+Up()
{
++++Sql(@"CREATE+TABLE+[dbo].[ELMAH_Error]
++++++++(
++++++++++++[ErrorId]+++++UNIQUEIDENTIFIER+NOT+NULL,
++++++++++++[Application]+NVARCHAR(60)++COLLATE+SQL_Latin1_General_CP1_CI_AS+NOT+NULL,
++++++++++++[Host]++++++++NVARCHAR(50)++COLLATE+SQL_Latin1_General_CP1_CI_AS+NOT+NULL,
++++++++++++[Type]++++++++NVARCHAR(100)+COLLATE+SQL_Latin1_General_CP1_CI_AS+NOT+NULL,
++++++++++++[Source]++++++NVARCHAR(60)++COLLATE+SQL_Latin1_General_CP1_CI_AS+NOT+NULL,
++++++++++++[Message]+++++NVARCHAR(500)+COLLATE+SQL_Latin1_General_CP1_CI_AS+NOT+NULL,
++++++++++++[User]++++++++NVARCHAR(50)++COLLATE+SQL_Latin1_General_CP1_CI_AS+NOT+NULL,
++++++++++++[StatusCode]++INT+NOT+NULL,
++++++++++++[TimeUtc]+++++DATETIME+NOT+NULL,
++++++++++++[Sequence]++++INT+IDENTITY(1,+1)+NOT+NULL,
++++++++++++[AllXml]++++++NTEXT+COLLATE+SQL_Latin1_General_CP1_CI_AS+NOT+NULL
++++++++)+");

++++Sql("EXEC('ALTER+TABLE+[dbo].[ELMAH_Error]+WITH+NOCHECK+ADD+CONSTRAINT[PK_ELMAH_Error]+PRIMARY+KEY([ErrorId])')");

++++Sql("EXEC('ALTER+TABLE+[dbo].[ELMAH_Error]+ADD+CONSTRAINT[DF_ELMAH_Error_ErrorId]+DEFAULT(NEWID())+FOR[ErrorId]')");

++++Sql(@"EXEC('CREATE+NONCLUSTERED+INDEX+[IX_ELMAH_Error_App_Time_Seq]+ON+[dbo].[ELMAH_Error]+
++++++++(
++++++++++++[Application]+++ASC,
++++++++++++[TimeUtc]+++++++DESC,
++++++++++++[Sequence]++++++DESC
++++++++)')");

++++Sql(@"EXEC('CREATE+PROCEDURE+[dbo].[ELMAH_GetErrorXml]+(@Application+NVARCHAR(60),+@ErrorId+UNIQUEIDENTIFIER)+AS
++++++++++++SET+NOCOUNT+ON
++++++++++++SELECT+[AllXml]+FROM+[ELMAH_Error]+WHERE+[ErrorId]+=+@ErrorId+AND+[Application]+=+@Application')");

++++Sql(@"EXEC('CREATE+PROCEDURE+[dbo].[ELMAH_GetErrorsXml]
++++++++(@Application+NVARCHAR(60),+@PageIndex+INT+=+0,+@PageSize+INT+=+15,+@TotalCount+INT+OUTPUT)
++++++++AS++
++++++++++++SET+NOCOUNT+ON+
++++++++++++DECLARE+@FirstTimeUTC+DATETIME
++++++++++++DECLARE+@FirstSequence+INT
++++++++++++DECLARE+@StartRow+INT
++++++++++++DECLARE+@StartRowIndex+INT

++++++++++++SELECT+@TotalCount+=+COUNT(1)+FROM+[ELMAH_Error]+WHERE+[Application]+=+@Application

++++++++++++SET+@StartRowIndex+=+@PageIndex+*+@PageSize+%2B+1

++++++++++++IF+@StartRowIndex+<=+@TotalCount
++++++++++++BEGIN+
++++++++++++++++SET+ROWCOUNT+@StartRowIndex

++++++++++++++++SELECT+@FirstTimeUTC+=+[TimeUtc],+@FirstSequence+=+[Sequence]+FROM+[ELMAH_Error]
++++++++++++++++WHERE+[Application]+=+@Application+ORDER+BY+[TimeUtc]+DESC,+[Sequence]+DESC+
++++++++++++END
++++++++++++ELSE
++++++++++++BEGIN+
++++++++++++++++SET+@PageSize+=+0+
++++++++++++END

++++++++++++SET+ROWCOUNT+@PageSize

++++++++++++SELECT+
++++++++++++++++errorId+++++=+[ErrorId],+
++++++++++++++++application+=+[Application],
++++++++++++++++host++++++++=+[Host],+
++++++++++++++++type++++++++=+[Type],
++++++++++++++++source++++++=+[Source],
++++++++++++++++message+++++=+[Message],
++++++++++++++++[user]++++++=+[User],
++++++++++++++++statusCode++=+[StatusCode],+
++++++++++++++++time++++++++=+CONVERT(VARCHAR(50),+[TimeUtc],+126)+%2B+''Z''
++++++++++++FROM+[ELMAH_Error]+error+WHERE+[Application]+=+@Application+AND+[TimeUtc]+<=+@FirstTimeUTC
++++++++++++AND+[Sequence]+<=+@FirstSequence+ORDER+BY+[TimeUtc]+DESC,+[Sequence]+DESC+FOR+XML+AUTO')");

++++Sql(@"EXEC('CREATE+PROCEDURE+[dbo].[ELMAH_LogError]+(@ErrorId+UNIQUEIDENTIFIER,+@Application+NVARCHAR(60),+@Host+NVARCHAR(30),
++++++++++@Type+NVARCHAR(100),+@Source+NVARCHAR(60),+@Message+NVARCHAR(500),+@User+NVARCHAR(50),+@AllXml+NTEXT,+@StatusCode+INT,
++++++++++@TimeUtc+DATETIME)+AS+

+++++++++SET+NOCOUNT+ON

+++++++++INSERT+INTO+[ELMAH_Error]+([ErrorId],+[Application],+[Host],+[Type],+[Source],+[Message],+[User],+[AllXml],+[StatusCode],+[TimeUtc])
+++++++++VALUES+(@ErrorId,+@Application,+@Host,+@Type,+@Source,+@Message,+@User,+@AllXml,+@StatusCode,+@TimeUtc)')");
}

public+override+void+Down()
{
++++Sql("EXEC('DROP+PROCEDURE+[ELMAH_GetErrorXml]')");
++++Sql("EXEC('DROP+PROCEDURE+[ELMAH_GetErrorsXml]')");
++++Sql("EXEC('DROP+PROCEDURE+[ELMAH_LogError]')");
++++Sql("Drop+table+ELMAH_Error");
}|code-block|syntax|javascript|3285955|现在，当您在“包管理器控制台”中执行Update-Database命令时，将在数据库中创建ELMAH_Error表和相关过程。|3285956|entityMap|0|LINK|mutability|MUTABLE|url|http://www.eonasdan.com/home/elmah-code-first-migration^0|E|4|0|0|F|M|1U|4|1Z|6|26|8|0|0|I|F|19|B|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|6|7|10|8|@$A|11|B|12|F|G]|$A|13|B|14|F|G]|$A|15|B|16|F|G]|$A|17|B|18|F|G]]|9|@]|C|$]]|$1|H|3|I|5|J|7|19|8|@]|9|@]|C|$K|L]]|$1|M|3|N|5|6|7|1A|8|@$A|1B|B|1C|F|G]|$A|1D|B|1E|F|G]]|9|@]|C|$]]|$1|O|3|-4|5|6|7|1F|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]]]

For a code first migration scenario, I found the <a href="http://www.eonasdan.com/home/elmah-code-first-migration" rel="nofollow noreferrer">this</a> article very helpful.

First run <code>Add-Migration AddElmah</code> command in 'Package Manager Console'. This will create a file under Migration folder. This file will contain <code>AddElmah</code> class with to functions <code>Up()</code> and <code>Down()</code>. Replaced these two functions with below code:

<pre><code>public override void Up()
{
 Sql(@"CREATE TABLE [dbo].[ELMAH_Error]
 (
 [ErrorId] UNIQUEIDENTIFIER NOT NULL,
 [Application] NVARCHAR(60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [Host] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [Type] NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [Source] NVARCHAR(60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [Message] NVARCHAR(500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [User] NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [StatusCode] INT NOT NULL,
 [TimeUtc] DATETIME NOT NULL,
 [Sequence] INT IDENTITY(1, 1) NOT NULL,
 [AllXml] NTEXT COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
 ) ");

 Sql("EXEC('ALTER TABLE [dbo].[ELMAH_Error] WITH NOCHECK ADD CONSTRAINT[PK_ELMAH_Error] PRIMARY KEY([ErrorId])')");

 Sql("EXEC('ALTER TABLE [dbo].[ELMAH_Error] ADD CONSTRAINT[DF_ELMAH_Error_ErrorId] DEFAULT(NEWID()) FOR[ErrorId]')");

 Sql(@"EXEC('CREATE NONCLUSTERED INDEX [IX_ELMAH_Error_App_Time_Seq] ON [dbo].[ELMAH_Error] 
 (
 [Application] ASC,
 [TimeUtc] DESC,
 [Sequence] DESC
 )')");

 Sql(@"EXEC('CREATE PROCEDURE [dbo].[ELMAH_GetErrorXml] (@Application NVARCHAR(60), @ErrorId UNIQUEIDENTIFIER) AS
 SET NOCOUNT ON
 SELECT [AllXml] FROM [ELMAH_Error] WHERE [ErrorId] = @ErrorId AND [Application] = @Application')");

 Sql(@"EXEC('CREATE PROCEDURE [dbo].[ELMAH_GetErrorsXml]
 (@Application NVARCHAR(60), @PageIndex INT = 0, @PageSize INT = 15, @TotalCount INT OUTPUT)
 AS 
 SET NOCOUNT ON 
 DECLARE @FirstTimeUTC DATETIME
 DECLARE @FirstSequence INT
 DECLARE @StartRow INT
 DECLARE @StartRowIndex INT

 SELECT @TotalCount = COUNT(1) FROM [ELMAH_Error] WHERE [Application] = @Application

 SET @StartRowIndex = @PageIndex * @PageSize + 1

 IF @StartRowIndex &lt;= @TotalCount
 BEGIN 
 SET ROWCOUNT @StartRowIndex

 SELECT @FirstTimeUTC = [TimeUtc], @FirstSequence = [Sequence] FROM [ELMAH_Error]
 WHERE [Application] = @Application ORDER BY [TimeUtc] DESC, [Sequence] DESC 
 END
 ELSE
 BEGIN 
 SET @PageSize = 0 
 END

 SET ROWCOUNT @PageSize

 SELECT 
 errorId = [ErrorId], 
 application = [Application],
 host = [Host], 
 type = [Type],
 source = [Source],
 message = [Message],
 [user] = [User],
 statusCode = [StatusCode], 
 time = CONVERT(VARCHAR(50), [TimeUtc], 126) + ''Z''
 FROM [ELMAH_Error] error WHERE [Application] = @Application AND [TimeUtc] &lt;= @FirstTimeUTC
 AND [Sequence] &lt;= @FirstSequence ORDER BY [TimeUtc] DESC, [Sequence] DESC FOR XML AUTO')");

 Sql(@"EXEC('CREATE PROCEDURE [dbo].[ELMAH_LogError] (@ErrorId UNIQUEIDENTIFIER, @Application NVARCHAR(60), @Host NVARCHAR(30),
 @Type NVARCHAR(100), @Source NVARCHAR(60), @Message NVARCHAR(500), @User NVARCHAR(50), @AllXml NTEXT, @StatusCode INT,
 @TimeUtc DATETIME) AS 

 SET NOCOUNT ON

 INSERT INTO [ELMAH_Error] ([ErrorId], [Application], [Host], [Type], [Source], [Message], [User], [AllXml], [StatusCode], [TimeUtc])
 VALUES (@ErrorId, @Application, @Host, @Type, @Source, @Message, @User, @AllXml, @StatusCode, @TimeUtc)')");
}

public override void Down()
{
 Sql("EXEC('DROP PROCEDURE [ELMAH_GetErrorXml]')");
 Sql("EXEC('DROP PROCEDURE [ELMAH_GetErrorsXml]')");
 Sql("EXEC('DROP PROCEDURE [ELMAH_LogError]')");
 Sql("Drop table ELMAH_Error");
}
</code></pre>

Now when you will execute <code>Update-Database</code> command in "Package Manager Console", <code>ELMAH_Error</code> table and associated procedures will be created in the database.

blocks|key|4899680|text|Elmah源已移至GitHub。SQL+Server的当前文件位于Elmah组织下的SqlErrorLog存储库中。SqlErrorLog:+/src/SQLServer.sql|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4899681|其他数据库脚本可以通过搜索Elmah+GitHub组织下的errorlog找到。例如https://github.com/elmah?q=errorlog|style|CODE|4899682|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/elmah/SqlErrorLog/blob/master/src/SQLServer.sql|1|https://github.com/elmah?q=errorlog^0|1M|V|0|0|T|8|16|Z|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@$A|W|B|X|F|G]]|9|@$A|Y|B|Z|1|10]]|C|$]]|$1|H|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]]]

Elmah source has been moved to GitHub. The current file for SQL Server is located in the SqlErrorLog repo under the Elmah organization.
<a href="https://github.com/elmah/SqlErrorLog/blob/master/src/SQLServer.sql" rel="nofollow noreferrer">SqlErrorLog: /src/SQLServer.sql</a>
Other database scripts can be found by searching <code>errorlog</code> under the Elmah GitHub organization. e.g. <a href="https://github.com/elmah?q=errorlog" rel="nofollow noreferrer">https://github.com/elmah?q=errorlog</a>

How do I create the ELMAH SQL Server database? I added it to my ASP.NET MVC project through NuGet and don't have the sql script on my machine.

How do I create the ELMAH SQL Server database?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

如何创建ELMAH SQL Server数据库？我通过NuGet将其添加到我的sql项目中，并且我的机器上没有ASP.NET脚本。

问如何创建ELMAH SQL Server数据库？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何创建ELMAH SQL Server数据库？EN