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
2 answers
ADO.NET Entity Framework Quirk
When I run the code below, it works
int charId = int.Parse(Request.Params["charId"]);
EveFPT ctx = new EveFPT();
var theCharQuery = from a in ctx.tblChars
where a.id == charId
…
jameszhao00
- 7,213
- 15
- 62
- 112
0
votes
2 answers
How to 'merge' two different db tables to a single inherited class hierarchy in EF?
I have a legacy DB I'd like to writing an application for monitoring some stuff in it.
The DB has a set of tables which is repeated for each 'project' in it.
For example if I have 2 projects, I would have project_1_table and a similar…
Lockszmith
- 2,173
- 1
- 29
- 43
0
votes
2 answers
Login Failed for User 'NT AUTHORITY/NETWORK SERVICE' when using EntityDataSource with ASP:ListView
I have receive the infamous Login Failed for User 'NT AUTHORITY/NETWORK SERVICE' when I try to run a page that contains and EntityDataSource and Listview. Here's Stack Trace:
[SqlException (0x80131904): Login failed for user 'NT AUTHORITY\NETWORK…
SidC
- 3,175
- 14
- 70
- 132
0
votes
2 answers
how to set return type of a stored procedure according to a specific table
I had made a dynamic stored procedure like this
CREATE PROCEDURE [dbo].[MyProcedure]
@pSelect nvarchar(max)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @SQL nvarchar(max)
SET @SQL = 'select ' + @pSelect + ' from tabel1';
EXEC…
Amit Bisht
- 4,870
- 14
- 54
- 83
0
votes
1 answer
Generating SQL Server Views from EDMX using T4 templates
I'm working with a legacy database that I can't easily create an entity model over because it uses extension tables with what is effectively composite keys and EF only supports single column keys for mapping one entity to multiple tables.
So, what…
Sheldmandu
- 1,700
- 16
- 10
0
votes
1 answer
how to deploy website with edmx
i have just only added Edmx file inside *App_code* folder and it's mapped with database(sqlexpress). I am not using ADO.Net context DB generator. My website is working successfully in local pc but when website is hosted in IIS7 it is not running…
user2717258
- 46
- 3
- 11
0
votes
1 answer
Select All records of a class with LINQ query
I am trying get some records from a linq query
dataentities db = new dataentities();
db.Tabel1.Select(x=> new lcclsAccDueList {LedgerName ,LedgerId,Amount ,AmountInString ,Expr2,Name ,StopID ,VIP }).ToList();
I made this class
public class…
Amit Bisht
- 4,870
- 14
- 54
- 83
0
votes
1 answer
Call WCF method from client c#
I have created one WCF service Application. There are few methods in Service1.svc.
Here is my IService1.cs
[OperationContract]
GetUserDetailsByEmail_Result GetUserDetailsByEmail(string email);
Here is my Service.svc.cs
public class Service1 :…
Ajay
- 6,418
- 18
- 79
- 130
0
votes
1 answer
Ado.Net Entity Framework Code-Only with Ado.Net Data Service
Im using the pre release of Ado.Net and can't understand how I use that with Ado.Net Data Service.
The code for the ObjectContext
public class TradingContext : ObjectContext
{
private static TradingContext _Context;
public…
Christian Johansson
- 23
- 4
0
votes
1 answer
Working with Entity Framework and ajax post is not working after publishing to a server - 500 internal server error
My project is working fine on my computer running Visual Studio 2010 (SP1) WebServer
All of the problems are as usual when publishing to server
The server is : windows2003
I don't think it had any prior attempts to run Ef before in other projects…
Regina Jerusalemsky
- 83
- 1
- 5
0
votes
1 answer
Error after adding ADO.NET Entity Data Model to WPF Browser App
I am creating a WPF Browser App in which I need to be able to access and insert data into a SQL Server table. Before adding the data source, the program builds and runs just fine. After using the wizard to add the ADO.NET Entity Data Model…
jrpharis
- 81
- 1
- 1
- 11
0
votes
1 answer
How can I detect relations between the tables in my UML?
I'm developing an application in C# using Visual Studio 2012 that must generate, among other things, a generic data model, an *.edmx file. This program receives a UML model and transforms it into C# classes and data models in an MVC architecture,…
chiapa
- 4,362
- 11
- 66
- 106
0
votes
2 answers
ADO.NET Entity Data Model - MVC - managing one-to-many relations
Let's say that I have following situation.
I have many customers and many consultans, and each customer has attached only one consultant. So it's one-to-many relationship.
I created Edit view which display customer_name and customer_consultant_id…
Inez
- 2,115
- 3
- 20
- 25
0
votes
1 answer
ado.net entity data model and mysql - problem with UTF8
I use ADO.NET Entity Data Model in ASP.NET with MySql. I tried many collocation for my databases and tables but so far diacritics (polish) characters are changed.. for example, from ł to l. And this is at query level (I log all query to file on…
Inez
- 2,115
- 3
- 20
- 25
0
votes
1 answer
An already open DataReader for the ADO.NET Entity model in ASP.NET MVC project
I'm using ADO.NET Entity model for data binding and other data manipulation for my ASP.NET MVC 4 Razor project.
I'm trying, in my model, to bind data like this in my Controller:
http://ideone.com/GvskaG
When I reach the line 26:
26. Sender =…
user2402179