I have the code below:
SqlConnection sqlConnection = new SqlConnection(selectedConnStr);
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM " + tableName, sqlConnection);
schema = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection).GetSchemaTable();
Just want to know how can I get the foreign keys from schema?
If i create all of the foreign keys in my sql database and I create a linq to sql item in my project the linqs show on the diagram.
Does this mean that i dont need to create joins in my linq query in my c# code? so i mean my quesry would look something like this
[Code]....
instead of
[Code]....
i have the dataset with one table.Table contains three column like 'Name','Location','Pin'.I would like to move the data from another table based on schema.
View 2 RepliesAm trying to get a working enity model with foreign keys working but have run into a problem. I have imported 3 tables with content and some data.Lets call these tables geo_countries, geo_counties, geo_municipalities and the FK are:1. geo_county have a column country_id wich corresponds to country_id in geo_country 2. geo_municipality have a column county_id wich correspond to the county_id in geo_county.The problem i have is when i try to get correspondig child items with the following code i run into trouble:
[Code]....
The problem above is that 'test' generates results but not 'test2', wich never return anything. Am i not supposed to be able to do it like i do in 'test2'? I earlier tried to add a child object by replacing ToList() with Add() and that worked. But i cant seem to get anything out of it.
I have an MVC3 with EF4 project. I have a screen for order .Order has 2 id's inside it for Billilng and Shipping AddressID .When I go and create a new order these fields render as single textboxes as Ids'Question is how can I render full address textboxes (addressline1,city,state,zip etc) do I have drop in the html markup for them? In that case while capturing the data back I willl have to go with classic way of retrieving name/value pair and then do insert into address bring back that identity and update the order record...?
Create(int customerID,FormCollection fc){}
So the main question is how can I do ModelBinding with foreign keys?
I am using Access 2003 Database and I need to retrieve list of a table's foreign keys and tables they are related to in C#. I used GetSchema() function of OleDbConnection as well as OdbcConnection classes. But It just returns the name of key among few other details.
OdbcConnection con = new OdbcConnection(conStr);
I am developing asp.net MVC3 application and I have following entity
This entity has composite key (CreditRegistryId and Accoubnt No are primary keys). CreditRegistryId is a foreign key as well. How can I make composite key and foreign key. I am using DbContext API from EF 4.1. I am not using edmx ( ORM designer)
[code]...
I have an EF model with a table with several foreign keys. These foreign keys are managed by associations. In code, I can get a strongly typed list of objects when I access that property on the object.
When I generate a strongly typed view, all I see are the int fields. Is there a way to get ASP.NET MVC to bind to the objects that are related as well as the main object?
I just came across some code that seems to encrypt database keys prior to sending them to the client (WebBrowser, Silverlight, etc).
To illustrate, suppose you have a list of students to extra-curricular activities, and a relationship defined between them. Every time the data is written out to the ASPX page, the studentID and activityID is encrypted. Every time a write, or modify is made, this value is sent back to the server, decrypted, and saved to the database.
What could be the reasons to expose data this way? Is this a normal practice?
I am having trouble with foreign keys Dynamic Data and entity framework 4.0. It feels like there is a problem with the entity association but I am not sure. I have multiple fields representing the foreign key on the insert page.
When I try and insert data I get an error A dependent property in a ReferentialConstraint is mapped to a store-generated column.
Column: 'CommentId'
My data is a very basic one to many relationship, the foreign key in question is BookId in the Comment Table.
[code]...
When I let the scaffolding do its thing, I get multiple fields representing the foreign key.
how to handle foreign keys with Entity Framework, when editing or adding a new record. For example, I have a person table, which has a timezone_id linking to my timezone table.
But the model seems to not include timezone_id. I see it's a new way of doing things, but ... how do I store my record?
My method:
[code]...
I can't do u.timezone_id = timezoneid;
I only have u.timezone (which seems to be the actual entity), and u.timezoneReference, which I am not sure what to do with.
I have the following tables in my database which are as given under:
[code]...
My requirement is instead of getting the PromotionID values displayed for columns CustomerPromotionDiscountID & EmployeePromotionDiscountID, it should display the respective DiscountAmount. Which is not happenning for some reason.
I somehow found a workaround where if i define the datatype for columns CustomerPromotionDiscountID and EmployeePromotionDiscountID as nchar or nvarchar, it displays the DiscountAmount.
Wanted to know if there is any better way of doing this without changing the datatype for my columns?
i'll make a simple website. in my website i have two kind of products to sell
1. Projects
2. Documents
These Tables are available in my database :
[code]...
now i will make an order table. should i make differentt order table?
or i could save order information of both tables in one table?
I use Mysql database, in this i create two table A, B. table A column x and is FK of second table B's column m,n,o provide does it possible that x referncing to foreign key of table B columns m, n , and o all.
View 2 RepliesAdding data into kartlar table (RehberID,KampanyaID,BrimID) is ok. But which Kart'ID created? I need to learn which Id created after adding data (RehberID,KampanyaID,BrimID) into Kartlar?
[code]...
How can I do that? I want to get data from Kartlar which data I added?
I have a DataGrid that I need to be able to use to delete records form a file
[Code]....
[Code]....
I use
((TextBox)GridMenuOptions.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
To access the data in the Grid for updating, but it doesn't work for deleting
I can use
string id = GridMenuOptions.DataKeys[e.RowIndex].Value.ToString();
but that only returns the first key.
How do I access the rest of the keys?
I already may have access to the solution i am after but cant find a way to keep the data and schema the same during deployment, ie development server SQL database to be the same thing as what i put on the sql server host during the deployment of the web application
i was using Quest Rocket compare to sync data and schema, it worked fine but they dropped that project with the intro by MS of VS08, ie the Quest plug-in works in VS05 but not in VS08 anyway, i probably have the solution I am after at my disposal due to my MSDN subscription which includes SQL server products, but my first problem there, is that i cant identify which MS tool to download and to use that will do the same thing or better than the Quest Rocket compare product,
i believe the solution i need is the full version of SQL Management Studio (which i think i have due to my MSDN subsctiption but my second problem 2) is i cant find in that full studio download in my MSDN subscriber area) also is it only the full verison of SQL Mgt studio and not the Express version that might have the "sync" capabiltiy, is that correct? or is there a way (I am a intemediate on SQL techonologies), within the Express Management Studio to painlessly sync both the schema and the data? I am using VS08 Pro, so mayber there is a way in the VSIDE to do the syncing, I think i tried the Publisher but ran into difficulties, am going to try that again and repost here what those difficulties were,
SO really just after a nice tool or utility that will keep SQL database schema and data the same during the deployment process for the web application i build, kinda urgent to as am buried and dont have time to breath.
I have 3 different databases where some tables are common.
View 16 RepliesI have a C#/Asp.net web application which caches SQL DB schema information. Is there a way that I can determine what child relationships a given table has? I have looked into using the DataTable.ChildRelations property, but it is never populated with items unless i manually create a relationship using the .add property. I also have access to DataColumn information for each column in the database.
View 4 RepliesI recently installed the latest Oracle Data Provider for .NET(ODP.NET 11.2.0.1.2), due to the fact that Microsoft Oracle Client is deprecated. Ever since the new installation, my SqlDataSource control stopped working. When I try to configure the data source of the SqlDataSource and test the connection, it always gives me the following error message:Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online.
OCIEnvCreate failed with return code -1 but error message text was not available. at DataObjectSupport(721,6)
I know for sure the connection settings are definitely correct and the database is online for sure, because any databinding I did manually works perfectly well. I can manually bind to a Gridview, ListBox controls and display the data without any problem. The only problem I have is using the SqlDataSource. This is painful because Gridview and Listview have a lot of cool built-in features. When you databind the controls in the code behind file, you lose all the features.
I have added ASPNET to the Oracle home directory and granted it full control access and retarted the computer but it doesn't work. I'm using Visual Studio 2010 and the database is Oracle 10g. Does anybody know why I'm having problem with SqlDataSource only?
Is it feasible to generate tables(Relational) from XML schema using VS 2008?
View 5 RepliesI have created database in sql server 2005 using Snowflake model.
Problem :
There is 1 fact table and 3 dimension tables.
Suppose Fact Table has cols : sales_person_id, cust_id, product_id and dimension tables as per id s defined in fact table.
Suppose i want to update products in product table, i am able to do so.
but i can not update product_id in Fact Table because remaining two field will be NULL.
I've created a Data Base project with some CLR functions and stored procedures.
I'd like to deploy the assembly under different schema then the default dbo.
Is it possible?
how do i write my alter schema query in Asp.net
using the sqlclient object..
Cannot seem to find a good fit for my question so I will ask here.
Does Asp.Net 4.0 solve the problems with using Views with EntityFramework is not able to recognize primary keys.