I have a situation where I have 3 tables: StockItem, Office and StockItemPrice. The price for each StockItem can be different for each Office.
StockItem(
D
Name
)
Office(
ID
Name
)
[code]...
I am building an object from multiple datasources. Does anyone know whether this is possible in NHibernate and how. I should mention that one source is SQL the other ORACLE.
View 1 RepliesI have table with 'usercard' name , and a related tables :
- Computer
- Laptop
- Fax
- UPS
Now , Every Employee has one or more than one from these devices , When I used INNER JOIN in my select query , I didn't get what I need
the result show a one user in 4 rows,(user have all devices)
Is it possible (in a clean fashion) to create an audit interceptor in hibernate 2.1 and pass in a domain context to it?What I would like to achieve is to set a Date Time (can be done easy peasy - found loadsa articles after a quick google), but setting an object e.g. a user who created the item, or altered an entity I have yet to find anything which covers this.Since I will not know the object at application request/start up (which is where i have to register the nhibernate interceptor), does anyone know of a suitable workaround?
View 1 RepliesTraditionally with an Object Data Source, the wired up class will have its public properties available for binding (i.e. Gridview columns, etc.) which works well. But what if one of my wired up business objects has a property that is an object itself; can I drill down to a property on that object property and still use it?
So in additiona to the traditional:MyBusniessObject.OrderID...I want to use:MyBusniessObject.Customer.NameID
Your 1st response might be to just wire up the 'Customer' class, but I need properties both on 'MyBusinessObject'and 'Customer'. I do not think this can be done, as the ODS will not display properties on an object instance property. I have tried manually typing in the drilled down value as well, but that wasn't a success either.
What is the best way to design the Domain objects which can have multi-lingual fields. An example can be a Product class with Description being multi-lingual.
I have found few links but could not decide which one is the best way.
http://fabiomaulo.blogspot.com/2009/06/localized-property-with-nhibernate.html
(This stores all localised language data in one field. Can be a problem if we query from Sql)
http://ayende.com/Blog/archive/2006/12/26/LocalizingNHibernateContextualParameters.aspx
(This one has a warning at the beginning that it is a hack and no longer supported)
http://www.webdevbros.net/2009/06/24/create-a-multi-languaged-domain-model-with-nhibernate-and-c/
(This does not describe how multilingual data will be structured in the database.)
Anyone having experience with using NHibernate with multi-lingual data.
am looking for the best approach to using NHibernate and MVC.net. I have gone through http://www.codeproject.com/KB/architecture/NHibernateArchitecture.aspxSomeone has pointed to the use of Castle project Active record. My aim is to eliminate the need for any nhibernate dependencies within my domain. I want a quick and easy domain model that is persistable with NHibernate.
View 2 RepliesI want to get data from Projects(which have CourseId) and related CourseName from Courses table.
I have written following code:
var projects = from n in db.Projects
join c in db.Courses on n.CourseId equals c.ID
orderby n.Name
select new { Project = n, Course = c };
return View(projects.ToList());
and I get error:
The model item passed into the dictionary is of type 'System.Collections.Generic.List1[<>f__AnonymousType22[ProjectManager.Models.Project,ProjectManager.Models.Course]]', but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable`1[ProjectManager.Models.Project]'.
What I need to do in Controller and in View to display this data?
i have a form that my i use to look up whether or not there is an email address in the database. i wrote a query with this basic structure:
select *
from table A, table B
where table A.email = "email" or table b = "email"
i though that would return all instances that the email occurred in either table. what i am getting back is a bunch of null or other unrelated records from table A with a matching email in table B. the thing is, these two tables primary key to join them. i thought i wouldnt need to do that though in this case.
here is the actually query i am using if it makes things more clear:
select lm.cemailaddr, lm.b1emailadd, b.emailaddr
I'm trying to achieve an outer join in LINQ but I'm not getting my desired result.There are two relational tables between Fruit_Name and Fruit_Ripe.The Fruit_Ripe table has a boolean field (IsRipe) that I use in my condition.The condition let me show all fruits that is not yet rippen (false) or fruits that isn't inputted yet in Fruit_Ripe table.
Dim fruit_salad = From myFruit In _DataContext.Fruit_Name
Group Join myRipeFruit In _DataContext.Fruit_Ripe On myFruit.fId Equals myRipeFruit.fId Into Group
From fruitty In Group.Where(Function(d) Not d.isRipe =
[code]...
I have a simple ASP.NET MVC web application that uses NHibernate with FluentNHibernate's auto mapping feature for its data access. I have encountered a scenario in which I would like NHibernate to persist some classes as binary data.
public class User
{
// This field will be persisted
public virtual byte[] PortraitData { get; set; }
// This method will get me what I'm actually interested in
public virtual Image GetPortrait()
{
return SerializationHelper.Deserialize<Image>(PortraitData);
}
}
(I leave the implementation of the SerializationHelper class to the reader's imagination. It doesn't do anything complicated, just serializes and deserializes data into byte arrays and back.)
For context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.
I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.
I have tried to accomplish this using many variations of the following code:
[Code]....
In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.
How can I make this work? I have yet to see an example or article out there to do what I am trying to do.
I've got a web application I've built that makes various database calls to render some charts and datagrids for MI reporting purposes. I've got my database calls initiating on Page_Load within the .vb for each page. The site impersonates identity for database access. Page_Load returns a datatable and populates an HTML table inside an ASP:Repeater. Still with me? Well, everything works fine here. My problem is within the Default.aspx.vb Page_Load sub.
The Page_Load sub (in Default.aspx.vb) returns a datatable the same way as the others but instead of rendering the results to a repeater, the datatable is saved as Session("dt"). The saved session "dt" is then used to populate a couple of charts I've got on the home page(default.aspx):
<script
runat="server">
Public
Function buildXML(ByVal Product
As
String,
ByVal reportNameStr
As
String)
As
String
Dim clDB
As
New clDB
Dim clSB...........................
Here is my Controller:
public class MatchManagerController : Controller
{
//
// GET: /MatchManager/
public ActionResult Index()
{
return View();
}
public ActionResult CreateMatch()
{
return View();
}
}
Here is my View:
@model MatchGaming.Models.MatchModel
@{
ViewBag.Title = "CreateMatch";
}
CreateMatch
@using (Html.BeginForm()) {
@Html.ValidationSummary(true).....
I want my MatchTypeId to be a drop down that populates from my table MatchTypes.
I am getting the following error in an Asp.Net Castle ActiveRecord app when trying to update an object:
"a different object with the same identifier value was already associated with the session"
I've looked up and down my code to see where else the object might have been created but I'm not seeing it. This is baffling as I have the exact same code on another page that works fine on updates
Now I'm thinking of trying to see where this other object is in the Session and either kill it or find out how it got into the session. How can I find this object?
[Update]
Ok, I finally found where the object is being called. However, I would still like to know how to find objects in the session for future reference.
I am trying to configure NHibernate on my console application in which I am trying to map an Employee class to a table Employee.I am getting below exception which I have no clue:
Class:
class Employee
{
public int id;
public string name;
[code]...
The problem I have is that I've got a simple ASP.NET page. On it, I have a dropdownlist that is calling values from a MySQL table.
When I select a value from the list, I want to create/update a GridView.
I've created the code, which works if I hard code the parameter, but I want to use the DataValueField from the drop down list.
Is this possible?
[Code]....
I need to bind an ASP.NET control something like so:
<asp:label ID="lblName" Text=<%# GetName()) %>
and in CodeBehind file I have this method:
protected string GetName()
{
...
}
Is this right, or how I can do something like this?
I have following doimain objects:
public class ComponentType
{
public int ComponentTypeID { get; set; }
public string Component_Type { get; set; }
public string ComponentDesc { get; set; }
}
[code]...
To write a join query with or condition. It means a query has two inner join, here it is possible to fetch the records, if one inner join is true and other is false. I got a record when only two join conditions are true.
View 1 RepliesI'm trying to build a linq2Entity/gridview function for a forum, that draws data from multible tables.The result should be: Get the latest 10 threads that user(xx) has replyed in, that is not disabled or has a subject that is not allowed.Include information on the last post, thread owner user, and last post user, in each thread.
ere is my code... is returns the correct threads and some that should not be there.
[Code]....
I am trying to use a property from the code-behind to populate a textbox instead of using in the code-behind textbox.text=. I am using vb.net. Here is the code for the aspx page:
<asp:Content ID="Content2" ContentPlaceHolderID="MainContentPlaceHolder" runat="server">
<asp:TextBox runat="server" ID="roleTextBox" Text='<%# CurrentRole.Name%>'></asp:TextBox>
</asp:Content>
Here is the code behind code:
[Code]....
When I run the page the text box is empty.
I have some text files I need to parse in order to display my data, and what I have now are two text files with lots of redundant data. Instead of this I would like to replace the redundant data with a number referencing the text in another text file.
View 1 RepliesI have a .net app consuming a java web service. I added the web reference in visual studio to the proper wsdl, it created the proper proxy class and I can call the web service without any problems but looking at the result that is returned, it is always nothing. I can see, by using Fiddler, that the response is returning what it should. If there is a response, why is the return object never being populated and no errors are thrown?
View 2 RepliesI am trying to figure a way to SSO with ASP.NET membership and role model.
I can implement custom membership provider which consume web services hosting on a server.
With encryption of data. No problem.
But my question is, If I sign on a website with my provider, got my identity object on that application,
could I pass it to another website on another domain which use the same provider and by doing so, do not need to login again?