Entity Framework 6 - Knowledge Base (KB)
554 results in tag: asp.net
Entity Framework Guid
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
Databinding ASP.net DropDownList 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
What are good design practices when working with Entity Framework
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
Entity framework and VARBINARY
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
Can I use Entity Framework 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 the default value of a DateTime Property to DateTime.Now inside the System.ComponentModel Default Value Attrbute
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
Using the repository pattern with Entity Framework (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 call a Stored Procedure from an EntityDataSource?
(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
Using partial-classes in Entity Framework with custom properties
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
Entity framework context as static
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
Using Entity Framework as Data Access Layer
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
Implementing a Search Box using ASP.NET MVC, SQL Server, Entity Framework
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
Retrieve single Entity Framework entities using a LINQ query or GetObjectKey?
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
Multiple relationship binding with EntityDataSource
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
Posttorial: ASP.NET MVC, Entity Framework and LINQ video tutorials - Including MIX09, PDC, 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
How do I 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
Problem with Entity Framework after adding column to DB 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
Entity Framework to multiple databases (same schema) at runtime?
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
keyword not supported data source
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
Entity framework with "Group By" and/or "Order by"
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é
Page 1 of 28
