public FileModel GetFile(int id)
{
SqlConnection conn = GetConnection();
FileModel result = null;
try
{
SqlCommand cmd = new SqlCommand(
@"SELECT name,
path,
contentType,
content
FROM " + TableName + @"
WHERE id = @id;", conn);
//content_coding, DATALENGTH(content) as content_length,
cmd.Parameters.Add("@id", SqlDbType.Int);
cmd.Parameters["@id"].Value = id;
SqlDataReader reader = cmd.ExecuteReader(
CommandBehavior.SequentialAccess |
CommandBehavior.SingleResult |
CommandBehavior.SingleRow |
CommandBehavior.CloseConnection);
if (false == reader.Read())
{
reader.Dispose();
conn = null;
return(null);
}
string name = reader["name"].ToString();
string path = reader["path"].ToString();
string contentType = reader["ContentType"].ToString();
System.IO.Stream contentStream = new SqlReaderStream(reader, 3);
result = new FileModel
{
Name = name,
Path = path,
ContentType = contentType,
OutputStream = contentStream,
};
conn = null; // ownership transfered to the reader/stream
return(result);
}
finally
{
if (null != conn)
{
conn.Dispose();
}
}
}
public FileModel GetFile(int id)
{
SqlConnection conn = GetConnection();
FileModel result = null;
try
{
SqlCommand cmd = new SqlCommand(
@"SELECT name,
path,
contentType,
content
FROM "+TableName+@"
WHERE id = @id;", conn);
//content_coding, DATALENGTH(content) as content_length,
cmd.Parameters.Add("@id", SqlDbType.Int);
cmd.Parameters["@id"].Value = id;
SqlDataReader reader = cmd.ExecuteReader(
CommandBehavior.SequentialAccess |
CommandBehavior.SingleResult |
CommandBehavior.SingleRow |
CommandBehavior.CloseConnection);
if (false == reader.Read())
{
reader.Dispose();
conn = null;
return null;
}
string name = reader["name"].ToString();
string path = reader["path"].ToString();
string contentType = reader["ContentType"].ToString();
System.IO.Stream contentStream = new SqlReaderStream(reader, 3);
result = new FileModel
{
Name = name,
Path = path,
ContentType = contentType,
OutputStream = contentStream,
};
conn = null; // ownership transfered to the reader/stream
return result;
}
finally
{
if (null != conn)
{
conn.Dispose();
}
}
}