Friday, March 4, 2016

How to get schema from stored procedure sql server

ADO.NET

DataTable schema = reader.GetSchemaTable();

SQL


SELECT * FROM sys.dm_exec_describe_first_result_set ('qualified.storedprocname', @params, 0) ;

How to submit / save changes in LinqPad

void Main()
{
    var students = Student.Select(st => st);
    foreach (var student in students)
    {
        student.FatherName = "Father";
    }
    SubmitChanges();
}