C# XML documentation of Linq to SQL

Question

How to document the classes & properties & functions that are generated automatically using LINQ to SQL DBML?

I managed to provide documentation to the datacontext class by defining the same partial class in another file with <summary> so it won't be removed if the DBML got refreshed

/// <summary>  
/// Linq to SQL datacontext  
/// </summary>  
public partial class LinqDBDataContext {  

}

This would work for table mapping class with one downside is having to manually maintain the separate class for added/removed tables.

another thing..I have comments-like-documentation(author, date and description) in the stored procedure, shouldn't be also extracted into the code file as the function's documentation?

-- =============================================
-- Author:      <Katia Aleid>
-- Create date: <2015-04-01>
-- Description: <Performs search for the users>
-- =============================================
ALTER PROCEDURE [dbo].[SearchUsers] ....

is it acceptable to exclude the DBML form C# documentation and have separate database documentation instead?

Marc Gravell · Accepted Answer · 2015-04-14 10:08:35Z

1

Comments inside a stored procedure are unlikely to be parseable by SqlMetal; at a push, it could access the MS_Description extended metadata, if you've assigned some - however, I would not expect it to do that. Looking inside the dbml metadata, there isn't anywhere obvious to store or edit additional comments, so frankly I suspect the answer here is: you don't. You shouldn't edit the *.designer.cs, because that can be regenerated at random.

answered Apr 14, 2015 at 10:08

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Katia Over a year ago

Thanks for your answer. I didn't mean that the comment were inside the procedure but before it. just like the template provided by SQL server when you request a new procedure. and as for the designer, I know I shouldn't edit it, that's why I add another file to extent the partial class.

Marc Gravell Over a year ago

@katia those comments are not obtainable by inspection - they are for the benefit of the file, not the SQL Server. Comments inside the stored procedure may be available via sp_helptext etc, but that doesn't make them consumable

Collectives™ on Stack Overflow

C# XML documentation of Linq to SQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related