content reader from database

Question

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
DataDBDataContext mdc = new DataDBDataContext();
var Movies = from m in mdc.Movies
where m.MoviesCategory == 1
select m;
foreach (Movies item in Movies)
{
Console.WriteLine(item.MoviesName + " : " + item.MoviesCategory);
}
Console.ReadKey();

}
}
}

 

 

 

 

 

this codr is not working but allthough it is correct