I want to pull
data from table "Province_Notifiers" and also fetch all corresponding items from table "Province_Notifier_Datas". The table "Province_Notifier" has a guid to identify it (PK), table "Province_Notifier_Datas" has a column called BelongsToProvinceID witch is a foreign key to the "Province_Notifier" tables guid.
I tried something like this:
var records = from
data in ctx.Province_Notifiers
where DateTime.Now >=
data.SendTime &&
data.Sent == false
join data2 in ctx.Province_Notifier_Datas on
data.Province_ID equals data2.BelongsToProvince_ID
select new Province_Notifier
{
Email =
data.Email,
Province_ID =
data.Province_ID,
ProvinceName =
data.ProvinceName,
Sent =
data.Sent,
UserName =
data.UserName,
User_ID =
data.User_ID,
Province_Notifier_Datas = (new List<Province_Notifier_Data>().AddRange(data2))
};
This line is not working and i am trying to figure out how topull the
data from table2 into that Province_Notifier_Datas variable.
Province_Notifier_Datas = (new List<Province_Notifier_Data>().AddRange(data2))
I can add a record easily by adding the second table row into the Province_Notifier_Datas but i can't fetch it back.
Province_Notifier dbNotifier = new Province_Notifier();
// set some values for dbNotifier
dbNotifier.Province_Notifier_Datas.Add(
new Province_Notifier_Data
{
BelongsToProvince_ID = userInput.Value.ProvinceId,
EventText = GenerateNotificationDetail(notifierDetail)
});
This works and inserts the
data correctly into both tables.
Edit:
These error messages is thrown:
Cannot convert from 'Province_Notifier_Data' to 'System.Collections.Generic.IEnumerable'
If i look in Visual Studio, the variable "Province_Notifier_Datas" is of type System.
Data.Linq.EntitySet
The best overloaded method match for 'System.Collections.Generic.List.AddRange(System.Collections.Generic.IEnumerable)' has some invalid arguments
Edit:
var records = from
data in ctx.Province_Notifiers
where DateTime.Now >=
data.SendTime &&
data.Sent == false
join data2 in ctx.Province_Notifier_Datas on
data.Province_ID equals data2.BelongsToProvince_ID
into data2list
select new Province_Notifier
{
Email =
data.Email,
Province_ID =
data.Province_ID,
ProvinceName =
data.ProvinceName,
Sent =
data.Sent,
UserName =
data.UserName,
User_ID =
data.User_ID,
Province_Notifier_Datas = new EntitySet<Province_Notifier_Data>().AddRange(data2List)
};
Error 3 The name 'data2List' does not exist in the current context.
