|
That's just one: there are many similar solutions out there: you have to find one and adapt it to your needs.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Do you understand what it is doing?
What didn't work?
If you have a question about a specific difficulty, ask another specific question and you'll likely receive helpful replies.
|
|
|
|
|
Hi @all
This seems to me like a , eh, quite ridiculous question, but I´m absolutely unable to find out where to get the Project Template for Entity Framework in VS2012...trying to do so since round about 50 minutes
What I can do is rightclick under my webproject, select 'Data' and then add a new ADO.NET Entity data model which then will be created under my WebApp-branch...
What I want to do is to add an independent Project in the solution in order to reference it from any project within the solution...
I know this is possible; I've done it two or three times before, but I regrettably forgot how I've done that...
Can anyone please point me to the right direction??
Thanks in advance,
Clodetta
|
|
|
|
|
ok, this is a perfect example of someone failing to use google/bing/whatsoever the correct way with the correct keywords...
But just in case, someone else stumbles over my problem, here´s the solution:
dotnetcurry.com: The answer is – To consume an Entity model in separate projects, you have to create the model in its own project, i.e. a class library project.
complete article
as albert einstein once stated: "human stupidity and the universe are endless... for the second i´m not that sure..."
|
|
|
|
|
You don't have to put it in a sperate project, but it's probably recommended.
There's really isn't a project template. That's why it's so difficult to find! YOu can create a Class Library project, then open the Package Manager console and type Install-Package EntityFramework . Once that's done, you've got a few ways you can go. You can find out about those from here[^].
|
|
|
|
|
oh, ok. few more "tricks" to "entityframework" my solution...
Since this is no day to day job one most likely will forget how to do it after a few weeks...
Thanks for the link!
Kind regards
|
|
|
|
|
what's the fastest way to import fixed len file into sql table?
File is about 5 mil records
|
|
|
|
|
Use a bulk loader. Most database engines provide a dedicated program to do this.
|
|
|
|
|
can I call sql builk insert from .net?
|
|
|
|
|
|
Have a read of this, assuming it's SQL Server
BULK INSERT (Transact-SQL)[^]
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
As other responders have said, use the System.Data.SqlClient.SqlBulkCopy class.
Also, implement your own IDataReader in a class to read the file. The SqlBulkCopy contains a method called WriteToServer which has an overload that takes an IDataReader.
Once this is done, you can simply create an IDataReader using a TextReader (via the class you made) and now you can simply read a row and write the row without using a lot of memory with DataTable or DataSet objects.
|
|
|
|
|
Hi,
You have not mention is that one time or you have text feed in one folder.
Anyway, You can create one SSIS package that can import your file data into sql server. you can schedule your SSIS package if that file is frequently updating. even you can execute package from your Code behind. you can also use bulk insert as other suggested.
Thanks
-Amit Gajjar (MinterProject)
|
|
|
|
|
use a WCF service (WCF Application) and a PDA windows mobile 6.0 how can we draw the position marker on google maps in another project (application winforms).
Application uses winforms web browser to appear Gmap.
and implementation of WCF services hosted on an IIS server.
I have implemented the methods in the WCF service that will be called for by the PDA and returned the postion of GPS (latitude and longitude) until here everything is fine, but I do not know how to get back this position in application winforms for to draw marker
|
|
|
|
|
From your description, it sounds as though you're getting your geolocation back from the WCF service. If you are, you should realise that what you are getting is the location of the machine that hosts the service (providing it has the ability to get the geolocation) and not your PDA.
|
|
|
|
|
yes I can access the server that hosts the WCF service
service that contains two methods:
public double getLatitude(double latitude)
{
return latitude;
}
public double getLongitue(double longitude)
{
return longitude;
}
but the back office side (application winforms): I can not get the result returned by this 2 function,
for use the results returned to draw the marker on gmap (with web browser)
|
|
|
|
|
I'm confused here. You're sending a value to your WCF service and then you're retrieving the same value? What's the point of that?
|
|
|
|
|
Yes, I want to retrieve the same values using a marker to draw on google maps.
I can not find a way (on the application of winforms) to retrieve this same values that returned by the methods
|
|
|
|
|
Let me see if I've got your architecture straight. You have a PDA that you are using to send values to a WCF service. You have a Windows Forms application running somewhere else that you want to retrieve these same values and display them. Is this correct?
|
|
|
|
|
yes, winforms application is apart, it can just connect to the service
|
|
|
|
|
Then your initial premise is wrong. You can't pass a value in from one side and expect the same value to be available at the other side without doing some work. What you could do is write the value to a database at the server, and read it from there using a separate WCF call.
|
|
|
|
|
Thank you for your help Pete O'Hanlon
|
|
|
|
|
Not a problem. There are many ways you could architect this - from using MSMQ over WCF to hosting the WCF server inside your Windows Forms application and having your PDF connect to that.
|
|
|
|
|
I used below regular experssion to Not allow double quotes in textbox but it didn't work .
(I need to allow single quotes)
<asp:RegularExpressionValidator ID="rwvFilter" runat="server" ControlToValidate="txtFilter"
ErrorMessage="Filter is not valid" CssClass="error-message" ValidationExpression="@\\""></asp:RegularExpressionValidator>
|
|
|
|
|
Our IT, a very elaborate production environment, is rather involved and I'm try to write a GUI front end that will help visualize the layout and help in troubleshooting.
For remote consoles were using VNC, and it can be spawned from inside an application. But this does not appear to be the same case with Microsoft Management Console(MMC). How can I spawn a remote console to any server and get the GUI that I would get in MMC. Any direction would great. Technologies I may be missing etc. Thanks guys.
Gregg
|
|
|
|