TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
kavya bathineni
NA
39
4.3k
How to Navigate 3 tables in EntityFrame work WPF
Dec 1 2016 3:34 AM
I am New to WPF. I has a Country class generated from database using Entity frame work. When I press pageup or pageDown keys navigate to Country class to display Country id and name next elements first to last elements. When i run the code i got Exception please tell me How to navigate 3 tables
My database class:
namespace LWLLC.Persistence
{
using System;
using System.Collections.Generic;
public partial class Country
{
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
public Country()
{
this.PurchaseOrderLineItems = new HashSet<PurchaseOrderLineItem>();
this.States = new HashSet<State>();
}
public int CountryID { get; set; }
public string Country_Name { get; set; }
public string Country_Code { get; set; }
public Nullable<System.DateTime> CreatedDate { get; set; }
public Nullable<int> CreatedBy { get; set; }
public Nullable<System.DateTime> LastUpdatedDate { get; set; }
public Nullable<int> LastUpdatedBy { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection<PurchaseOrderLineItem> PurchaseOrderLineItems { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection<State> States { get; set; }
}
}
navigate Businesslogic class is:
public Country NavigateCoutryCodebyID(int countryCodeID, NavigationType nav)
{
//.Include("State").Include("PurchaseOrderLineItem")
Country countryCode = null;
try
{
using (LWLLCDBEntities dbEntities = new LWLLCDBEntities())
{
//current item
switch (nav)
{
case NavigationType.First:
countryCode = dbEntities.Countries.FirstOrDefault();
break;
case NavigationType.Last:
countryCode = dbEntities.Countries.OrderByDescending(t => t.CountryID).FirstOrDefault();
break;
case NavigationType.Current:
countryCode = dbEntities.Countries.Where(i => i.CountryID == countryCodeID).FirstOrDefault();
break;
case NavigationType.Next:
countryCode = dbEntities.Countries.Where(i => i.CountryID > countryCodeID).FirstOrDefault();
if (countryCode == null)
countryCode = dbEntities.Countries.FirstOrDefault();
break;
case NavigationType.Prev:
countryCode = dbEntities.Countries.Where(i => i.CountryID < countryCodeID).FirstOrDefault();
if (countryCode == null)
countryCode = dbEntities.Countries.OrderByDescending(t => t.CountryID).FirstOrDefault();
break;
}
}
}
catch (Exception ex)
{
if (log.IsErrorEnabled)
{
log.Error("BusinessLogic.NavigateCountryCodebyID in Business Logic threw exception: ", ex);
}
}
return countryCode;
}
Reply
Answers (
0
)
Sample project source for wpf & wcf using linq & Ef in C#
how to deploy windows form application c# ?