using System;

using System.Data;

using System.Data.SqlClient;

public class Program

{

    public static void Main()

    {

        UnsafeExpressions objUE = new UnsafeExpressions();

        Console.WriteLine(!String.IsNullOrEmpty(objUE.GetMyString()) ? "Name Exists!" : "No Name...");

​

    }

}

​

public class UnsafeExpressions

{

    static string ConnString

    {

        get { return "server=A-Real-Server;user=sa;password=A-Real-Password;database=master;Connection Timeout=30"; }

    }

    static string Query

    {

        get { return "SELECT [MyText] = 'Test 1'"; }

    }

    public string GetMyString()

    {

        try

        {

            using (SqlConnection conn = new SqlConnection(ConnString))

            {

                conn.Open();

                using (SqlCommand cmd = new SqlCommand(Query, conn))

                {

                    var result = cmd.ExecuteScalar();

                    if (result != null){

                        return result.ToString();

                    }

                }

            }

        }

        catch (Exception ex)

        {

            Console.WriteLine(ex.Message);

        }

        return string.Empty;

    }

}