 <p>Use <code>SqlFunctions.DatePart</code> static method. It will be transformed into <code>DATEPART</code> SQL function call in generated SQL query:</p> <blockquote> <p><a href="http://msdn.microsoft.com/en-us/library/dd487171%28v=vs.110%29.aspx" rel="nofollow"><strong><code>SqlFunctions.DatePart</code> Method</strong></a></p> <p>Returns an integer that represents the specified datepart of the specified date.</p> <p>This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see DATEPART (Transact-SQL).</p> </blockquote> <p>To get week number, use <code>"week"</code> as parameter.</p>