SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_sys_md_csharp_generate_constants_strings] 
AS
BEGIN
	SET NOCOUNT ON;
	
	declare @tbl IdTextTableType --TABLE(const varchar(2000))
	
	print 'using System;'
	print 'using System.Collections.Generic;'
	print 'using System.Data;'
	
	
	print 'namespace Ais.Data'
	
	print '{'
    print Char(9) + '/// <summary>'
    print Char(9) + '/// constantes pour les strings - table md_strings. utiliser exec [dbo].[p_sys_md_csharp_generate_constants_strings]  pour les générer'
    print Char(9) + '/// </summary>'
	print Char(9) + 'public partial class STRC'
	print Char(9) + '{'

	
	insert into @tbl (txt)
	select Char(9) + char(9) + 'public const string ' + upper(str_string_name) + ' ="' + str_string_name + '";'
	from md_strings

	-- print tables, fields, etc - constants
	exec p_sys_md_csharp_print_idtexttable @tbl = @tbl, @add_comma_after = 0
	
	print Char(9) + '}'
	print '}' + char(13) + char(10)
	
	
	
	
END










GO
