Entity Framework 6 - Knowledge Base (KB)
554 results in tag: asp.net
Entity Framework Reference
I'm trying to setup the Entity Framework with SQL Server 2008. I'm using Guids for the keys on my tables. Is there a way to set it up so the keys are automatically generated by the database? I tried setting "RowGuid" to true and also set the column's d...
asked by Jake Pearson
ASP.NET DropDownList Databinding with Entity Framework
I'm trying to bind an ASP.net DropDownList to the results of an entity framework query, while still maintaining multi-tier separation. (i.e. I don't want my UI code to contain query details, nor my Data Layer code to have UI dependencies.) My code-behin...
asked by AndrewCr
When dealing with Entity Framework, what are effective design practices?
This will apply mostly for an asp.net application where the data is not accessed via soa. Meaning that you get access to the objects loaded from the framework, not Transfer Objects, although some recommendation still apply. ...This is a community post, so...
asked by ADB
VARBINARY and the Entity Framework
I’m using the .NET entity framework and I’ve got one entity containing a varbinary. Is there an easy way to get the size of the varbinary in the codebehind, efter it’s been retrieved from the database?...I’m thinking there might be some way to get...
asked by Marcus L
Is Entity Framework compatible with ASP.NET Membership?
I'm creating (really, re-creating) an app that has existing user and other data in MS-Access databases. The data will be moved to SQL Server, and part of that involves migrating users. I want to use EF to do ORM, and I am pretty sure I know what the dat...
asked by oasasaurus
Setting a DateTime Property's default value to DateTime. Now you're in the System. Default Value Attribute for ComponentModel
Does any one know how I can specify the Default value for a DateTime property using the System.ComponentModel DefaultValue Attribute?...for example I try this:...[DefaultValue(typeof(DateTime),DateTime.Now.ToString("yyyy-MM-dd"))] public DateTime DateCrea...
asked by REA_ANDREW
Entity Framework and the repository pattern (mvc storefront)
Can anyone give a helping hand? I've been watching the videos for the MVC storefront and have created my own website using these techniques i.e. DDD, Repository pattern but I wish to use Entity Framework....In the Interfaces it returns IQueryable but with...
asked by Mark Smith
Can I use an EntityDataSource to invoke a Stored Procedure?
(ASP.net 3.5, C#, SQL Express 2008)...I want to have a Web Form, where I can search for "Solutions" (my table) using a keyword entered by the user and after the result comes back and populates a GridView. ...I already have parts of this search via a store...
asked by miccet
Entity Framework partial classes with custom attributes
How should I handle a custom property in a situation where I use partial classes with the EF-generated classes? ...Here's the setup:...TimeSheet Table - this stores an employee's hours... - TimeSheetID (auto, int, PK)... - EntryDate (DateTime)... - Hours ...
asked by bugfixr
As a static context for Entity Framework
In a web application it would be ok if i declare the context of a entity framework model as static? it would be ok? its not recommended? why? Thanks!
asked by Dennis
Data Access Layer using Entity Framework
In my ASP.NET application I want to implement by data acess layer using the Entity framweok so I can use it as an ORM tool. But I dont want the rest of the application to care that I'm using this or be polluted by anything entity frameowrk specific....I c...
asked by AJM
ASP.NET MVC, SQL Server, and Entity Framework are used to create a search box.
I have no experience building a search solution, but I'd like to have a search box within my solution and I don't know where to even begin. Are there cool SQL Server tricks that I can use to make my search solution performant (I'm using a hosted SQL 2008...
asked by Whozumommy
LINQ query or GetObjectKey to get single Entity Framework entities?
It looks like GetObjectKey has the benefit of searching for existing, instantiated objects, and THEN the data store. However, it also seems like you lose some of the strong typing, and need to cast your resulting object:...GetObjectKey...int customerID =...
asked by John Bubriski
EntityDataSource supports multiple relationship bindings.
I have an ADO .Net Entity Data Model for my database. In this Model I have three related tables: "Users" Table containing UserId and other details. "Run" Table that contains RunId, ApproverId and other details "RunToUser" that contains UserId and RunId c...
asked by Jay
Video lessons on ASP.NET MVC, Entity Framework, and LINQ - including MIX09, PDC, and TechED
EDIT:...During this post I started searching on video tutorials on ASP.NET MVC, EF and LINQ and found some very useful links which I shared here. As I believe videos are more interactive and easier to learn from. Hope, they'll help....Guys, pl...
asked by Ramiz Uddin
What is the best way to add ROW NUMBER to a LINQ query or Entity?
I'm stumped by this easy data problem....I'm using the Entity framework and have a database of products. My results page returns a paginated list of these products. Right now my results are ordered by the number of sales of each product, so my code look...
asked by Whozumommy
Entity Framework issue after adding column to database table
I needed to add a new NVARCHAR column to a table in my DB. So I added the column, and then fired up Visual Studio to update the EDMX-file for the Entity Framework....I ran update model from database on everything, which only resulted in "data reader is in...
asked by Marcus L
At runtime, can Entity Framework connect to several databases (with the same schema)?
First of all, let me state I'm very new to EF. With that said, here's my dilemma:...There will be an ASP.NET App migrated to ASP.NET MVC. I would like to utilize EF for this. There is one main database which stores "client information". Apart from that, e...
asked by Kevin
data source not supported keyword
I have an asp.net-mvc application with the default membership database. I am accessing it by ADO.NET Entity Framework. ...Now I want to move it to IIS, but several problems showed up. I had to install SQL Server Management Studio, Create new DB, import th...
asked by Trimack
"Group By" and/or "Order By" in the entity framework
Say we've got a project that allows user to download things. On the main page, I want to show the Most downloaded files ordered by the number of download! All that using EF....How can i do this !! I've tried many things with Group By (Its a nightmare when...
asked by Simon Dugré
