LINQ To SQL: Fake Repository With Many-to-Many Relationships?
Aug 6, 2009
I have two tables, Clients and Administrators, which are linked in a many-to-many relationship by the table ClientAdministrators. In the real application this works fine and I can get a list of Administrators for my Client. My problem comes in trying to unit test the service class that is retrieving this from the repository. I have a FakeRepository class which implements my repository interface and I have several internal lists of objects for the service class to query against.
I am working on a VB.net (VS-2010, Win XP Pro 2 SP3), Employee Management Project. I need to keep track of Employee Leave Attendance and also each Equipment assigned to an Employee. How can I achieve this using SQLlite.
It will be very useful if you could provide me with examples as I am completely new to the field of SQL and VB.net I think this can be done with two tables where one has the primary key while the other has a foreign key, but I am not sure. Also how many tables will I need for storing data in Leave and Equipment Form.
I'm using a Data navigator to navigate (duh) through some records that my BLL fetches from the DAL. I use DataTables to fetch the recrods. Some of such records have one to many relationships. Lets say for example a person has may telephone numbers and my navigator goes through all the persons whose name are Joe. So I manage to show all the Joes through my navigator in the controls but I want to be able to show all their telephone numbers also. Persons is one Table, TelephoneNumbers is another. Each Telephone number has the person it belongs to. I access them through a DataSet and my BLL controllers return DataTables in their search methods, as said.
I have 2 entities that are related, but the legacy sql schema essentially has 2 key columns for the same table (not a 2-column key: see below). I need to create a relationship back to the 'faux key' column. Is there a way to do this declaratively in Entity Framework 4.1?
Public Class Client Inherits ModelBase <Key(), Required()> Public Property ClientID As Decimal <Required(), StringLength(50)> Public Property ClientCode As String .....
And the error I am getting is: One or more validation errors were detected during model generation: System.Data.Edm.EdmAssociationConstraint: : The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role. The type of property 'ClientCode' on entity 'ClientLocation' does not match the type of property 'ClientID' on entity 'Client' in the referential constraint 'ClientLocation_Client'.
Because it thinks I'm trying to map ClientLocation.ClientCode > Client.ClientID, when I am really trying to map ClientLocation.ClientCode > Client.ClientCode...
Current i'm developing an application track storage of an item.in it abusiness rule says an item can be moved to more than one warehouses. Also i need to keep the history of the Item's history, Thereefore i need to create two entities,"Warehouse" and "ItemsHistoryOfLocations". I have developped an static class diagram to show the relationshop.These are the relationship rules between the classes:
1. A warehouse could be in an Item's History of locations.
2. A warehouse could be in many Items' History of locations.therefore in the forward relationshop -- 1..*
3. In an Item's History of locations, there must be at least one warehouse4. In an Item's history of locations, there can be more than one warehouse
Therefore in teh backward relationship -- 1..* Therefore the relationship betwween teh classes is a M:N. In another Object oriented scripting languaage when ever, and M:N relationship is found between classes, their relationship is slit and put a collection class called "MemberKeyDictionaries" as the bridging entity.But in C# / VB, should we create these collection classe. IF NOT, then how should i modify my class diagram to implement this M:N relationship? and h0w do i implement this M;N relationship in code?
Suppose I want to inherit from System.Data.SqlClient.SqlTransaction which is sealed. Supose I want to just put a wrapper around SqlTransaction and always use MyTransaction instead of SqlTransaction. Is there a way I could potentially cast MyTransaction to SqlTransaction using an Implicit/Widening operator?
Does anyone know of a way to script falsifying the amount of RAM installed on a PC for an install. I have a program that needs to be installed on many systems that all have little RAM. The program requires during the setup that at least 384 MB of RAM be installed. Some of these systems only have 256 so the install fails. I know the easy answer is install more RAM. Ain't going to happen. Company has no budget. The install should be fine I think, but would like to test more. in order to do the testing to see if this would even work though I need to figure out how to have the OS tell the app it has more RAM than it does. I don't know this app but my first guess is the app queries WMI for amount of RAM?? If that's the case is there a way to set that WMI entry to something different until after the app is done? Or if someone knows another way that would be good too?
I am using the Entity Framework with POCO's generated using the T4 Templates. I have the generated classes in a separate assembly. Ok, so a very simple example: I have a Category entity in the model which has SubCategories (1-Many with SubCategory). When I use the following code, I get The ObjectContext instance has been disposed and can no longer be used for operations that require a connection. [Code]
I'm developing a business model for an application where I am representing physical entities. The hierarchy created from this is neat, but as I'm doing this, I'm beginning to think about things like, what properties should be included in one that may already be apart of another? Or what if some properties are expected to be in one object, but another object needs to return that value, how does it communicate that request through the hierarchical chain? And what is the best practice for this design?
[Code]...
But then I got to thinking, what if I have a ConnectionPoint entity and I want it to return which Panel it has? Should it have it's own Panel association as well? Or should there be a method/pattern for communicating the request up the chain? And again... what's typical best practice?
In VB6, if you put a picturebox on a form and then put a control inside the picturebox, then the control would be a child of the picturebox. Its location would be relative to the picturebox and not the form.If you do the same thing in VB 2005 Express , the control seems to still be a child of the form and not the picturebox (i.e. its location property is relative to the form).Is there any way to make a control or graphic inside a picturebox a child of the picturebox and not the form?
i'm having trouble with the relationships in VS when relating from long to Autonumber.I got an answer that fields should be declared integer, but ACCESS explicity states that fields realting to autonumber must be delared long.
I have a repository class that defines some basic Get/Save/Delete methods. Inside these, I use NHibernate to do the work on my business entities. For example:
[code]...
However, on my User class I have some properties and collections of other objects that ideally I'd like to be lazy loaded. But of course, the ISession is created and disposed within the repository, which I guess is why, outside of that, when I try to access those properties I get a "Could not initialize proxy - no Session" error.Is my only option then to disable lazy loading when using repositories? Or is it possible (or just foolish) to somehow get the session into scope in the business layer?I do like the repository model, and NHibernate is growing on me (after lots of initial frustration trying to make it work), so what's the best way you gurus have found of using them together?
I was wondering if there are any good vb.net code repositories around where people share code they have written, widgets they have developed, classes developed? I hate re-inventing the wheel.
Anyone ever get fake compile errors and rebuild the program and then they go away? Well mine aren't going away and I can compile and run no problem. I've got something like 100 compile errors and the "run with error's" warning doesn't appear at any time and when I do run my program it runs just the way it should. However I still see like 100 errors.
I know you can use regex to verify an email address format, but is there a way to, outside of sending an email to the address to verify that an email address is actually a working email address?
In my project I have it set up so that all the tables in the DB has the property "id" and then I have the entity objects inherit from the EntityBase class using a repository pattern. I then set the inheritance modifier for "id" property in the dbml file o/r designer to "overrides"
Public MustInherit Class EntityBase MustOverride Property id() As Integer End Class Public MustInherit Class RepositoryBase(Of T As EntityBase)
[Code]...
however produces the error "Class member EntityBase.id is unmapped" when i use VS 2010 using the 4.0 framework but I never received that error with the old one.
SubSonic 2.2. I use the repository record pattern, with a table "appointment" with an appointmentId as auto-incrementing int. I am trying to update it, but when I do update the fields with something totally different, dirty columns are always zero, and I get an exception.
The File Class has methods for sending/receiving (CopyTo and Overwrite) binary data to/from the File Repository Server (where files like Crystal Reports are stored), both of which have an overload that supports 'Binary data (safearray of VT_UI1)
I need to make a program for a fake/hypothetical company.The "company's" pricing is based on the number of days of the rental as detailed below; note that all time beyond a half day is counted at the full day or weekly rate. In addition, they offer insurance for their vehicles at a daily rate; insurance is mandatory for half-day rentals, and is only available at the full-day rate. The charge rates are as follows:
Half Day $20.00 Full Day $35.00 Weekly (7 days or more) $32.00 / day Insurance $5.00 / day
I didn't see a question on this subject in the archives, so here goes: For those of you experienced Mercurial users, is this a correct .hgignore file to tell VB.Net Express to ignore files/sub-dirs when adding items in a new repository?
I'm trying to create a fake virus for a collegue who keeps changing our desktop backgrounds. I have created a form in vb 2008. It as a window security icon and coule text boxs saying virus has been found, it has 3 buttons (Repair), (Quarantine) & (Ignore) and a progress bar on the form. I have put a timer event on the form too. My question is: How can i get the progress bar to pause at 50% and say files cannot be repaired, once ok is clicked on the pop up msgbox asking to Quarantine items, pause again on say 85% and msgbox say Cannot be repaired, try restart and run anti virus software.
I have a generic repository that I communicate with my object context with. My object context has function imports that I want to be able to call through my generic repository. Currently I call them through an "Execute" function, but this is not ideal because I have to pass in my function name and parameters as strings which can cause run-time exceptions. My function imports map to complex types.
Is there a way to do something similar to:
Dim rep As IRepository(Of ComplexType)
Dim type As ComplexType = rep.Find(where:=Function(t) t.FunctionImport(parm, parm)).First()
I have a "MenuService", which uses an "MenuRepository".When the MenuService is created, it loads correctly with the MenuRepository.Then it wants to save it in the UnityControllerFactory, but the MenuRepository in the MenuService is Nothing then (it wasn't before).Some additional info:I'm using the Unity and Repository pattern.The problem happens with a partial view (for a menu), which i have included in the "HomeController", it could be relevant information, so i included this, just in case:
Function Menu() As ActionResult Return PartialView("~Views/Shared/_Menu.vbhtml", _MenuService.GetAllMenuItems) End Function
we have a CollabNet Subversion Edge server running on a Windows server. Subversion Server is configured to serve via https. When trying to import a Visual Studio project folder with TortoiseSVN it hangs when adding the project file (.vbproj). Test 1: It happens exactly the same when the server is configured to serve via http.Test 2: Importing any project folder using the console utility (svn) works fine.
Both these tests lead to the conclusion that there is neither a network nor authorization problem.