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.
[Code]...
View 3 Replies
ADVERTISEMENT
Apr 23, 2011
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.
View 1 Replies
Apr 14, 2011
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.
View 8 Replies
Aug 24, 2011
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...
View 4 Replies
Jul 12, 2009
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?
View 1 Replies
Jun 10, 2011
i have code to produce a database and tables but now i am looking 4 code 2 add relationships to the tables i would have made
[Code]...
View 1 Replies
Dec 14, 2011
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?
View 8 Replies
Jun 30, 2009
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?
View 17 Replies
Feb 23, 2011
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]
View 2 Replies
May 7, 2012
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?
View 3 Replies
Jan 10, 2009
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?
View 2 Replies
Jun 15, 2009
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.
View 3 Replies
Oct 29, 2010
I have this code to send an email:
Imports System.Net.Mail
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code].....
View 6 Replies
Mar 16, 2009
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?
View 1 Replies
Aug 1, 2010
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.
View 3 Replies
Jul 26, 2010
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.
View 4 Replies
May 5, 2012
how do you make a fake error popup window?
View 1 Replies
Dec 27, 2009
I want make a antivirus a real that can find everything iwant a tutorial that haves pictures how to do it
View 2 Replies
Jun 20, 2012
i want to make fake progress bar when i click on the button:
for i = 0 to Maximum
progressbar1.value = progressbar1.value + 1
next
but the progressbar.value = 100 Too fast
View 3 Replies
Apr 16, 2009
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?
View 4 Replies
Jun 12, 2010
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.
View 1 Replies
May 29, 2009
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.
[Code]...
View 1 Replies
Oct 27, 2009
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)
View 1 Replies
Feb 20, 2011
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
And 8% sales tax has to be added on.
View 11 Replies
Mar 23, 2010
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?
[Code]...
View 1 Replies
Aug 27, 2009
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.
View 14 Replies
Feb 23, 2010
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()
Here is my generic repository as is:
[Code]...
View 1 Replies
Sep 1, 2011
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
Also, my partial "menu" view is like this:
~/_Menu.vbhtml
@ModelType IEnumerable(Of FacturatieMVCv2.Domain.Slave.MenuItem)
@*<div id="myslidemenu" class="jqueryslidemenu">*@
[code]....
And i'm calling the partial view with:
@Html.Action("Menu","Home")
View 1 Replies
Nov 16, 2011
I have the following tables
Public Class Tag
<Key()> _
Public Property TagID As Integer
[Code].....
I implemented the repository pattern.
Now i have a list of Tags which contain the right TagReferences, but the tags may not be deleted, it's the TagReferences.
Variabels = ReferenceValue,ReferenceID
IEnumerable(Of Tag) = TagRepository.GetMany(Function(el) el.Reference = ReferenceValue And el.TagReferences.Any(Function(bl) bl.ReferencedID.Equals(ReferenceID)))
How can i remove all the TagReferences which contain the ReferenceID in one line?
View 1 Replies
Aug 25, 2011
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.
View 1 Replies
