Getting database information from SQL Project in C# Project
NickName:Sandri Ask DateTime:2015-02-02T00:46:34

Getting database information from SQL Project in C# Project

I'm working in Visual Studio 2013 in one Solution (MySolution).

From OOP perspective I separate C# code in domain layer in one Project (MyCProject) from the main database who is placed in specific SQL Server Database Project (MySQLProject).

Both projects shared same namespace, are stored in the same MySolution solution.

How can I access the tables data in MySQLProject in MyCProject?

The tables are stored inside the MySQLProject project, but not in SQL Server Express database server who is also installed on the machine, does that affect the accessibility?

At the end, maybe I have not mentioned some relevant information, so if someone can help me I would be very happy if the answer can be little bit detailed like a walk through information sheet. Because I don't know what information is relevant to write so the problem can be resolved in best way as possible.

Copyright Notice:Content Author:「Sandri」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/28265112/getting-database-information-from-sql-project-in-c-sharp-project

More about “Getting database information from SQL Project in C# Project” related questions

Getting database information from SQL Project in C# Project

I'm working in Visual Studio 2013 in one Solution (MySolution). From OOP perspective I separate C# code in domain layer in one Project (MyCProject) from the main database who is placed in specific...

Show Detail

Getting Started with Dapper and SQL Server database

I am working on a personal project to display information on a webpage. I haven't done SQL connections in over a year and this is also my first time using dapper so I am having trouble getting star...

Show Detail

Not able to deploy C# SQL CLR database project from Visual Studio 2010 to SQL Server 2014

I have Visual Studio 2010 Professional and SQL Server 2014. I have created a very simple SQL CLR database application which will just printing a message after an insertion happen in a table. There ...

Show Detail

Bulk Remove Database Objects From Database Project

I'm currently maintaining a SQL Server database that is over 17 years old, and has a large number of unused and outdated artifacts within it. Over the last several months we have been profiling the

Show Detail

Is it possible to reference a Visual Studio SQL project from a non-database project in C#?

I currently am working with an ASP application that includes an Entity Framework model. I would like to separate the model out of this ASP project so that it can be referenced by other projects in an

Show Detail

Getting column information from system MS SQL Server

When I am using the below SQL statement to retrieve the column information of a SQL Server database. I am getting more columns than there actually are I presume this is because of the system column...

Show Detail

Getting information from SQL table with Python

I have a 20gb database file (*.db) that contains a lot of information on scientific articles, acquired from Scopus. Most information is stored in the responses table within the database file. I onl...

Show Detail

How to add SQL Server database file to a C# project?

I'm a beginner using C# and SQL Server, I was about to share the project but my database still needs the main Database.mdf file even after install the project, the question is how to insert or atta...

Show Detail

vb write information from SQL Server database

I use visual basic 2008 and a SQL Server database. I want to write the information stock in the database and I want to be rank like in php I use table to rank information what the method to do that...

Show Detail

Save button not storing information within the sql database

I am new to C# guys so please be kind and any help is appreciated :). My save button is not retaining the information that it should on the sql database and I'm slightly perplexed as to why? This...

Show Detail