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
1
vote
1 answer
Database Modeling:Find how the data looks like in the give date and time
if i have table1, table2, table3..table50 that stores different information about a product
what would be the efficient way to keeping track of incremental changes in a way that if i want to go back and pull how that particular product looked in a…
Natasha Thapa
- 979
- 4
- 20
- 41
1
vote
1 answer
Create one-way association/mapping in Entity Data Model?
Okay, as usual, I'm brand new to this... been researching and trial/erroring (yes that's a verb) for a couple hours with no luck. I have two tables. Application and ApplicationType. ApplicationType lists all the possible types. Let's use colors…
user736893
1
vote
0 answers
Searching Database Entity With Search Opeands(Like, Greater than, Less than, Between, ...)
I use criteria classes for search database in ado.net. For example, for searcing Users in db, I use UserSearchCriteria class to search with operands like "like", "between", "greater than", "less than"... For example search Username contains,…
cansu
- 958
- 1
- 12
- 23
1
vote
0 answers
ADO.NET/WCF Data Service - POST to Stored Procedure
Is it possible to trigger a function import/service operation with a POST as you might POST data to an EntitySet?
At the end of the day, I would like to post a bunch of arguments to a stored procedure. POST because some of the paramaters are large…
Kyle
- 1,366
- 2
- 16
- 28
1
vote
3 answers
MVC with web services
I'm working on building an application that's based on SOA. I have bunch of business services that I should make them available as components to another applications (so I'll use web services -SOAP-).
The application presentation layer is MVC.
1-…
Lisa
- 3,121
- 15
- 53
- 85
1
vote
2 answers
getting identity row value using ADO.NET Entity
I have the following table in SQL Server 2008 database:
User
--------------------------------------------------------
Id Numeric(18, 0) | Identity(1, 1) PK not null
Name Nchar(20) | Not null
I'm using an ADO.NET Entity Data…
VansFannel
- 45,055
- 107
- 359
- 626
1
vote
1 answer
unify two models (edmx) with visual studio 2010
Hello as actually as i know you can not make relations between tow models or have in one models entities from two databases, it's a posibility two join two models both of them with existig databases behind? or there is some experience with a method…
jlsfernandez
- 160
- 3
- 16
1
vote
1 answer
How to Convert object result model to a custom view model in asp .net MVC 5
I had done a project of using stored procedure to display join table values using entity framework.
I had done all the basic procedure and while calling it from my model it successfully return the object result,
Now my problem is I cannot able to…
Jawahar05
- 354
- 8
- 17
1
vote
2 answers
load entire db to data model?
I've decided to use the entity framework as data layer.
I have more then 200 tables, and two questions:
1. When creating the data model (*.edmx) - should I include all tables (entire db)?
2. Later, will I be able add tables to the data model?
Naor
- 23,465
- 48
- 152
- 268
1
vote
1 answer
Working with Sets of Self-Tracking Entities causing performance issues
I saw this Post by ADO.Net team which looks very promising until I started using it in my application. I have EF 4.0 model with close to 100 self tracking entities. After including the iterator in my project, any of the extension methods…
mahichR
- 355
- 3
- 14
1
vote
1 answer
Expose single parent/multiple child records as one OData entry
I have a typical parent table/child table setup in which a row in the parent table can have multiple child table associated records by way of a foreign key. An example:
Parent Table:
ID Book
1 Chemistry
2 Biology
Child Table:
ID …
Chris
- 55
- 5
1
vote
1 answer
Why do we need to create, open and close db connections to retrieve multiple result sets but not if retrieving one set?
In order to retrieve different result sets being returned by the stored procedure we have to use this:
UsersPhonesDBContext.Database.Initialize(force: false);
DbConnection con =…
azure boy
- 193
- 8
1
vote
1 answer
Strange Exception when using Entity Framework with SQLCE
I have used before EF 4 and SQLCE with no such problem.
While I have my assembly containing the edmx file and the context self tracking template and in another assembly the self tracking entities, I keep this strange compile error but the project…
George Taskos
- 8,324
- 18
- 82
- 147
1
vote
0 answers
SQLite connection doesn't appear in Entity Data Model wizard in Visual Studio 2017
I have a problem with SQLite and Entity Framework. After connecting to an SQLite database in SQLite/SQL Server Compact Toolbox, I add a new ADO.NET Entity Data Model item, using Database First.
I followed this video:…
namhnz
- 75
- 1
- 10
1
vote
1 answer
Entity Framework - query all records across linking tables
I'm getting lost down the rabbit-hole of EF and Lambdas. I'm trying to get all records from across linking tables.
I'm pretty sure my question is answered here but I can't work out how to apply the answer to my situation.
Here's a simplified model…
Craig Poole
- 740
- 8
- 19