Covers the Entity Data Model-part of ADO.NET
Covers the Entity Data Model-part of ADO.NET
Questions tagged [ado.net-entity-data-model]
505 questions
0
votes
1 answer
Why we have to delete edmx and recreate it anew on the server, every change we make?
We make some WCF service that uses Entity Framework (edmx file). Every time we make a change (even not related to the framework / DB), we have to delete the edmx and recreate it and build the solution on the server itself, otherwise it cannot…
Tar
- 8,529
- 9
- 56
- 127
0
votes
1 answer
ADO.NET EF - populate DataGridView when we have Foreign Key
I am fairly new to ORMs and ADO.NET EF in particular. I'm using the Code First approach. I have these two tables in my DB :
Material:
public class Material
{
[Required]
[MaxLength(10)]
public string Code { get; set; }
…
Leron
- 9,546
- 35
- 156
- 257
0
votes
1 answer
ADO.NET Entity Framework multiple FK in one table
I'm using a code from a tutorial to try things out that I'll need in my real project. I have a table in my DataBase with a lot (16) Foreign Keys in it I have to recreate the whole DataBase using ADO.NET EF and now I'm little stuck with this…
Leron
- 9,546
- 35
- 156
- 257
0
votes
1 answer
ADO.NET EF how to set FK with Code First
I have these classes that describes my DB model:
public class Blog
{
public int BlogId { get; set; }
public string Name { get; set; }
public string Url { get; set; }
public virtual List Posts { get; set;…
Leron
- 9,546
- 35
- 156
- 257
0
votes
1 answer
ADO.NET EF - can't connect to my DB (using Visual Studio 2010)
So I'm struggling with this problem for more than 4 hours and I don't know where to look at any more. I follow this tutorial for absolute beginners in ADO.NET Entity Framework - [See The tutorial][1] [1]:…
Leron
- 9,546
- 35
- 156
- 257
0
votes
1 answer
Table column make enum and return values as strings
I have an ASP.NET WebForms application with a (EF) database.
Basically the two tables I'm concerned with are Users and Roles.
In Roles there's: Id (pk), UserId (fk), Type : String - which contains either Admin, User, Moderator, Publisher, etc.
In…
Agon Noga
- 563
- 1
- 9
- 17
0
votes
1 answer
Error while Inserting record into table using Entity Data Model and Linq
I am working on Entity Data Model and i hv created a method to insert a record into a table of sql server 2005 DB. before inserting record i m chking whether the User with the same name already exist in the table. This is a Class Library and i am…
Tim
- 231
- 3
- 4
- 13
0
votes
1 answer
Missing auto-generated methods using ADO.NET Entity Data Model
I am trying to learn Entity Framework. In the book that I am using, it guides me to creating a C# class library to house the entity framework model. Inside of this class library, I am instructed to add a new item and generate an ADO.NET Entity Data…
ManilaMocha
- 13
- 3
0
votes
2 answers
ADO.net to Lightswitch issue
I've deploy my database through ADO.net Entity Data Model by executing its diagram output query against my pre-made online database.
My database contains Only Lightswitch supported relations, One-Many, ZeroOne-Many & One-ZeroOne.
Finally, Attaching…
Ahmed Ghoneim
- 6,834
- 9
- 49
- 79
0
votes
1 answer
Data sources not updating with ADO.NET Data Model
So I am creating a dashboard with C#/Silverlight. The dashboard is hooked to a remote database with a data model and a domain service. In my database I created a new view, and have added it to the data model. For some reason, after adding it to the…
jwebster
- 628
- 2
- 10
- 20
0
votes
1 answer
Bare essentials (assemblies) to be referenced for an empty ASP.NET MVC 4 project with EF 4
There's a ton of DLL's and javascript files in the ASP.NET MVC 4 project templates. Add an EDM to that and you've got some more.
Which of these contstitute the bare minimum required by an empty ASP.NET MVC project that requires an Entity Framework 4…
Water Cooler v2
- 32,724
- 54
- 166
- 336
0
votes
3 answers
ADO.NET Entity Data Model: Auto-generated classes
I have a table structure like the following:
Companies Addresses
********* *********
ID ID
AddressID ...
BillingAddressID ...
AddressID and BillingAddressID are foreign keys which are present in the…
James
- 80,725
- 18
- 167
- 237
0
votes
1 answer
Converting comma delimited items to an entity using edmx
Is it possible to convert the column (stored as comma delimited) to be presented in the edmx designer as another entity?
table structure
student
id
name
subjects << this is the comma delimited column (1,2,3,10)
subject
id
name
EDMX…
roggss
- 93
- 1
- 8
0
votes
1 answer
MySQL ADO.NET authentication method not supported
Recently I started a project where it is required to access a MySQL server hosted on hostgator's server from a WCF project. I downloaded and installed MySQL ADO.NET connector and tried to create an entity data model but it says Authentication method…
Ling Xing
- 181
- 2
- 14
0
votes
1 answer
How to get value from stored procedure which returns dynamic table in Asp mvc EDMX
I am using stored procedure in edmx. I am using following SP.
Create getreportDAta(@Reportname varchar(50),@startDate datetime,@enddate datetime)
begin
IF OBJECT_ID('tempdb..#ouputtable ') IS NOT NULL DROP TABLE #ouputtable ;
create…
Pavan Tiwari
- 3,077
- 3
- 31
- 71