or
| ES00000120S9 |
09/03/2011 0:00:00 |
Mar'11 |
36,9388000000 |
20/02/2012 |
| ES00000120S9 | 09/05/2011 0:00:00 | May'11 | 38,3738000000 | 20/02/2012 |
| ES00000120S9 | 11/07/2011 0:00:00 | Jul'11 | 41,0802000000 | 20/02/2012 |
| ES00000120S9 | 09/09/2011 0:00:00 | Sep'11 | 47,0580000000 | 20/02/2012 |
| ES00000120S9 | 09/11/2011 0:00:00 | Nov'11 | 51,5185000000 | 21/02/2012 |
| ES00000120S9 | 09/01/2012 0:00:00 | Ene'12 | 52,7473000000 | 21/02/2012 |
| ES00000121J6 | 09/03/2011 0:00:00 | Mar'11 | 94,4507000000 | 20/02/2012 |
| ES00000121J6 | 09/05/2011 0:00:00 | May'11 | 94,7643000000 | 20/02/2012 |
| ES00000121J6 | 11/07/2011 0:00:00 | Jul'11 | 95,7689000000 | 20/02/2012 |
| ES00000121J6 | 09/09/2011 0:00:00 | Sep'11 | 97,2266000000 | 20/02/2012 |
| ES00000121J6 | 09/11/2011 0:00:00 | Nov'11 | 97,1023000000 | 21/02/2012 |
| ES00000121J6 | 09/01/2012 0:00:00 | Ene'12 | 97,4383000000 | 21/02/2012 |
| ES00000121T5 | 09/05/2011 0:00:00 | May'11 | 100,0459000000 | 20/02/2012 |
| ES00000121T5 | 11/07/2011 0:00:00 | Jul'11 | 100,4433000000 | 20/02/2012 |
| ES00000121T5 | 09/01/2012 0:00:00 | Ene'12 | 383,3258000000 | 21/02/2012 |
<basicHttpBinding>
<binding name="basicBinding">
<security mode="TransportCredentialOnly">
<transport clientCredentialType="Windows" />
</security>
</binding>
</basicHttpBinding>public partial class MyDataModelEntities { public IEnumerable<SessioinReportData> QuerySessionReport() { var query = from user in this.users from session in this.sessions where user.id.Equals(session.assigned_user_id) select new SessioinReportData { CreatedBy = user.user_name ?? "", SessionType = session.session_type ?? "Unknown", DateEntered = (session.date_entered != null ? session.date_entered.Value.ToString("MM/dd/yyyy") : "n/a"), NumericID = session.numeric_id, Status = session.status }; return query; } } /// <summary> /// This contains data needed for the report /// </summary> public class SessioinReportData { public string CreatedBy { get; set; } public string SessionType { get; set; } public string DateEntered { get; set; } public int NumericID { get; set; } public string Status { get; set; } }namespace MyProject.Web.Model{ using System; using System.Collections.Generic; using System.ComponentModel; using System.ComponentModel.DataAnnotations; using System.Linq; using System.ServiceModel.DomainServices.Hosting; using System.ServiceModel.DomainServices.Server; // The MetadataTypeAttribute identifies sessionMetadata as the class // that carries additional metadata for the session class. [MetadataTypeAttribute(typeof(session.sessionMetadata))] public partial class session { internal sealed class sessionMetadata { // Metadata classes are not meant to be instantiated. private sessionMetadata() { } public Nullable<Guid> assigned_user_id { get; set; } public Nullable<bool> confirm_flag { get; set; } public Nullable<Guid> created_by { get; set; } public Nullable<DateTime> date_end { get; set; } public Nullable<DateTime> date_entered { get; set; } public Nullable<DateTime> date_modified { get; set; } public Nullable<DateTime> date_start { get; set; } public Guid id { get; set; } public Nullable<Guid> modified_user_id { get; set; } public string notes { get; set; } public Nullable<Guid> parent_id { get; set; } public string session_type { get; set; } public string status { get; set; } } }}