Stack Overflow
Stack Overflow

Questions tagged [ado.net-entity-data-model]

Covers the Entity Data Model-part of ADO.NET

Covers the Entity Data Model-part of ADO.NET

505 questions
4
votes
1 answer

Entity Framework 4.0, adding SQL Server view which contains no primary key

I am using Entity Framework 4.0, C# 4.0, .Net 2010 and SQL Server 2008 R2. I have created the following view in my SQL Server database: create view viewGetMember as select distinct row_number() over (order by member.Membership_Number)…
manu
  • 1,807
  • 4
  • 25
  • 32
4
votes
1 answer

Why Oracle does not show as a drop down option in Entity Data Model Wizard but does in Server Explorer?

Oracle does not appear as a Data Source drop down list option. This has been asked here, but the answer there does not solve my problem (and for others as well, as per comments there). What's interesting is that in trying to add a Data Connection…
Veverke
  • 9,208
  • 4
  • 51
  • 95
4
votes
3 answers

How to change data source to PostgreSQL in Entity Data Model wizard in VS2010 Pro

I followed the guide here: https://github.com/npgsql/Npgsql/wiki/Visual-Studio-Design-Time-Support---DDEX-Provider#install-npgsqlddexprovidervsix When I get to the step: Change Data Source, only the SQL Server providers appear in the list. …
Mandar
  • 94
  • 1
  • 7
4
votes
3 answers

Missing ADO.NET data source for sqlite in Visual Studio 2015

I've looked at other older threads on this and none of the answers have helped me. I'm using Visual Studio 2015. I grabbed the latest sqlite 1.0.97.0 and Entity Framework 6.1.3 and the ADO Data source is not listed as a option for the ADO.NET Entity…
Terco
  • 920
  • 3
  • 19
  • 34
4
votes
0 answers

EDM Model from XML

I am making a web service that will use a different EDM model based on the request. To achieve this my aim is to load the model from XML, however my tests show that my serialize method seems to be loosing data (and seems like really smelly code). I…
Mike Norgate
  • 2,393
  • 3
  • 24
  • 45
4
votes
2 answers

Pros and cons for using ADO.Net entity model

HI What are the pros and cons for using ADO.NET entity model as a data layer? And should i use LINQ if i'm going to use this technology? Thanks
LolaRun
  • 5,526
  • 6
  • 33
  • 45
4
votes
3 answers

Convert the results of IQueryable to a string to display in a textbox

Using C#, WPF, .NET 4.5 In my program, I am trying to populate the value of a TextBox from a database. The value is obtained by a LINQ statement. I've tried all different things such as To.String() and Console.WriteLine() etc. If you can figure out…
Joe K
  • 231
  • 7
  • 16
4
votes
6 answers

Should I create a ADO.NET Entity Data Model for each table, or one for my entire database?

Are you supposed to use one ADO.NET Entity Data Model for each table? Or one for your entire database where relationships are also routed, etc...
Matt
  • 5,249
  • 12
  • 40
  • 45
3
votes
4 answers

ASP.NET MVC and ADO.NET Entity Framework

I have a problem that I cannot solve without some advice. I'm developing an ASP.NET MVC application and I'm using ADO.NET EF to connect to the database. My problem is that I don't know if business logic of my app should use entities created by EF or…
TrN
  • 1,230
  • 2
  • 17
  • 32
3
votes
1 answer

What's the difference between property Entity Reference and property in Entity Data Model?

I have three tables structure like following AppUser User App ********* ****** ****** AppUserId UserId AppId UserId AppId UserId and AppId of Table AppUser is…
cat916
  • 1,363
  • 10
  • 18
3
votes
2 answers

How can I Upload my ASP.NET website(with database)?

this is my first project ^_^ and I have no previous experience. I did create the database in my project from within the MVC. Add New Item > SQL Server Database then I use ADO.NET Entity DataModel and I don't need to open my connection each time I…
Evanescence
  • 729
  • 1
  • 10
  • 25
3
votes
1 answer

ADO Entity Framework creating unwanted Entity Key

I need to use tables from a DB which I cannot alter (using linked server). So part of my schema is a view on these table and I cannot create an FK in my DB. When I come to creating the association in ADO.NET Entity Framework I am getting problems…
stan4th
  • 33
  • 1
  • 5
3
votes
1 answer

Stored Procedures in Entity Framework Vs ADO.NET

For one of my project, I am using Entity Framework to connect to a SQL Server database. Due to large volume of data like (1000 - 100000) insert/update/delete, I had to use stored procedures with user-defined table types as parameter to improve the…
Udaya kumar
  • 31
  • 1
  • 3
3
votes
2 answers

Exposing Entities through WCF

I have a WCF that uses a ADO.NET Entity Data Model to access SQL Server. To insert a new row in a table with seven columns I'm using a WCF method. I think send seven parameters it's too much, so I can use a struct or table's entity object. What do…
VansFannel
  • 45,055
  • 107
  • 359
  • 626
3
votes
2 answers

What is a POCO Proxy?

I came across this term while working on ADO.net entity framework (EF 4.0). It's hard for me to understand this term. I am aware of POCO classes and their use in creating PI model but I am not sure about a POCO proxy. Can anyone help on this?
Kunal
  • 1,913
  • 6
  • 29
  • 45
1 2 3
…
33 34