Tagged Questions

2
votes
3answers
102 views

Using Linq to select the first and last values

I want to get just the first and last values in a date range. I have the following code: using (var myEntities = new dataEntities()) { var myValues = (from values in myEntities.PointValues ...
1
vote
1answer
60 views

Feedback and Advice on my N-Tier Application Architecture

I am working on an application that will use an N-Tiered approach. I would appreciate any feedback and advice on my architecture before I proceed any further. DataLayer (Class Library Project) ...
3
votes
2answers
96 views

Refactoring from .. in .. select to more compact one

Is it possible to write the two following lines of code in a more compact one? IEnumerable<int> collection = from partnerNumbers in contract.Contact.PartnerNumbers select partnerNumbers.Pnr; ...
1
vote
2answers
100 views

How to optimize/refactor this method?

Here is my method: public JsonResult ValidateAll(string toys) { Dictionary<string, object> res = new Dictionary<string, object>(); List<string> result_check = new ...
0
votes
1answer
117 views

How can I implement the generic repository pattern and improve the performance for the code below?

I've used EF-DB first approach and have written a simple app to retrieve the data from the database and show it in the view. The code is simple and ok for a beginner like me, but how can I implement ...
4
votes
1answer
212 views

Looping through columns in Entity Framework

Is there a cleaner/more efficient way to loop through the columns in EF implicitly than the way written below? static void Main(string[] args) { using (var db = new someDbContext()) { var ...
3
votes
1answer
103 views

Code-First TPT, TPC, or incorrect inheritance?

My question is: based on the business need below, should I use Table-Per-Type, Table-Per-Class/Concrete-Type, or am I misusing inheritance in the first place? If TPT, will the query performance ...
2
votes
2answers
74 views

Optimizing a distinction code

List<int> types = new List<int>(); foreach (var d in myTableList) { if (!types.Contains((int)d.item_type)) types.Add((int)d.item_type); } I have a table in db called myTable. ...
3
votes
1answer
84 views

Optimization of code for searching in db

This is my code: var test = (from x in myDb.myTable where (x.name == tmp || x.name == tmp2 || x.name == tmp3) && x.unit == u select x).FirstOrDefault(); if (test == ...
3
votes
0answers
448 views

Correct usage of EF's DBContext in ASP.NET MVC application with Castle Windsor

I am trying to use Entity Framework as simple as posible. Use UnitOfWork and Repository patterns seems to be overkill because whole web application will be pretty straightforward. I came with this ...
1
vote
1answer
108 views

Passing an entity to use it's fields to update method is ok to do?

I have two different ideas on how to handle this Update method in my MVC Model class "DataAccess" And I'm wondering if in the first, I'm handling my class incorrectly or ambiguously, because I'm using ...
0
votes
1answer
87 views

Products table or Products + attributes when using EF + MVC 4 [closed]

What I need to build is a web application that maintains and shows products. A product has a lot of attributes, some that will be changed or added during the next year. I have 2 options for designing ...
4
votes
4answers
373 views

Is this bad code? (Instantiating if null)

I often have static classes which uses the DataContext somehow, and they all make a new DataContext, but often i allready have one instantiated elsewhere, so why not use that?. And then i would do ...
6
votes
2answers
9k views

Entity Framework Generic Repository Pattern

Thought 1 public interface IRepository<T> : IDisposable where T : class { IQueryable<T> Fetch(); IEnumerable<T> GetAll(); ...
4
votes
2answers
384 views

Trying to clearly seperate my logic in my program

My problem is I need to know is my code in my CRUD functions structured well and effectively? I plan to implement CRUD for Locations entity too. hopefully without redundant code. you see how one ...
0
votes
1answer
140 views

Making a Custom class less specialized but just as understandable?

In my C# program, I have a class defined as follows: public class DbResult { public bool bSuccess { get; private set; } public String Message { get; private set; } private DbResult(bool ...
1
vote
1answer
226 views

Am I using too many functions in my DataAccess Class?

I am wondering if in particular the function called AssignDBStatusMessage and TryDataBaseAction are unnecessary. It seems to me that the logic is more cluttered if i do away with those functions. ...
5
votes
1answer
488 views

ListBox for a many to many relationship

I'm looking for a good and easy to use solution for creating MultiSelectLists in MVC for many to many relationships. I have this following example code and it works fine, but it just takes a lot of ...
1
vote
2answers
191 views

How to organize this code and prepare more versatile CRUD functions?

I am using C# and the .net entity framework, and I'm also learning how to better use OOP concepts in my program. My code is all displayed below. I would like to ensure my logic is properly organized ...
0
votes
2answers
243 views

using 2D array to read datatable ok? or repeatedly call function that reads record by record?

I am asking this for coding style. I have a program class that calls a function(of a data access class) that reads from a table (using entity framework by the way), and I'm preparing to write the ...
6
votes
1answer
271 views

combining 4 CRUD functions into 1?

I have a console application that I'm trying to make with minimal redundant code. I have 4 functions, Create, Read, Update, and Delete. is it possible or practical to combine the four functions ...
5
votes
2answers
187 views

How to reduce my code length without changing concept?

There are three servers. I want to assign a job to a server which has least NotStarted jobs. I have achieved this, but my code is very lengthy. I don't know how to minimize my code without changing my ...
4
votes
0answers
265 views

Multiple repository calls or LINQ query

These two methods do the exact same thing (or at least they are supposed to!). They both pass a simple test based on a mock context. Neither has been exposed to any integrated testing yet. Would ...
4
votes
2answers
574 views

Threadsafe DBContext in singleton

I found out the hardway that access to DbContext in .NET is not threadsafe. I have a singleton for logging things using a dbcontext. The original version uses something like public Logger{ private ...
7
votes
2answers
3k views

Generic repository and unit of work code

I am writing a WPF application that needs to access information from a database (I am currently using Entity Framework code first, so data access is via DbContext). My ViewModels directly ...
0
votes
1answer
156 views

Is it proper TPT Inheritance

I have following model and database created using Entity Framework. Is it proper TPT Inheritance? Is it possible to make the base class as abstract? Model Database CODE namespace LijosEF { ...
1
vote
2answers
516 views

Many to many crud using entity framework 4.1

My view submits data to the controller using Json objects which contains child objects.It allows users to add/remove/modify the relationship with child entities(authors,categories,LIbraryBookCopy). ...
2
votes
0answers
365 views

Linq-to-entities query too slow

I am fairly new to Entity Framework and I am not sure I am really using it to it's max potential. I have this query, that IMHO seems to take a little longer than I feel it should. I have tried ...
2
votes
1answer
901 views

Your Thoughts: Entity Framework Data Context via a DataHelper class (centralized context and transactions)

I want to get opinions on the code I have put together for a centralized DataContext via a DataHelper class that I have created to be re-used on projects. NOTE - there is a ton of code here, sorry ...
2
votes
1answer
581 views

IAuditable and IArchivable Repository with Repository Pattern and UnitOfWork

I am quite new to ASP.net and am currently trying to implement my data access layers of my application. I have so far implemented a generic repository pattern as follows: using System; using ...
1
vote
1answer
140 views

How could I remove repetition from this linq-to-entities query?

This linq query works, and it does what I want it to do, but is there any other way I could improve the query so I'm not repeating a.AnswerRevisions.OrderByDescending(r => ...
5
votes
1answer
199 views

LINQ Compare Query Improvements?

I'm attempting to create a compare table to compare products depending on the add-ons they have. To grab the data and filter it I'm using LINQ To SQL. Table's Layout (Cut short): Products Table ID ...
1
vote
0answers
128 views

Is my MergeUtility good enough to create an open source project out of?

Here is a utility that supports ETL/merging in EntityFramework. If it's not appealing as a general purpose tool, why? If it is appealing as a general purpose tool, how might the design be made ...
2
votes
1answer
205 views

Clever way to build a extension method that ordenate my IQueryable<T>?

I want to create a ExtensionMethod to ordenate my linq query, called Ordenar. I'll sort it depending what columns is in sortColumns ListDictionary. I tried some ways, but the best way I arquieve was ...
3
votes
1answer
319 views

LINQ generating chart

I'm generating a table to use on jQuery visualize plugin and generate a chart. The code is pretty good, but maybe there is a way to improve it. Maybe do more work on the LINQ query and less stuff on ...
3
votes
2answers
148 views

Could generics condense these two methods into one?

Two methods which do very similiar things, is it possible to condense these somehow? This is using the Entity Framework. public void ExportSiteData (FLEX_INV_EXP_SITE siteData) ...
1
vote
2answers
361 views

Review on core EF repository method

What do you think about this core EF method ? Also, Notice that it returns IQueryable: Could that be a performance danger when extended improperly ? How ? Please accept the fact that Includes and ...
5
votes
1answer
1k views

Entity Framework Code First Data Updater

For a given Entity Framework data set, I have written several adapters to import data into my entity models. Rather than manually write mapping code for each entity model, I tried for a generalized ...
10
votes
4answers
16k views

Entity framework with repository and Unit Of Work pattern and POCO architecture - is this right?

This is my architecture to EF4 using repository pattern and unit of work pattern with poco. I believe I made some mistakes. Here is the architecture: I have a solution with 5 projects: ...
2
votes
2answers
2k views

Importing XML to a database using LINQ to Entities

I am importing XML data to a MySql database using LINQ to Entities. The data represents which students are in which classes, and looks like... <studentClassesData> <studentClassEntry> ...
3
votes
1answer
524 views

Merge entities which have the same children

The C# code below, using LINQ to Entities, aims to merge all Class entities which have the same SubjectId and the same Students. var sb = new StringBuilder(); var counter = 0; using (var ctx = new ...
1
vote
1answer
1k views

Creating Extension Method to map entity with subentities object to Poco object

I am trying to create an extension method that builds a POCO object (copies all the fields) for an Entity Object. When Entity object is simple (no navigation, no sub collections), it works fine. I ...
0
votes
1answer
501 views

Does my Entity Framework 4 Model-First design look ok? Any issues?

I'm very new to entity framework and I've found model-first design is a more preferred way for generating a relational diagram, rather than reverse-engineering an existing schema. I've designed my ...
1
vote
1answer
779 views

Advice on approach to organizing my business logic & data access?

I've been researching various patterns for structuring my business logic & data access, particular in the context of C# and the Entity Framework. I've come up with a basic idea of how I think I'd ...
7
votes
6answers
8k views

Is there a better way to do dynamic filtering and sorting with Entity Framework than this?

I'm developing an application using ASP.NET MVC 3 and Entity Framework 4.1. In that application I have a lot of paged lists. Users can filter and sort these lists. This results in code like the one ...
2
votes
1answer
291 views

Dynamic variable - is that best way to dynamically assign?

Normally I could just declare the 'email' variable as the base class for both of EmailInbound & EmailOutbound, then cast-up to the inherited class. However, I don't think when defining EF ...
7
votes
0answers
1k views

Constructing a Data Contract interface that can be used with Entity Framework 4.1 to ensure entity validity

I need some thoughts about an approach a colleague and I am are taking with Entity Framework. Basically, the entities are represented by contracts. These contracts hold a collection of business rules ...
14
votes
1answer
4k views

What is better for Lazy-Loading Navigation Properties of detached Self-Tracking Entities through a WCF service?

I have a WCF client which passes Self-Tracking Entities to a WPF application built with MVVM. The application itself has a dynamic interface. Users can select which objects they want visible in their ...
3
votes
2answers
538 views

Can you review this small method for saving student attendance?

var studentRepo = new StudentRepository(); int gradeParaleloId = Convert.ToInt32(cmbGradeParalelo.SelectedValue); var students = studentRepo.FindAllStudentsFromGradeParalelo(gradeParaleloId); int ...
9
votes
3answers
2k views

Please Review: My approach to dealing with Entity Framework's lack of enum support

I'm using Entity Framework Code First CTP 5 for a current project. There is still no enum support in Entity Framework so this is what I am using in order to avoid having magic numbers or casts ...