Skip to content
Advertisement

How to store code/programs written in any programming language in SQL Server

I have to display some C# code on a page of my web application (ASP.NET MVC application). How can i store C# code (program) in SQL Server ? Consider that i have the following code:

public class Program
{
    public static void Main(string[] args)
    {
        Console.WriteLine("Hello, world!");
    }
}

How can i store this code in SQL Server, so that when my application reads the code from the database, the code can be displayed as it is on the page.

Advertisement

Answer

Here is a simple SQL Server script demonstrating the concept of storing multi-line string data (such as a code snippet) in a database table:

create table CodeExamples(Id int identity(1,1), Code varchar(max));

insert into CodeExamples(Code) select 'public class Program
{
    public static void Main(string[] args)
    {
        Console.WriteLine("Hello, world!");
    }
}';

select * from CodeExamples;
User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement