Needed references:
- System.ServiceModel
< controls:ChildWindow.DataContext>
< ViewModel:LogonViewModel />
< /controls:ChildWindow.DataContext>
using (var dataContext = new OurEntities())
{
var statusList = from status in dataContext.Status
select status;
foreach (var status in statusList)
{
Console.WriteLine(status.Name + " - " + status.Description);
}
}
By the way, do not forget to add the connection string to your web.config or app.config:
<connectionStrings>
<add name="OurEntities"
connectionString="metadata=res://*/OurEntityModel.csdl|res://*/OurEntityModel.ssdl|res://*/OurEntityModel.msl;provider=System.Data.SQLite;provider connection string='data source=".\Database\OurDatabase.db"'"
providerName="System.Data.EntityClient"
connectionStrings>;
Notes: If you are using the version 4 of the framework you must add the following line to your web.config or app.config:
<startup useLegacyV2RuntimeActivationPolicy="true">;
<supportedRuntime version="v4.0" startup;