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 am working on NHibernate with oracle in ASP.Net. Now i am trying TDD(Test Driven Development). Can you tell me the best way to develop the TDD for NHibernate with oracle?I am using MbUnit with microdesk but it is not better approach for oracle but SQL server.
View 1 RepliesI 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]...
Is the any term like Oracle Fragments.Someone asked me about oracle fragments and if we can join them and how. I din't knew about it.
View 1 RepliesI'm working with Oracle database and I want to improve performance of my website.I read about caching. So is it possible to implement caching (SQL Server Database Dependency) with oracle?
View 2 RepliesI need to connect to oracle database (10g) which is on differenet server.
Can i use the latest ODP.net provider or i need to use ODP.net provider related to oracle 10g only? After installing the ODP.Net what are the next steps to do in order to connect to database. This is totally new to me (connecting to oracle... i have worked with sql databases till now...)
I have to automate one database process in .Net web applicaiton which uses Oracle 11g Database as Backend.
I need to know two things:
(1) How to check space on Oracle database server? I need space on server and not in the Database itself. My process creates few tables so I want to make sure that we have sufficient space before the process starts.
(2) Also I need to create script to backup Indexes and Triggers on the table so that I can recreate them after data transfer process is completed. Any idea how to create script form c# code?
We are building an ASP.NET application with C#.net language and Oracle 9i database. Here we installed Oracle 9i client software on our PCs.We never worked on Oracle 9i database. It's the first time.We are planning to build stored procedures in Oracle database and call them from our ASP.NET application. Does working with Oracle stored procedures and ASP.NET is similar to that of working with MS SQL Server stored procedures and ASP.NET?
View 1 RepliesI have two databases. One from Oracle 10g. Another from Mysql. I have configured my web application with Nhibernate for Oracle and now I am in need of using the MySQL database. So how can i configure the hibernate.cfg.xml so that i can use both of the database at the same application?
My current hibernate.cfg.xml is:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>[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]....
This is related to a previous question I asked, regarding splitting a asp.net mvc web application into two apps - one public, and one admin. Both of them would be sharing the same database of course.
With two web apps I'll have two host applications and so two seperate Nihbernate session factories. My concern is that their seperate data caches will cause all sorts of problems.
While posting this, I looked at this question, which covers a similar problem (for a different reason). I really don't want to have to set up some kind of distributed cache just for a low use admin application.
How can this be resolved? Is separating the admin section into it's own application not possible with NHibernate without drastic measures?
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 RepliesBasically I want to JOIN a table from a MySQL database to a table from a MSSQL database. The reason is because I don't own the MySQL database and I only have SELECT privileges to it. For my ASP.NET application, I need to create two new tables. I have my own MSSQL DB and I have an SA account for it. Is this possible?
This is how I connect to MySQL:
[Code]....
I think the problem here is that I need 2 open database connections for the DataAdapter to use?
here's the situation:
You're using NHibernate with Fluent NHibernate for mappings.
You have an application in production with a database with live data You're adding a new feature in development and it requires a new database column.
The new column cannot be blank. For example, I recently had to a DateCreated column to a table and the app now uses that date. As the only time the data will be missing is now, it seems unnecessary to add code to check for errors.
In my application I have an updater which can execute a SchemaUpdate to add the new database column - however, the application will starting crashing as it is expecting a value in the new column.
I need to get some sensible default data into that column. In this case I manually ran an Update to set the date to the current date (good enough for the situation). In this particular case I believe that you cannot set the column default to getdate() using fluent mappings.
Keep a schema version number in a config file In the updater that runs SchemaUpdate start adding upgrade methods for each version. These methods would run updates to add default data (or other required actions).
After the schema update has been run, call all methods required for a version greater than the current version (i.e. those that haven't previously been run). So if the app is now version 4 and version 2 is installed, methods 3 and 4 would be run.
How can I write a unit test for CRUD using in memory database with fluent nhibernate
View 2 RepliesOne customer is asking me if it is possible to access an Oracle database from his .NET website using VPN. I googled around and didn't find much on this subject.
View 4 RepliesHow do I connect to an Oracle 11g database using asp.net3.5? what is the name space and how to write connection string in web.config file?
View 1 RepliesI m working on A Ware house management Software.
I have used oracle in back end. I have goodsmaster table, sales return table, sales table, invoice table,etc
So i have to update qty on stock when i enter any entry in my sales return page of asp.net from goods master table..
I have Oracle (10g Express Edition) installed on one pc.
Visual Studio 2008 SP1 is installed on another pc.
I want to run an ASP.NET web app that uses the remote database. The two PCs are connected by a LAN (wired) connection. How can I connect to the database? What will the connection string be? The operating system on both PCs is Windows XP.
i have visual studio 2005, asp.net c#.
i want to store the uploaded files to database.
if possible tell me how to get the file properties of the uploaded files such as file name, file created date and file extension.
i am using oracle database. visual studio 2005,asp.net c#. i want to upload the images to oracle database. I need help for creating the Database table also (i know to create database table, but i don't know abt creating image table (blob or clob));
View 2 RepliesI have two tables Users (Userid, Name, PhoneNumber) Applications (ApplicationsId,UserId, ApplicationName, ActiveDate)
Every user will have more than 1 application.
In Nhibernate using lazy loading I can get the users data along with all the applications for every user. So, I used to do something like user.applications[i].Applicationname to get all the applications.
But, Now how do i retrieve all the applications along with the users data using oracle commands. I know how to get one application using joins. But, how do i retrieve multiple applications and store it in a IList.
how i can use Oracle database with asp.net mvc 2 web application?
View 3 RepliesHow to intregrate an oracle database with an asp.net web application?... Any good tutorial to start with?
View 1 Replies